About instance settings

This page provides information about the settings available for Cloud SQL instances.

Settings for Cloud SQL for MySQL

Setting Modifiable after creation? Possible values
Instance ID N Composed of lowercase letters, numbers, and hyphens; must start with a letter. The total length must be 98 characters or less.
Region N For Cloud SQL Enterprise Plus edition:
africa-south1 — Johannesburg
asia-east1 — Taiwan
asia-east2 — Hong Kong
asia-northeast1 — Tokyo
asia-northeast2 — Osaka
asia-northeast3 — Seoul
asia-south1 — Mumbai
asia-south2 — Delhi
asia-southeast1 — Singapore
asia-southeast2 — Jakarta
australia-southeast1 — Sydney
australia-southeast2 — Melbourne
europe-central2 — Warsaw
europe-north1 — Finland
europe-southwest1 — Madrid
europe-west1 — Belgium
europe-west2 — London
europe-west3 — Frankfurt
europe-west4 — Netherlands
europe-west6 — Zürich
europe-west8 — Milan
europe-west9 — Paris
europe-west10 — Berlin
europe-west12 — Turin
me-central1 — Doha
me-central2 — Dammam
me-west1 — Tel Aviv
northamerica-northeast1 — Montréal
northamerica-northeast2 — Toronto
southamerica-east1 — San Paulo
southamerica-west1 — Santiago
us-central1 — Iowa
us-east1 — South Carolina
us-east4 — Northern Virginia
us-east5 — Columbus
us-south1 — Dallas
us-west1 — Oregon
us-west2 — Los Angeles
us-west3 — Salt Lake City
us-west4 — Las Vegas

For Cloud SQL Enterprise edition:
africa-south1 — Johannesburg
asia-east1 — Taiwan
asia-east2 — Hong Kong
asia-northeast1 — Tokyo
asia-northeast2 — Osaka
asia-northeast3 — Seoul
asia-south1 — Mumbai
asia-south2 — Delhi
asia-southeast1 — Singapore
asia-southeast2 — Jakarta
australia-southeast1 — Sydney
australia-southeast2 — Melbourne
europe-central2 — Warsaw
europe-north1 — Finland
europe-north2 — Stockholm
europe-southwest1 — Madrid
europe-west1 — Belgium
europe-west2 — London
europe-west3 — Frankfurt
europe-west4 — Netherlands
europe-west6 — Zürich
europe-west8 — Milan
europe-west9 — Paris
europe-west10 — Berlin
europe-west12 — Turin
me-central1 — Doha
me-central2 — Dammam
me-west1 — Tel Aviv
northamerica-northeast1 — Montréal
northamerica-northeast2 — Toronto
northamerica-south1 - Mexico
southamerica-east1 — São Paulo
southamerica-west1 — Santiago
us-central1 — Iowa
us-east1 — South Carolina
us-east4 — Northern Virginia
us-east5 — Columbus
us-south1 — Dallas
us-west1 — Oregon
us-west2 — Los Angeles
us-west3 — Salt Lake City
us-west4 — Las Vegas
Zone Y The possible values depend on the region.
Database version N For Cloud SQL Enterprise Plus edition, MySQL 8.0.31 and later: 
Console string      API enum string
MySQL 8.4           MYSQL_8_4
MySQL 8.0 (default) MYSQL_8_0
For Cloud SQL Enterprise edition: 
Console string       API enum string
MySQL 8.4            MYSQL_8_4
MySQL 8.0 (default)  MYSQL_8_0
MySQL 5.7            MYSQL_5_7
MySQL 5.6            MYSQL_5_6
SSL mode Y Enforces/enables SSL as follows:
  • ALLOW_UNENCRYPTED_AND_ENCRYPTED: allows non-SSL/non-TLS and SSL/TLS connections. For SSL connections, the client certificate isn't verified. This is the default value.
  • ENCRYPTED_ONLY: only allows connections encrypted with SSL/TLS.
  • TRUSTED_CLIENT_CERTIFICATE_REQUIRED: only allows connections encrypted with SSL/TLS and with valid client certificates.
