In a major move forward for its cloud, Google has added support for native MySQL connections for developers, allowing external applications to connect to a Google Cloud SQL instance using the MySQL Wire Protocol (or MWP), the standard connection protocol for MySQL databases.
According to an blog post from product manager Joe Faith, native connectivity provides great flexibility and control over managing and deploying databases in the cloud. It makes it easy for developers to access cloud databases as easily as if it were running on their laptop. It now makes Cloud SQL available from nearly any application, anywhere, including low-latency connections from those running on Google Compute Engine and App Engine.
With its new support of MWP, Google is urging those using the Google custom JDBC driver for MySQL database connections to migrate to MWP because of its greater speed, usability and compatibility.
One of the major use cases for MWP support is replication to external MySQL databases for low latency connections and migration. SaaS provider Genoo put native connectivity to use when migrated Genoo’s database to another environment without any service disruption to its live applications.
This functionality has also found its way into services. Database software developer CodeFutures uses its dbShards/Migrate software with Cloud SQL and the MWP connection to provide fast and seamless data migration. “Our methods allows you to do a seamless migration, without any extended downtime,” CodeFutures CEO Cory Isaacson said in a statement provided in a case study (PDF).
Allowing native MySQL connections represents, as some have noted, an attempt by Google to support more third-party tools as opposed to its own in-house tools. Since many are familiar with MySQL, this development will make it easier for many to migrate existing applications, and use their existing MySQL open source tools and knowledge.
Others have noted that Google’s MySQL support is lagging behind that of Amazon’s cloud platform. Yet, while Google may be playing catchup, developers are certainly excited about the implications of native connections.
This makes me happy. Cloud Platform Blog: Google Cloud SQL now accessible from just about any application, anywhere http://t.co/N0iBgfJ0yp
— Will Decker (@wdeckr) November 1, 2013