BT

Facilitating the Spread of Knowledge and Innovation in Professional Software Development

Write for InfoQ

Topics

Choose your language

InfoQ Homepage News Google Cloud SQL Supports MySQL 8.0

Google Cloud SQL Supports MySQL 8.0

This item in japanese

Google Cloud has recently made MySQL 8.0 available on Cloud SQL, the managed relational database service for MySQL, PostgreSQL, and SQL Server.

Cloud SQL now supports MySQL 8.0, 5.7, and 5.6, and provides up to 416 GB of RAM and 30 TB of data storage for every managed database. Developers can make use of private services access and VPC Service Controls, using Google Cloud VPC, to secure connectivity to a MySQL 8.0 instance.

Among the new features available with MySQL 8.0 on Google Cloud are instant DDL statements that offer improved responsiveness and availability in production environments. Kovid Rathee, senior consultant at Servian, writes about the announcement and the new features:

MySQL 8 comes with a fantastic set of features like online DDL, the much awaited window functions, enhanced JSON features, recursive common table expressions (CTEs) for hierarchical querying, default UTF8MB4 collation & encoding, soft deletes, invisible indexes, descending indexes, staged rollouts and more.

Explaining one of the main benefits of running MySQL 8.0 on Cloud SQL, he adds:

The Cloud SQL Proxy allows a user with the appropriate permissions to connect to a Second Generation Cloud SQL database without having to deal with IP whitelisting or SSL certificates manually.

Gabriela D'Ávila Ferrara, data engineer and developer advocate for Google Cloud, highlights instead how to migrate to CloudSQL and the new version:

You can start using today from scratch or migrate an existing MySQL database to Cloud SQL; as a way to minimize downtime you can use the External Replication feature from your Google Cloud Console or via the gcloud command-line tool.

For more than two years MySQL 8.0 has been generally available and Google is not the first cloud provider offering it as a managed service. Amazon RDS supports it since October 2018, but Amazon Aurora is still only compatible with MySQL 5.6 and 5.7. Azure Database for MySQL introduced support for MySQL 8.0 at the end of 2019, while Oracle recently launched the MySQL Database Service in the Oracle Cloud Infrastructure, with support for MySQL 8.0.

Amazon RDS currently supports minor versions up to 8.0.20, Google Cloud is launching with 8.0.18, while Azure supports 8.0.15. Oracle instead promises to be always up-to-date with the latest MySQL Server release, currently 8.0.21.

Frederic Descamps, MySQL evangelist, points out that with MySQL 5.6 EOL approaching in February 2021, it is important to move now to the latest version of MySQL:

MySQL 8.0 has been the release with the fastest rate of adoption. But some people are still very conservative and I understand that too. However, it’s time to upgrade if you are still running MySQL 5.6.

Rate this Article

Adoption
Style

BT