|Setting||Modifiable after creation?||Possible values|
|Instance ID||N||Composed of lowercase letters, numbers, and hyphens; must start with a letter.|
|Zone||Y||The possible values depend on the region.|
PostgreSQL 11 (default)
PostgreSQL 10 (beta) PostgreSQL 9.6
|Private IP||After it is configured, it cannot be disabled.||Configured or not.|
|Public IP||Y||Enabled or disabled.|
|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.|
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)|
SSD (default value)
Instances with at least one (unshared) vCPU can have up to 30,720 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.|
On (default value)
|Maintenance window||Y||Day of the week, and hour.|
Any (default value)
|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.
The total length ofYou do not need to include the project ID in the instance name. This is done automatically where appropriate (for example, in the log files).
project-ID:instance-IDmust be 98 characters or less.
You cannot reuse an instance name for up to a week after you have deleted the instance....see naming guidelines
- 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).
For some sample core and memory combinations, see Sample machine types.
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.
For some sample core and memory combinations, see Sample machine types.
- 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. For more information, see Storage and Networking Pricing.
For read replicas, the storage capacity must always be at least as high as the storage capacity of the master. When a master instance is resized, all read replicas will be resized, if needed, so that they have at least as much storage capacity as the updated master.
- Automatic storage increase
If you enable this setting, Cloud SQL checks your available storage every 30 seconds. If the available storage falls below a threshold size, Cloud SQL automatically adds additional storage capacity. If the available storage repeatedly falls below the threshold size, Cloud SQL continues to add storage until it reaches the maximum of 30 TB.
The automatic storage increase setting of a master instance automatically applies to any read replicas of that instance. The automatic storage increase setting cannot be independently set for read replicas.
The threshold size depends on the amount of storage currently provisioned for your instance; it cannot be larger than 25 GB.
For instances provisioned with 500 GB of storage (or more), the threshold is always 25 GB.
For instances provisioned with less than 500 GB of storage, this formula is used to calculate the threshold:
5 + (provisioned storage)/25
The result of the division is rounded down to the nearest whole number.
Threshold calculation for an instance with 66 GB storage capacity:
5 + (1/25th of 66 GB) = 5 + (66/25) = 5 + 2.6 -> 5 + 2 = 7 GBThreshold calculation for an instance with 1000 GB storage capacity:
5 + (1/25th of 1000 GB) = 5 + (1000/25) = 5 + 40 = 45 -> maximum value of 25 GB
Amount of storage added
The amount of storage added to the instance is equal to the threshold size.
- Automatic storage increase limit
If you enable the automatic storage increase setting, you can provide a specific limit on how large the storage for your instance can automatically grow. You cannot decrease storage size, so this limit can prevent your instance size from growing unnecessarily large (due to a temporary increase in traffic). Keep in mind that when an instance becomes unable to add storage that it needs, the instance likely will 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).
The automatic storage increase limit setting of a master instance automatically applies to any read replicas of that instance. The automatic storage increase limit setting cannot be independently set for read replicas.
- 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.
Read replicas do not support the maintenance window setting; they can experience a disruptive upgrade at any time.
Failover events do not occur during a maintenance window.
- 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.
- Private IP
- Configures your instance to use private IP. Learn more.
- Public IP
- If enabled, your instance is allocated a public IPv4 address. When you disable Public IP, that address is released; you can reenable Public IP later, but you will receive a different IPv4 address. By default, the public IP address is blocked for all addresses. Use Authorized networks to enable access.
- You can add specific IP addresses or ranges of addresses to
open your instance to those addresses.
For information about configuring IP addresses, see Configuring IP connectivity.
- Activation policy
- You change the activation policy by starting and stopping the instance. Stopping the instance prevents further instance charges.
- Database flags
You can set specific database flags on the Cloud SQL instance.
For a complete list of the database flags you can set, see Configuring Database Flags.
Impact of changing instance settings
For most instance settings, 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.
- Learn how to edit your instance.
- Learn more about database flags.
- Learn how to authorize IP access for your instance.
- Learn more about replication options.
- See pricing for your instance.
- Learn more about options for connecting to your instance.
- Learn how to configure an IP address for your instance.