Facilitating the spread of knowledge and innovation in professional software development



Choose your language

InfoQ Homepage News Google Extends Their Services with Cloud SQL

Google Extends Their Services with Cloud SQL


Google is making MySQL available in the cloud as a fully managed service, including a JSON API for programmatic management.

Google is expanding their cloud services with yet another addition, Cloud SQL. This “fully managed” web service offers a a scalable MySQL database running on Google’s infrastructure. Customers are given several ways to connect to a MySQL instance in the cloud: command prompt, API console, admin and reporting tools, external applications, GAE Java & Python applications, and GAE scripts. Instances can be imported/exported with mysqldump.

Google is also making available an experimental JSON API, a RESTful interface providing programmatic administrative capabilities for MySQL: creating, deleting, restarting, restoring from backup, importing/exporting and getting various information about instances.

Although Google provides both command line and API administration capabilities, MySQL instances are automatically managed, being synchronously or asynchronously replicated across different geographic locations, scaled up/down as needed, backup and patched as required.

There are some limitations: user-defined functions and native MySQL replication are not supported. Also a number of MySQL statements are not supported (PDF): INSTALL/UNINSTALL PLUGIN, CREATE FUNCTION, and a few others.

On the heels of Google’s announcement, Amazon reminded customers that AWS RDS has provided MySQL in the cloud since 2009. They have also offered Oracle Database and Microsoft SQL Server since 2012. Amazon has finally decided to take AWS RDS out of beta, announcing general availability and a SLA with “99.95% availability for Multi-AZ database instances on a monthly basis.”

A direct comparison of pricing shows that AWS RDS is cheaper than corresponding Google Cloud SQL pay-per-hour options, but one needs to consider other costs such as data storage and transfer fees, etc. We can say though that Google Cloud SQL supports instances up to 100GB in size while Amazon RDS goes up to 3TB. Also, Google does not offer a SLA.

None of the two companies provides Postgres in the cloud. This can be obtain through third parties, such as Heroku which offers Postgres as a service on AWS.

We need your feedback

How might we improve InfoQ for you

Thank you for being an InfoQ reader.

Each year, we seek feedback from our readers to help us improve InfoQ. Would you mind spending 2 minutes to share your feedback in our short survey? Your feedback will directly help us continually evolve how we support you.

Take the Survey

Rate this Article


Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Community comments

  • Cloud SQL will be better

    by Eddie Mayan,

    Your message is awaiting moderation. Thank you for participating in the discussion.

    RDS is very famous tool regarding database service of Amazon (AWS), But Google will overtake easily.

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p


Is your profile up-to-date? Please take a moment to review and update.

Note: If updating/changing your email, a validation request will be sent

Company name:
Company role:
Company size:
You will be sent an email to validate the new email address. This pop-up will close itself in a few moments.