CloudSQL Instance settings: GCP Data Engineer

  1. Home
  2. CloudSQL Instance settings: GCP Data Engineer

In this, we will learn the concept of CloudSQL Instance settings.


Settings Modifiable after creation? Possible values
Instance ID N Composed of lowercase letters, numbers, and hyphens; must start with a letter.
Region N GCP regions
Zone Y The possible values depend on the region.
Database version N MySQL 5.7 (default)
MySQL 5.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.
Machine type (Tier) Y GCP tiers
Storage type N SSD (default value)
Storage capacity Y
(Increase only)
Standard and high memory machine types: up to 30,720 GB.
Shared-core machine types (db-f1-micro and db-g1-small): 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.
Auto backups Y On (default value)
Maintenance window Y Day of the week, and hour.
Maintenance timing Y Any (default value)
Activation policy Y ALWAYS
Database flags Y  


Instance ID

  • The instance ID is the name of the instance.
  • Uniquely identify instance within the project.
  • Instance name be aligned with the purpose of the instance when possible.
  • The total length of project-ID:instance-ID must be 98 characters or less.
  • You do not need to include the project ID in the instance name. This is done automatically where appropriate (for example, in the log files).
  • You cannot reuse an instance name for up to a week after you have deleted the instance.


Storage capacity

  • is the capacity to fit database size.
  • After instance creation, storage capacity can be increased but cannot be decreased.
  • Small capacity without enabling automatic storage increase can result in instance loosing its SLA.


Automatic storage increase

  • If enabled, available storage is checked every 30 seconds and if available storage is below threshold size, additional storage capacity is added.
  • Capacity added till it reaches the maximum of 30 TB.
  • storage size can be increased but cannot be decreased till the life of the instance.
  • If an instance runs out of available space, it can cause the instance to go offline, and is not covered by SLA
  • This setting of a master instance automatically applies to any read replicas of that instance.
  • This settings cannot be independently set for read replicas.



  • It’s size depends on the amount of storage currently provisioned for instance
  • It cannot be larger than 25 GB.
  • 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, to find the threshold the formula is –  5 + (provisioned storage)/25 The result of the division is rounded down to the nearest whole number.
  • Automatic storage increase limit
  • If enabled, it provides a specific limit on how large the storage for instance can automatically grow.
  • Cannot be decreased
  • Setting this limit to zero, the default value, means that there is no limit
  • This setting for a master instance automatically applies to any read replicas of that instance.
  • Auto backups
  • To configure automated backups and binary logging


Other settings –

  • Region (The Google Cloud Platform region where instance is located.)
  • Zone (The GCP zone where instance is located.)
  • Machine Type (or Tier, determines memory, virtual cores, and other resources available to Cloud SQL instance.)
  • Database version
  • Storage type ( Choosing SSD, the default value, for lower latency and higher data throughput else select HDD.)
  • Private IP (Configures instance to use private IP)
  • Public IP (If enabled, instance is allocated a public IPv4 address. When you disable Public IP, that address is released)

Pass the GCP Exam Now!