Introduction to Cloud SQL editions (original) (raw)
This page describes Cloud SQL editions and key features.
Cloud SQL offers the following editions to support your various business and application needs. Each edition provides different performance and availability characteristics to meet the needs of your applications.
- Cloud SQL Enterprise edition: provides all core capabilities of Cloud SQL and is suitable for applications requiring a balance of performance, availability, and cost.
- Cloud SQL Enterprise Plus edition: provides the best performance and availability to run applications requiring the highest level of availability and performance in addition to the capabilities of the Cloud SQL Enterprise edition.
Cloud SQL editions features
The following table provides an overview of the features available for each edition:
| Cloud SQL Enterprise edition | Cloud SQL Enterprise Plus edition | |
|---|---|---|
| Pricing model | Cloud SQL Enterprise pricing | Cloud SQL Enterprise Plus pricing |
| Database versions | MySQL 5.6, 5.7, 8.0, 8.4 PostgreSQL 9.6, 10, 11, 12, 13, 14, 15, 16, 17 SQL Server 2022 (Standard, Enterprise, Express, and Web)SQL Server 2019 (Standard, Enterprise, Express, and Web)SQL Server 2017 (Standard, Enterprise, Express, and Web) | MySQL 8.0, 8.4 PostgreSQL 12, 13, 14, 15, 16, 17 SQL Server 2022 EnterpriseSQL Server 2019 Enterprise |
| Machine series | Shared or dedicated core | N2 C4A Memory-optimized-N (for SQL Server) |
| Machine configuration limits | Up to 96 vCPU Up to 624 GB RAM 1:6.5 core:memory ratio | N2 machine series Up to 128 vCPU Up to 864 GB RAM 1:8 core:memory ratio C4A machine series (for MySQL and PostgreSQL) (Preview) Up to 128 vCPU Up to 864 GB RAM 1:8 core:memory ratio Memory-optimized (for SQL Server) Up to 16 vCPU Up to 512 GB RAM 1:32 core:memory ratio |
| Availability SLA | 99.95% | 99.99% |
| Maintenance downtime | < 60 seconds (MySQL) < 30 seconds (PostgreSQL) < 120 seconds (SQL Server) | < 1 second (MySQL) < 1 second (PostgreSQL) < 120 seconds (SQL Server) |
| Data cache | No | Yes |
| Point-in-time log retention | Up to 7 days | Up to 35 days |
Performance enhancements
Cloud SQL Enterprise Plus edition is ideal for applications that require maximum performance. Cloud SQL Enterprise Plus edition for SQL Server delivers up to 4x improved read performance compared to Cloud SQL Enterprise edition.
Cloud SQL Enterprise Plus edition offers the following performance enhancements:
For all instances
- Improved read performance using data cache: Data cache leverages a fast, local SSD to store data pages that are read frequently. For MySQL and PostgreSQL instances, you can get up to three times improvement in read performance compared to reading from a persistent disk. Data cache is an optional feature and can be enabled during instance creation or after the instance has been created.
For MySQL and PostgreSQL instances only
- Enhanced write performance: Cloud SQL Enterprise Plus edition delivers up to two times the improvement in write latency. This makes it suitable for write-intensive applications requiring low latency and high throughput.
- Engine autotuning: autotune engine configurations to match the capabilities of the underlying instance platform.
For SQL Server instances only
- Better performance with two machine families with higher memory per vCPU: to meet the needs of your demanding SQL Server workloads, choose between performance-optimized machines with 1 vCPU:8GB of RAM and memory-optimized machines with 1 vCPU:32GB of RAM.
Availability enhancements
Cloud SQL Enterprise Plus edition provides the following major availability enhancements:
- Advanced disaster recovery (DR): you can simplify recovery and fallback processes after you perform cross-region failover. With advanced DR, you can:
- Choose a cross-region disaster recovery (DR) replica
- Perform replica failover
- Restore your original deployment by using zero data loss switchover
For more information, see Advanced disaster recovery (DR)and Use advanced disaster recovery (DR).
For MySQL and PostgreSQL instances only
- Near-zero downtime: with Cloud SQL Enterprise Plus edition, you can maintain near-zero downtime for your instance when you perform any of the following management tasks:
- Perform or simulate a planned maintenance update event on a standalone primary instance
- Enable or disable data cache
- Scale up the compute size (vCPU, memory) of your Cloud SQL instance as many times you like
- Scale down the compute size (vCPU, memory) of your Cloud SQL instance once every three hours
- Perform an in-place upgrade to Cloud SQL Enterprise Plus edition
Near-zero downtime is available for Cloud SQL for PostgreSQL and Cloud SQL for MySQL instances.
Pricing
For more information about Cloud SQL editions pricing, seeCloud SQL pricing.
This section provides answers to frequently asked questions about Cloud SQL editions.
Does Cloud SQL Enterprise Plus edition support all engines?
Yes. Cloud SQL Enterprise Plus edition is supported on Cloud SQL for MySQL, Cloud SQL for PostgreSQL, and Cloud SQL for SQL Server.
How is Cloud SQL pricing changing?
Cloud SQL for MySQL and Cloud SQL for PostgreSQL instances that you created before July 12, 2023, have become Cloud SQL Enterprise edition instances with no change in features or pricing. Instances created after July 12, 2023 can be either Cloud SQL Enterprise edition or Cloud SQL Enterprise Plus edition.
Cloud SQL for SQL Server instances that you created before August 1, 2024, have become Cloud SQL Enterprise edition instances with no change in features or pricing. Instances created after August 1, 2024 can be either Cloud SQL Enterprise edition or Cloud SQL Enterprise Plus edition.
Cloud SQL Enterprise Plus edition has a new pricing structure. For more information about Cloud SQL pricing, see Cloud SQL pricing.
What can I do to prepare for these changes?
You can create Cloud SQL Enterprise Plus edition and Cloud SQL Enterprise edition instances in regions where supported using Google Cloud console and gcloud CLI.
Can I mix and match editions?
Yes, you can. Cloud SQL Enterprise Plus edition and Cloud SQL Enterprise edition provide different levels of database performance availability and data protection capabilities. You can select the Cloud SQL editions that best meets your varying application needs.
Can I migrate between editions?
By using in-place upgrade, you can upgrade your instances to Cloud SQL Enterprise Plus edition or switch to Cloud SQL Enterprise edition.
You can move your Cloud SQL for MySQL and Cloud SQL for PostgreSQL instances between Cloud SQL Enterprise edition and Cloud SQL Enterprise Plus edition withDatabase Migration Service using the following two ways: