This page covers the different machine series options that you can choose for your Cloud SQL instance, and the configurations, storage options, and limitations for each option.
Cloud SQL offers different machine series options to choose from when setting up your instance that depend on your instance's Cloud SQL edition. A machine series is a curated set of processor and hardware configurations optimized for specific Cloud SQL workloads. These machine series options let you tailor vCPU and memory for your instance, and optimize performance for different demands. The machine series you select also determines the storage option available for your Cloud SQL instance.
Each machine series offers multiple machine types. When you create an instance,
you select a machine type from the machine series you want to use, which defines
the resource and storage option available for your instance. For example, if you
select the db-perf-optimized-N-2 machine type, which is part of the
N2machine series, then the storage option available to your instance is
SSD.
Machine series supported by Cloud SQL
The following table provides an overview of the machine series options supported by Cloud SQL based your instance's Cloud SQL edition and the storage options available for each machine series:
| Cloud SQL edition | Machine series | Storage option |
|---|---|---|
| Cloud SQL Enterprise Plus edition | N2 | SSD |
| Memory-optimized-N2 | SSD | |
| Cloud SQL Enterprise edition | Dedicated core | SSD |
Machine series availability for Cloud SQL Enterprise Plus edition instances
For Cloud SQL Enterprise Plus edition instances, you can choose one of the following machine series:
- N2: this machine series provides a balanced price-to-performance ratio for a variety of Cloud SQL workloads.
- Memory-optimized-N2: this machine series provides high memory-to-compute ratios for memory-intensive Cloud SQL workloads.
For Cloud SQL Enterprise Plus edition instances, each machine series offers predefined machine types with preset memory and vCPUs for your instances. Availability is dependent on your instance's Cloud SQL edition, region, and database version.
N2 machine series
N2 machine series provides a balanced price-performance for a wide variety of database workloads, with a memory-to-compute ratio of 1 vCPU:8GB RAM. N2 machine series uses the Performance Persistent Disk (PD-SSD) storage option. For more information about storage types, see Cloud SQL storage options overview.
N2 machine types
This following machine types are available for instances for the N2 machine series:
| Machine type | vCPUs | Memory (GB) | Optional Data Cache (GB) |
|---|---|---|---|
db-perf-optimized-N-2 |
2 | 16 | 375 |
db-perf-optimized-N-4 |
4 | 32 | 375 |
db-perf-optimized-N-8 |
8 | 64 | 375 |
db-perf-optimized-N-16 |
16 | 128 | 750 |
db-perf-optimized-N-32 |
32 | 256 | 1,500 |
db-perf-optimized-N-48 |
48 | 384 | 3,000 |
db-perf-optimized-N-64 |
64 | 512 | 6,000 |
db-perf-optimized-N-80 |
80 | 640 | 6,000 |
db-perf-optimized-N-96 |
96 | 728 | 6,000 |
db-perf-optimized-N-128 |
128 | 864 | 6,000 |
Memory-optimized-N2
The memory-optimized-N2 machine series provides high
memory-to-compute ratios for memory-intensive workloads.
The memory-optimized-N2 machine series uses the
Performance Persistent Disk (PD-SSD) storage option. PD-SSD is a Persistent Disk
volumes offering that provides Cloud SQL instances with
lower latency and more IOPS, and is backed by solid-state drives (SSD). For more
information, see About Persistent Disk.
Memory-optimized-N2 machine types
This following machine types are available for instances
for the memory-optimized-N machine series:
| Machine type | vCPUs | Memory (GB) | Optional Data Cache (GB) |
|---|---|---|---|
db-memory-optimized-N-4 |
4 | 128 | 750 |
db-memory-optimized-N-8 |
8 | 256 | 1,500 |
db-memory-optimized-N-16 |
16 | 512 | 3,000 |
Machine series availability for Cloud SQL Enterprise edition instances
For Cloud SQL Enterprise edition instances, Cloud SQL offers shared core or dedicated core machine series. Shared core offers machine types with predefined CPUs (cores) and amount of memory for your instances.
Dedicated cores are custom instance configurations that let you select the amount of memory and CPUs that your instance needs. This flexibility lets you choose the appropriate VM shape for your workload.
Custom machine type names use the following format: db-custom-{CPUs}-{Memory}.
When you select the number of CPUs and amount of memory, there are some
restrictions on the configurations that you can choose:
- vCPUs must be either 1 or an even number between 2 and 96.
- Memory must be:
- 0.9 to 6.5 GB per vCPU
- A multiple of 256 MB
- At least 3.75 GB (3840 MB)
Pricing
The machine series you select affects the cost of your instance. For more information, see Instance pricing. You can also use the pricing calculator to see pricing for various scenarios.