Server CA mode N

Lets you configure the server certificate authority (CA) for an instance. You can select one of the following available server CA options:

  • GOOGLE_MANAGED_INTERNAL_CA: this is the default value for instances created with the gcloud CLI, the Cloud SQL Admin API, or Terraform. With this option, an internal CA dedicated to each Cloud SQL instance signs the server certificate for that instance.
  • GOOGLE_MANAGED_CAS_CA: with this option, a CA hierarchy consisting of a root CA and subordinate server CAs managed by Cloud SQL and hosted on Google Cloud Certificate Authority Service (CA Service) is used. The subordinate server CAs in a region sign the server certificates and are shared across instances in the region. For Cloud SQL Auth Proxy connections, to connect to an instance configured with the shared CA option, use the Cloud SQL Auth Proxy version 2.13.0 or later.
  • CUSTOMER_MANAGED_CAS_CA: with this option, you manage the CA hierarchy and the rotation of CA certificates. Before you can create an instance with this option, using CA Service, you create a CA pool in the same region as your instance and at least one CA in that pool. When you create your instance, you specify the CA pool. Your request is delegated to a project-specific service account, which has the permission to use the CA pool. The service account requests a CA from the pool and Cloud SQL uses that CA to sign the server certificate for the instance. For Cloud SQL Auth Proxy connections, to connect to an instance configured with the customer-managed CA option, use the Cloud SQL Auth Proxy version 2.14.3 or later.

For more information, see Certificate authority (CA) hierarchies.
Set edition Y

ENTERPRISE or ENTERPRISE PLUS
Set password policy Y Configured or not.
Private IP After it's activated, it can't be deactivated. Activated or deactivated.
Public IP Y Activated or deactivated.
Authorized networks Y If Public IP is enabled, IP addresses authorized to connect to the instance. You can also specify this value as an IP address range, in CIDR notation.
Private path for Google Cloud services Y Activated or deactivated.
Data cache Y Activated or deactivated.
Machine type Y Machine type is based on the machine series you select for your Cloud SQL instance. Select from C4A, N2, shared core or dedicated core machine series. Learn more
Cores Y For Cloud SQL Enterprise Plus edition:
2 to 128 (predefined machine types only)

For Cloud SQL Enterprise edition:
1 to 96 (must be either 1 or an even number)
Partial for shared vCPU
Memory Y For Cloud SQL Enterprise Plus edition: 6.75 GB to 8 GB per vCPU.
The 6.75 GB to 1 vCPU ratio is for the db-perf-optimized-N-128 machine type only. All other machine types have the 8 GB to 1 vCPU ratio.
For Cloud SQL Enterprise edition: 0.9 GB to 6.5 GB per vCPU (must be a multiple of 256 MB and at least 3.75 GB).
Storage type N SSD (default value)
HDD(Cloud SQL Enterprise edition only)
Hyperdisk Balanced(Cloud SQL Enterprise Plus edition only)
Storage capacity Y
(Increase only)		 Standard and high memory machine types: up to 64 TB.
Shared-core machine types (db-f1-micro and db-g1-small): up to 3054 GB.

Note that creating or increasing storage capacity to 64 TB might increase latency of common operations, such as backups, dependent on your workload.
Hyperdisk settings Y This setting is only applicable for Cloud SQL Enterprise Plus edition instances using the C4A machine series.

Provisioned IOPS: 4,000 (default value)
Provisioned throughput: 170 (default value)

For more information about Hyperdisk settings, see Hyperdisk Balanced.
Enable automatic storage increases Y On (default value)
Off
Data encryption method N Google-owned and Google-managed encryption key (default value)
Cloud KMS key
Automatic storage increase limit Y In GBs. 0 (the default) means there is no limit.
Automated backups Y
(select a preferred 4-hour window, or Any (default))		 On (default value)
Off
Locations options Y Multi-region (default value)
Region

There is also a drop-down menu with a list of multi-regions when you select Multi-region or regions when you select Region.