Cloud Mysql comparison _ MySQL

Cloud Mysql compared an article on Sitepoint, comparing aws rds, Google Cloud SQL, ClearDB, and Xeround four Cloud-based Mysql products, including their functions, prices, limits, and other factors. Reference:

Even though all providers offer a hosted MySQL database, there are some differences. You will find limitations:

• Xeround: Limitation in full MySQL compatibility, like ALTER table functions, log files and more. Seerelease notes. These limitations are mostly in place to make dynamic scalability possible.
• Google Cloud SQL: Limitation in full MySQL compatibility, and features like user defined functions and MySQL replication. SeeFAQ.

Amazon RDS for MySQL and Google Cloud SQL are pretty straightforward cloud-based MySQL instances, without much juice to it but with the added benefit of being in the cloud (when it comes to scaling up or down, easy cloning etc .). they simply allow you to host your database in their cloud infrastructure, with the above limitations. amazon RDS for MySQL also has the option to have a replication standby in case of failure of your main database, and offers automatic backups.

Selecting one of them depends mostly on which infrastructure you use to run your main applications. amazon RDS wocould be the best fit if you host them on EC2 for example, because of low latencies. but the combo isn' t required, you can host a Google Cloud SQL database with an EC2 server.

Xeround en ClearDB take it up a notch, by providing high availability (100% uptime), easy backups and geo-distribution. xeround tops it off with dynamic scalability for keeping up with size and throughput requirements. they both try to make it much easier for you to host your database in the cloud, without worrying about what happens when a node fails. they both run on Amazon AWS, as well as Rackspace Cloud and HP Cloud (Xeround) or Microsoft Azure (ClearDB ).

Click here for the complete document.