This page describes the advantages of Cloud SQL for MySQL Second Generation, and some of the differences between Second Generation instances and First Generation instances.
Cloud SQL Second Generation is the latest version for Cloud SQL for MySQL. Second Generation instances support most of the features of First Generation instances, and offer higher performance and storage capacity at a lower cost.
For a high-level list of Cloud SQL features, see Features.
For help with migrating an existing Cloud SQL instance to Second Generation, see Migrating an instance to Second Generation.
Advantages of using Cloud SQL Second Generation instances
The advantages of using Second Generation instances include:
- Up to 7X throughput and 20X storage capacity of First Generation instances
- Less expensive than First Generation for most use cases
- Option to add High Availability failover and read replication Learn more.
- Configurable backup period and maintenance window
- Proxy support Learn more.
- Private IP support Learn more.
Differences between Second Generation and First Generation instances
If you have been using First Generation instances, the following list of differences between First Generation instances and Second Generation instances can help you plan for the differences between the two instance types.
- Pricing differences
- Cloud SQL Second Generation does not provide a per-use pricing package; instance pricing is determined by the machine type. With the introduction of per-minute billing and sustained use discounts, Cloud SQL Second Generation can be more cost effective for many workloads. For more information, see the Pricing page.
- On Demand activation policy
- Second Generation instances do not support the On Demand activation policy. Only Always On and Off are supported.
- IPv6 connectivity
- IPv6 connectivity is not supported for Second Generation instances. IPv4 connectivity is fully supported. For information about configuring an IPv4 address, see Configuring IP Access.
- Storage engine support
- For Second Generation instances, InnoDB is the only supported storage engine. For more information, see the FAQ.
- GTID Replication
- Second Generation instances use GTID replication. This means that certain SQL statements and operations are not allowed. For more information, see Differences between Cloud SQL and standard MySQL functionality.
- MySQL versions
- Second Generation instances support MySQL 5.7 and MySQL 5.6.
- Import requirements
- Second Generation instances apply tighter controls on imports. Before you export data for import into a Second Generation instance, be sure to use the instructions in Exporting Data for Import into Cloud SQL.