Recent Articles

Google has made it easier for developers to lash on-premises databases to its cloud by implementing the MySQL Wire Protocol in its Cloud SQL service.

By adding in wire protocol support for MySQL on Wednesday to Cloud SQL, the company has given programmers a multitude of options for how they manage, interface, shift data in and out, and replicate data to or from, the service.

"We are embracing open standards and expanding customers’ choice of tools, technologies and architectures," Google said.

Some uses of the new capability include low-latency connections into Google's "Compute Engine" infrastructure-as-a-service or "App Engine" platform-as-a-service, the company wrote, along with use of tooling such as Toad or the MySQL command-line tool to manage cloud instances.

"The connections are handled in the same way we handle HTTP traffic: we terminate the TCP connection close to the clients and then proxy the bytes to the server," a Google spokesman told El Reg.

"These run standard MySQL, which handles the query. The work has been to ensure the connections are highly secure, take advantage of the fact users' data is replicated in multiple locations, and have low latency from GCE [Google Compute Engine] instances."

Though the company is migrating all of its internal MySQL instances over to MariaDB due to political disagreements with Oracle, it is still pushing on with MySQL as a publicly accessible cloud service.

Google said it had no current plans to implement support for MariaDB in Cloud SQL, when we asked. ®