Instance Settings

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


Setting Modifiable after creation? Possible values
Instance ID N Composed of lowercase letters, numbers, and hyphens; must start with a letter.
Database version N PostgreSQL 9.6
Region N asia-east1 — Taiwan
asia-northeast1 — Tokyo
asia-south1 — Mumbai
australia-southeast1 — Sydney
europe-west1 — Belgium
europe-west2 — London
europe-west3 — Frankfurt
southamerica-east1 — São Paulo
us-central1 — Iowa
us-east1 — South Carolina
us-east4 — Northern Virginia
us-west1 — Oregon
Zone Y The possible values depend on the region.
Cores Y 1 to 64 (must be either 1 or an even number)
Partial for shared vCPU
Memory Y 0.9 to 6.5 GiB per vCPU (must be a multiple of 256 MiB and at least 3.75 GiB)
Storage type N SSD (default value)
Storage capacity Y
(Increase only)
Instances with at least one (unshared) vCPU can have up to 10230 GB.
Instances with a shared vCPU can have up to 3062 GB.
Automatic storage increase Y On (default value)
Automatic storage increase limit Y In GiBs. 0 (the default) means there is no limit.
Backups Y
On (default value)
Maintenance window Y Day of the week, and hour.
Maintenance timing Y Any (default value)
Authorized networks Y IP addresses or ranges of addresses, in CIDR notation.
Activation policy Y ALWAYS
Database flags Y See Configuring Database Flags.
Instance ID
The instance ID is the name of the instance. It is used to uniquely identify your instance within the project. Choose an instance name that is aligned with the purpose of the instance when possible. Instance names must have 98 characters or less. You do not need to prepend the project ID onto the instance ID. This is done automatically where appropriate (for example, in the log files).
The Google Cloud Platform region where your instance is located. To improve performance, keep your data close to the services that need it. For more information, see Instance Locations.
The Google Cloud Platform zone where your instance is located. If you are connecting from a Compute Engine instance, select the zone where the Compute Engine instance is located. Otherwise, you should accept the default zone. For more information, see Instance Locations.
The number of CPUs for your instance. You can also choose to create an instance with less than one CPU (a shared code instance, or shared vCPU).
The amount of memory available for your instance. For performance-sensitive workloads such as online transaction processing (OLTP), a general rule of thumb is to make sure that your instance has enough memory to contain the entire working set. However, there are other factors that can impact memory requirements, such as number of active connections. You should perform load testing to avoid performance issues in production.
Database version
Unless you need a capability provided only by a specific version, you should accept the default database version.
Storage type
Choosing SSD, the default value, provides your instance with SSD storage. SSDs provide lower latency and higher data throughput. If you do not need high-performance access to your data, for example for long-term storage or rarely accessed data, you can reduce your costs by choosing HDD.
Storage capacity
Choose a capacity to fit your database size. After you have created your instance, you can increase your storage capacity, but you cannot decrease it. The amount of storage capacity allocated for your instance affects the cost of your instance.
Automatic storage increase

If this setting is enabled, your available storage is checked every 30 seconds. If available storage falls below a threshold size, additional storage capacity is automatically added to your instance.

The size of the threshold and the amount of storage that is added to your instance depends on the amount of storage currently provisioned for your instance, up to a maximum size of 25 GB. The current storage capacity is divided by 25, and the result rounded down to the nearest integer. This result is added to 5 GB to produce both the threshold size and the amount of storage that is added in the event that the available storage falls below the threshold.

Threshold for an instance with 66 GB storage capacity:

5 + (1/25th of 66-GB capacity) = 5 + (66/25) = 5 + 2.6 -> 5 + 2 = 7 GB
Threshold for an instance with 130 GB storage capacity:
5 + (1/25th of 130-GB capacity) = 5 + (130/25) = 5 + (5.2) -> 5 + 5 = 10 GB
Threshold for an instance with 1000 GB storage capacity:
5 + (1/25th of 1000-GB capacity) = 5 + (1000/25) = 5 + 40 -> min(45, 25) = 25 GB
Automatic storage increase limit

If the automatic storage increase setting is enabled, this setting optionally imposes a limit on how large the storage for your instance can automatically grow. Because storage size cannot be decreased, this limit can prevent your instance from growing its storage size to an unnecessarily large size due to a temporary increase in traffic. Keep in mind, however, that when an instance stops being able to add storage that it needs, it is likely to stop accepting incoming connections, and could go offline.

Setting this limit to zero, the default value, means that there is no limit (other than the maximum available storage for the instance tier).

This setting determines whether automated backups are performed.
Maintenance window

The day and hour when disruptive updates (updates that require an instance restart) to this Cloud SQL instance can be made. If the maintenance window is set for an instance, Cloud SQL does not initiate a disruptive update to that instance outside of the window. The update is not guaranteed to complete before the end of the maintenance window, but restarts typically complete within a couple of minutes.

If you do not specify a maintenance window, disruptive updates can happen at any time, although they generally only occur every few months.

Read replicas do not support the maintenance window setting; they can experience a disruptive upgrade at any time.

Maintenance timing

This setting lets you provide a preference about the relative timing of instance updates that require a restart. Receiving updates earlier lets you test your application with an update before your instances that get the update later.

The relative timing of updates is not observed between projects; if you have instances with an earlier timing setting in a different project than your instances with a later timing setting, Cloud SQL makes no attempt to update the instances with the earlier timing setting first.

If you do not set the Maintenance timing setting, Cloud SQL chooses the timing of updates to your instance (within its Maintenance window, if applicable).

The Maintenance timing setting does not affect the software version Cloud SQL applies to your instance.

Authorized networks
You can add specific IP addresses or ranges of addresses to open your instance to those addresses. This is required if you do not use the Cloud SQL Proxy.

For information about configuring IP addresses, see Configuring IP connectivity.

For information about configuring the Cloud SQL Proxy, see Using the Proxy.

Activation policy
The activation policy is used only to start or stop the instance. Setting the activation policy to ALWAYS starts the instance, and setting it to NEVER stops the instance and prevents further instance charges.
Database flags
You can set specific database flags on the Cloud SQL instance.

For a complete list of the Cloud SQL flags you can set, see Configuring Cloud SQL Flags.

Impact of changing instance settings

For most instance settings, Google Cloud SQL applies the change immediately and connectivity to the instance is unaffected.

Changing the number of CPUs, memory size, or the zone of the instance results in the instance going offline for several minutes. You should plan to make these kind of changes when your application can handle an outage of this length.

What's next

Send feedback about...

Cloud SQL for PostgreSQL