Storage options overview

This page covers the storage options supported by Cloud SQL, and some key considerations for selecting the storage option that best fits your instance's needs.

The storage options available for your Cloud SQL instance depend on the machine series you choose. To find which storage option is available for your instance's machine series, see Machine series availability .

Cloud SQL supports solid-state drive (SSD) for Cloud SQL for SQL Server instances.

Solid-state drive (SSD)

The solid-state drive (SSD) option is available for Cloud SQL Enterprise edition instances and Cloud SQL Enterprise Plus edition instances using the Memory-optimized-N2 machine series only.

The SSD storage option provides an efficient and cost-effective option for your Cloud SQL Cloud SQL Enterprise edition instances. When compared to a hard disk drive , SSD is faster and brings more predictable performance. SSD has high write and read throughput, and maintains low latency with data access. This makes it a great option to store active data that requires frequent and low-latency access.

SSD is a Persistent Disk volumes offering that provides durable network storage devices and is suitable for enterprise applications and high-performance databases that require lower latency and more IOPS. For more information, see About Persistent Disk .

IOPs and throughput for SSD storage type are set based on the machine type and storage capacity you set. You can't configure the values for IOPS and throughput.

Cloud SQL Enterprise Plus edition SSD IOPS and throughput limits

The following table shows the maximum values for IOPS and throughput for the SSD storage option based on the number of vCPUs for Cloud SQL Enterprise Plus edition instances using the N2 machine series :

vCPUs Maximum read IOPS Maximum write IOPS Maximum read throughput (MiB/s) Maximum write throughput (MiB/s)
2
15,000 15,000 240 240
4
15,000 15,000 240 240
8
15,000 15,000 800 800
16
25,000 25,000 1,200 1,200
32
60,000 60,000 1,200 1,200
48
60,000 60,000 1,200 1,200
64
60,000 80,000 1,200 1,200
80
60,000 80,000 1,200 1,200
96
60,000 80,000 1,200 1,200
128
60,000 80,000 1,200 1,200

Cloud SQL Enterprise edition SSD IOPS and throughput limits

The following table shows the maximum values for IOPS and throughput for the SSD storage option based on the number of vCPUs for Cloud SQL Enterprise edition instances:

vCPUs Maximum read IOPS Maximum write IOPS Maximum read throughput (MiB/s) Maximum write throughput (MiB/s)
1
15,000 15,000 200 200
2-7
15,000 15,000 240 240
8-15
15,000 15,000 800 800
16-31
25,000 25,000 1,200 1,200
32-63
60,000 60,000 1,200 1,200
64+
100,000 100,000 1,200 1,200

What's next

Create a Mobile Website
View Site in Mobile | Classic
Share by: