About SRGArticlesRecruitment Information
About SRGArticlesRecruitment Information
HOME/Articles/What is Cloud SQL Enterprise Plus?

What is Cloud SQL Enterprise Plus?

This is Oniumi (@fat47) from the Service Reliability Group (SRG) of the Technology Headquarters.
#SRG(Service Reliability Group) mainly provides cross-sectional support for the infrastructure of our media services, improving existing services, launching new ones, contributing to OSS, etc.
This article explains the new features added to CloudSQL Enterprise Plus announced by Google Cloud Platform.
 

What is CloudSQL Enterprise Plus?

This is an edition of CloudSQL that was GA released in July 2023.
The existing CloudSQL will be called "CloudSQL Enterprise" and
"CloudSQL Enterprise Plus" has been announced, which adds additional functionality to the previous version of CloudSQL.
Supported databases are MySQL 8.0, PostgreSQL 14, 15.
 
In this article, we will focus on the case of MySQL.
 

Additional features in Enteriprise Plus

Improved availability

99.99% SLA
By the way, the old CloudSQL was 99.95%.

Improved performance

Up to 2x faster write latency
Up to 3x increase in read throughput
Optionally, you can use a new feature called data caching.
A fixed amount of SSD is assigned according to the machine type and can be used as an expansion area for the buffer pool.
When data caching is enabled,
  • Read: Main memory → Data cache → Instance storage
  • Write: Write to the data cache at the same time as committing to the instance's storage
This is the behavior.

Improved maintenance

During planned maintenance, rolling updates occur in the background, keeping downtime to less than 10 seconds.
With the old CloudSQL it was less than 60 seconds.

Improved data protection

Log retention period for PITR extended up to 35 days
*MySQL is not yet implemented, but support is planned.
 

Enteriprise Plus Pricing

It's roughly 30% more than the old CloudSQL.
For details, please check the Pricing section at the reference URL below.
CloudSQL Pricing　より引用
CloudSQL PricingQuoted from
 

Additional information about data caching

One use case where this is especially useful is when your dataset is too large to fit into a regular buffer pool.
In addition, it is said that the performance improvement is greater when the target instance has 16 or more vCPUs.
 
When the data cache becomes full, data that is accessed less frequently is evicted.
The data cache will not disappear even if the instance is restarted, either by the user or the system.
However, if the primary instance is shut down due to a failover operation, the data cache will be cleared and performance may be degraded until the data is refilled.
The data cache does not store redo logs or binary logs.
 

How to get started with CloudSQL Enterprise Plus

Just select Plus when creating CloudSQL.
There is currently no functionality that allows you to migrate existing CloudSQL to Plus.
To migrate from an existing environmentDatabase Migration ServiceYou will need to use something like this to transfer your data.
I'm looking forward to the fact that they plan to implement a feature that allows in-place migration in the future.
 

Conclusion

I believe that the added features of CloudSQL Enterprise Plus make it even easier to use managed databases.
Personally, I really like the improved performance and the reduced downtime that comes with improved maintenance.
 
Although there will be a slight increase in costs, I think it may be possible to cover the costs by reducing the instance size and number of units as a result of improved performance.
I feel like this update gives me hope for future evolution, so I'm looking forward to it.
 
SRG is looking for people to work with us. If you are interested, please contact us here.
 
SRG runs a podcast where we chat about the latest hot topics in IT and books. We hope you will enjoy listening to it while you work.