Cloud SQL for MySQL

editions is a tier-based pricing model where each edition
provides different performance, availability, observability, and data protection
characteristics to support your various business and application needs.
Cloud SQL offers the following editions:

- **[Cloud SQL Enterprise Plus edition](https://docs.cloud.google.com/sql/docs/mysql/editions-intro.md.txt#enhancements)**: provides the best performance,
  availability, and observability to run applications. These are in addition
  to the core capabilities of Cloud SQL.

- **Cloud SQL Enterprise edition**: provides all core capabilities of Cloud SQL
  and is suitable for applications requiring less stringent availability
  and performance requirements.

## Default Cloud SQL edition

If you don't specify an edition when you create a primary instance using the
[gcloud CLI](https://docs.cloud.google.com/sdk/gcloud.md.txt) or the Cloud SQL Admin API, then the default Cloud SQL edition
depends on the database version of the instance:

- **Cloud SQL Enterprise Plus edition (`ENTERPRISE_PLUS`)** : MySQL 8.4 and MySQL 9.7 (`MYSQL_8_4`
  and `MYSQL_9_7`).

- **Cloud SQL Enterprise edition (`ENTERPRISE`)** : MySQL 5.6, MySQL 5.7, and MySQL 8.0
  (`MYSQL_5_6`, `MYSQL_5_7`, and `MYSQL_8_0`), or when you don't specify a
  database version.

In the Google Cloud console, Cloud SQL Enterprise Plus edition is selected by default when you create a
new primary instance. When you create a read replica without specifying an
edition, the read replica inherits the Cloud SQL edition of its primary
instance.

## Cloud SQL editions features

The following table provides an overview of key features enhancements available
for Cloud SQL Enterprise Plus edition when compared to Cloud SQL Enterprise edition:

|   | **Cloud SQL Enterprise Plus edition** | **Cloud SQL Enterprise edition** |
|---|---|---|
| **[Database versions](https://docs.cloud.google.com/sql/docs/db-versions.md.txt)** | MySQL 8.0, 8.4, 9.7 > [!NOTE] > **Note:** If the database version for your instance is MySQL 8.4 or MySQL 9.7, then the default Cloud SQL edition is Enterprise Plus. | MySQL 5.6, 5.7, 8.0, 8.4, 9.7 > [!NOTE] > **Note:** If the database version for your instance is MySQL 8.0 or earlier, then the default Cloud SQL edition is Enterprise. |
| **[Availability SLA](https://cloud.google.com/sql/sla)** | 99.99% (includes maintenance) | 99.95% (excludes maintenance) |
| ***Performance*** |||
| **[Machine series](https://docs.cloud.google.com/sql/docs/mysql/machine-series-overview.md.txt)** | N2 C4A C4 C4D | General purpose shared core General purpose dedicated core N4 |
| **[Machine configuration limits](https://docs.cloud.google.com/sql/docs/mysql/instance-settings.md.txt#machine-type-2ndgen)** | **N2 machine series** Up to 128 vCPU Up to 864 GB RAM 1:8 core:memory ratio **C4A machine series** Up to 72 vCPU Up to 576 GB RAM 1:8 core:memory ratio **C4 machine series** Up to 8 vCPU Up to 62 GB RAM 1:7.5 to 1:7.75 core:memory ratio **C4D machine series** Up to 192 vCPU Up to 1,512 GB RAM 1:7.5 to 1:7.875 core:memory ratio | **General purpose shared core** 1 vCPU Up to 1.7 GB RAM 1:6.5 core:memory ratio **General purpose dedicated core** Up to 96 vCPU (up to 80 vCPU in [select regions](https://docs.cloud.google.com/sql/docs/mysql/region-availability-overview.md.txt#enterprise-edition-regions)) Up to 624 GB RAM 1:6.5 core:memory ratio **N4 machine series** Up to 80 vCPU Up to 624 GB RAM 1:8 core:memory ratio |
| **[Data cache](https://docs.cloud.google.com/sql/docs/mysql/data-cache.md.txt)** | Yes | No |
| **[Optimized writes](https://docs.cloud.google.com/sql/docs/mysql/flags.md.txt#tips-optimized-write)** | Yes | No |
| **[Point-in-time log retention](https://docs.cloud.google.com/sql/docs/mysql/backup-recovery/pitr.md.txt)** | Up to 35 days | Up to 7 days |
| **[Read pools](https://docs.cloud.google.com/sql/docs/mysql/about-read-pools.md.txt)** | Yes | No |
| ***Availability*** |||
| **[Maintenance downtime](https://docs.cloud.google.com/sql/docs/mysql/maintenance.md.txt)** | [\< 1 second](https://docs.cloud.google.com/sql/docs/mysql/maintenance.md.txt#nearzero) | [\< 60 seconds](https://docs.cloud.google.com/sql/docs/mysql/maintenance.md.txt#maintenance-impact) |
| **[Planned operations downtime](https://docs.cloud.google.com/sql/docs/mysql/maintenance.md.txt#nearzero)** | Sub-second downtime | Few minutes |
| **[Advanced disaster recovery (DR)](https://docs.cloud.google.com/sql/docs/mysql/use-advanced-disaster-recovery.md.txt)** | Yes | No |
| **[Write endpoint for advanced disaster recovery (DR)](https://docs.cloud.google.com/sql/docs/mysql/use-advanced-disaster-recovery.md.txt)** | Yes | No |
| **[Write endpoint connectivity](https://docs.cloud.google.com/sql/docs/mysql/connect-to-instance-using-write-endpoint.md.txt)** | Yes | No |
| **[Managed Connection Pooling](https://docs.cloud.google.com/sql/docs/mysql/managed-connection-pooling.md.txt)** | Yes | No |
| ***Observability*** |||
| **[AI-assisted troubleshooting](https://docs.cloud.google.com/sql/docs/mysql/observe-troubleshoot-with-ai)** | Yes | No |
| **[Query insights](https://docs.cloud.google.com/sql/docs/mysql/using-query-insights.md.txt)** | 30 day metric retention 1 MB query length 200 query plan sample maximum Wait event analysis Index advisor recommendations | 7 day metric retention 4500 bytes query length 20 query plan sample maximum |
| **[Enhanced recommenders](https://docs.cloud.google.com/sql/docs/mysql/recommender-enterprise-plus.md.txt)** | Yes | No |

## Cloud SQL Enterprise Plus edition enhancements

Cloud SQL Enterprise Plus edition is ideal for applications that require the best performance,
availability, and observability.

### Performance

Cloud SQL Enterprise Plus edition offers the following performance enhancements:

- **Improved read performance**: delivers up to 4x improved read performance using the data cache, which leverages a fast, local SSD to storage data pages that are read frequently.

<!-- -->

- **Enhanced write performance**: delivers up to 3x higher write throughput and up to 98% lower write latency, which 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.
- **Enhanced storage**: high performance network block storage service, managed by Google Cloud Hyperdisk that offers scalability with a suite of data persistence and management capabilities.
- **Managed read pools**: operational simplicity and scaling for your large read workloads using autoscaling.

<!-- -->

- **Better performance with enhanced machine series options**: high performance machine series availability that provides a balanced price-to-performance ratio, or optimized price-performance to deliver consistent performance for high-demand workloads.

### Availability

Cloud SQL Enterprise Plus edition provides the following availability enhancements:

- **Near-zero downtime**: sub-second downtime for maintenance and planned operations, including patching and scaling.
- **Advanced disaster recovery** (DR): configure disaster recovery with cross-regional replication for failover, and perform disaster recovery drills with zero data loss and minimal recovery time objective (RTO).

<!-- -->

- **Managed Connection Pooling**: optimize database connection management for your instances using pooling.

### Observability

Cloud SQL Enterprise Plus edition provides the following observability enhancements:

- **Query insights**: advanced query performance diagnostics and filtering with up to 30-day metric retention, up to 1 MB query length limit, and a 200 query plan sample maximum.
- **Enhanced metrics**: fine-grained metrics such as wait events and granular query plan samples for faster root-cause analysis and intelligent index recommendations.
- **AI-assisted troubleshooting**: resolve complex database performance issues like slow queries and high database load with predictive and prescriptive troubleshooting.

## How can I upgrade to the Cloud SQL Enterprise Plus edition?

You can upgrade your Cloud SQL instances to the Cloud SQL Enterprise Plus edition using
[in-place upgrade](https://docs.cloud.google.com/sql/docs/mysql/upgrade-cloud-sql-instance-to-enterprise-plus-in-place)
with sub-second downtime. After the upgrade is complete, your instance retains
the configurations set prior to the upgrade.

## Regional availability

For detailed information about available Cloud SQL regions, and what
editions and machines series are supported in each region, see
[Region availability overview](https://docs.cloud.google.com/sql/docs/mysql/region-availability-overview.md.txt).

## Pricing

For more information about Cloud SQL editions pricing, see
[Cloud SQL pricing](https://cloud.google.com/sql/pricing).

## Cloud SQL editions FAQs

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.

### 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](https://docs.cloud.google.com/sql/docs/mysql/upgrade-cloud-sql-instance-to-enterprise-plus-in-place),
you can upgrade your instances to Cloud SQL Enterprise Plus edition
with near-zero downtime
or switch to Cloud SQL Enterprise edition.

### What if a Cloud SQL instance was created before the Cloud SQL editions launch?

Cloud SQL Enterprise edition supports all existing capabilities of Cloud SQL
available as of July 12, 2023, at the same price. All existing instances before
the launch of Cloud SQL editions on July 12, 2023 are updated to a
Cloud SQL Enterprise edition instance automatically.