What is Cloud SQL Enterprise Plus?
This is Oniumi (@fat47) from the Service Reliability Group (SRG) of the Technology Headquarters.
#SRG(Service Reliability Group) is a group that mainly provides cross-sectional support for the infrastructure of our media services, improving existing services, launching new ones, and contributing to OSS.
This article explains the new features added to CloudSQL Enterprise Plus, announced by Google Cloud Platform.
What is CloudSQL Enterprise Plus?Additional Features with Enteriprise PlusImproved availabilityImproved performanceImproved maintenanceImproved data protectionEnteriprise Plus PricingAdditional information about data cachingHow to get started with CloudSQL Enterprise PlusConclusion
What is CloudSQL Enterprise Plus?
This is an edition of CloudSQL that was generally released in July 2023.
The existing CloudSQL will be called "CloudSQL Enterprise"
"CloudSQL Enterprise Plus" has been announced, which adds additional functionality to the previous CloudSQL.
Supported databases are MySQL 8.0, PostgreSQL 14, and 15.
In this article, we will focus on the case of MySQL.
Additional Features with 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 faster read throughput
Optionally, you can use a new feature called data caching.
A fixed capacity SSD is provided depending on 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: Writes to the data cache at the same time as committing to the instance's storage
This is what happens.
Improved maintenance
During planned maintenance, rolling updates are performed 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 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 in the reference URL below.
Additional information about data caching
One use case where this is particularly useful is when the dataset is too large to fit into a regular buffer pool.
Additionally, it is said that performance improvements are significant 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 persists 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 or other reason, the data cache will be lost and performance may be degraded until the data is re-populated.
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 to migrate existing CloudSQL to Plus.
To migrate from an existing environmentDatabase Migration ServiceYou will need to use something like this to transfer the 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 have made it even more convenient to use a managed database.
Personally, I really like the improved performance and the reduced downtime that comes with improved maintenance.
Although the cost will increase slightly, I think it may be possible to cover the costs by reducing the instance size and number of units due to 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're interested, please contact us here.
SRG runs a podcast where we chat about the latest hot topics in IT technology and books. We hope you'll listen to it while you work.