MySQL 如何在云上托管 sql 数据库?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/19392110/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to host an sql database on a cloud?
提问by user2884344
How do you host an Mysql database that can be accessed by different websites on a cloud, such as google drive and ubuntu one. Is it even possible to do this? If so how is it done, because so many businesses that use Mysql databases start up on a cloud. Can it be done for free?
你如何在云端托管一个可以被不同网站访问的Mysql数据库,比如google drive和ubuntu one。甚至有可能做到这一点吗?如果是怎么做的,因为很多使用Mysql数据库的企业都是在云上启动的。可以免费做吗?
回答by Michael - sqlbot
There are two primary ways of setting up a cloud-hosted MySQL database: either you set up a cloud-hosted virtual server and install MySQL Server on it... or you set up a cloud-hosted, managed, MySQL-only service, which gives you access to the MySQL server component, but not to the underlying operating system, which is maintained by the service provider.
设置云托管 MySQL 数据库的主要方法有两种:设置云托管虚拟服务器并在其上安装 MySQL 服务器……或者设置云托管、托管、仅限 MySQL 的服务,这使您可以访问 MySQL 服务器组件,但不能访问由服务提供商维护的底层操作系统。
http://aws.amazon.com/free/explains the free tier service offering from Amazon Web Services (AWS), which is the cloud hosting provider that I use. The Relational Database Service (RDS) offers a small ("micro") MySQL server with 640 MB of RAM and 20 GB or hard drive space for no monthly charge for the first 12 months. After the first year, that server will cost you $18.75/month. Servers with substantially more capacity are also available at monthly prices that increase with memory and hard drive storage space... but you only pay for what you use for as long as you use it. If you start up a large server and then shut it down almost immediately, for example, you'd only pay for the hours that it was running.
http://aws.amazon.com/free/解释了 Amazon Web Services (AWS) 提供的免费套餐服务,AWS 是我使用的云托管服务提供商。关系数据库服务 (RDS) 提供一个小型(“微型”)MySQL 服务器,具有 640 MB 的 RAM 和 20 GB 或硬盘空间,前 12 个月不收取月费。第一年后,该服务器将花费您 18.75 美元/月。容量大得多的服务器也以每月价格提供,随着内存和硬盘驱动器存储空间的增加而增加……但您只需为使用时间付费。例如,如果您启动一个大型服务器,然后几乎立即关闭它,您只需为它运行的小时数付费。
You can also get complete servers, not just the MySQL component, for deploying your applications, web servers, etc. In AWS, that service is called Elastic Compute Cloud (EC2).
您还可以获得完整的服务器,而不仅仅是 MySQL 组件,用于部署您的应用程序、Web 服务器等。在 AWS 中,该服务称为 Elastic Compute Cloud (EC2)。
Beyond something very small like the offerings in the AWS free tier, you are not going to get anything "free."
除了像 AWS 免费套餐中的产品这样非常小的东西之外,您不会获得任何“免费”的东西。
You access such a server the same way you access any MySQL server: over TCP, either over the Internet (using SSL if you care about security) or over a virtual private network (VPN).
您可以像访问任何 MySQL 服务器一样访问此类服务器:通过 TCP,通过 Internet(如果您关心安全性,请使用 SSL)或通过虚拟专用网络 (VPN)。
回答by Kristi Anderson
Re: the alternatives comment, outside of Amazon RDS, there is also ScaleGrid, Compose, and Azure Database that provide managed MySQL hosting solutions. All are fully managed with varying capabilities and offer free trials. Any free plan will be very limited, and are usually designed for dev/test environments.
回复:替代评论,在 Amazon RDS 之外,还有提供托管 MySQL 托管解决方案的 ScaleGrid、Compose 和 Azure 数据库。所有这些都通过不同的功能进行全面管理,并提供免费试用。任何免费计划都非常有限,通常是为开发/测试环境设计的。
You can compare MySQL providershere to see the different benefits of each. Disclaimer - I work at ScaleGrid.
您可以在此处比较 MySQL 提供程序以查看每个提供程序的不同优势。免责声明 - 我在 ScaleGrid 工作。