How to host sql database in the cloud?

Question

How do you host the Mysql database, which can be accessed by various websites in the cloud, such as Google and ubuntu. Is it possible to do this? If so, how is this done because so many enterprises that use Mysql databases run in the cloud. Can this be done for free?

Answer 1

There are two main ways to configure the MySQL cloud database: either you install a virtual server with a cloud connection, or you install the MySQL server on it ... or you created a cloud-based, MySQL-controlled service, which is only a service that gives you access to the MySQL server component, but not to the underlying operating system that is supported by the service provider.

http://aws.amazon.com/free/ explains the Amazon Web Services (AWS) free service level offer I use for cloud hosting. The Relational Database Service (RDS) offers a small ("micro") MySQL server with 640 MB of RAM and 20 GB or hard disk space without a monthly fee for the first 12 months. After the first year, this server will cost you $ 18.75 per month. Servers with significantly higher bandwidth are also available at monthly prices, which increase with memory and hard drive space ... but you only pay for what you use as long as you use it. If you start a large server and then close it almost immediately, for example, you will only pay for the hours of operation.

You can also get full servers, not just the MySQL component, for deploying your applications, web servers, etc. In AWS, this service is called Elastic Compute Cloud (EC2).

Apart from something very small, similar to AWS free offers, you won’t get anything “free”.

You get access to the same server as you would any MySQL server: over TCP, either over the Internet (using SSL, if you care about security), or through a virtual private network (VPN).

Answer 2

For comments on alternatives other than Amazon RDS, there are also ScaleGrid, Compose, and Azure Database, which provide managed solutions for hosting MySQL. All of them are fully managed with various features and offer free trial versions. Any free plan will be very limited and usually designed for development / testing environments.

You can compare the MySQL providers here to see the various benefits of each. Disclaimer - I work at ScaleGrid.