Google Cloud recently announced the Cloud SQL Enterprise Plus edition for MySQL and PostgreSQL of the managed database service. The new edition provides performance optimizations for read and write operations, improved machine types and configurations, and an integrated SSD–backed data cache option.
According to the cloud provider, the Cloud SQL Enterprise Plus edition for MySQL delivers up to 3x higher read throughput and up to a 2x improvement in write latency compared to the existing Cloud SQL. Furthermore, the new option reduces downtime for maintenance operations and provides 35 days of log retention for compliance requirements. Andi Gutmans, VP of engineering at Google Cloud Databases, highlights the advantages of the new configurable data cache:
Data cache leverages flash memory as a way to transparently extend caches based on DRAM, lowering read latency, improving throughput, and scaling to larger data sets. Additionally, software optimizations deliver up to a 2x reduction in transaction commit latency and up to a 2x improvement in write throughput, making Cloud SQL the best destination for your most demanding MySQL workloads.
The data cache is available only for the MySQL engine. Cloud SQL Enterprise Plus offers a 99.99% availability SLA inclusive of maintenance, with a reduce planned downtime of fewer than 10 seconds.
Cloud SQL supports up to 96 CPUs and 624 GB of memory for the Enterprise edition and up to 128 CPUs and 864 GB of memory for the new Enterprise Plus edition, with pricing varying according to the region. The new edition costs on average 30% more than the existing one but Gutmans comments:
The cost difference depends on your workload as you may not need to provision the same size instance with Enterprise Plus. So suggest understanding the cost difference to benchmark on a representative workload.
As part of the announcement, the cloud provider renamed the existing version of Cloud SQL to Cloud SQL Enterprise. While user abhigm highlights on Reddit the lack of an inbuilt proxy or connection pooler, user OnTheGoTrades comments:
Cool. Too bad you can’t simply upgrade to Enterprise Plus with just a few clicks. Looks like you have to completely migrate from Enterprise to Enterprise Plus.
Currently, migrating an existing database to a Cloud SQL Enterprise Plus edition requires the use of the Database Migration Service, while an in-place upgrade option is expected to be available in the future. The new edition is accessible in a subset of regions, including Iowa, South Carolina, Belgium, Taiwan, and Singapore.
Cloud SQL is not the only option to run a PostgreSQL database on Google Cloud, with AlloyDB for PostgreSQL another managed option for enterprises.
The cloud provider expects to release a version of Cloud SQL Enterprise Plus for SQL Server at a later stage.