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) HDD
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) Off
Automatic storage increase limit	Y	In GiBs. 0 (the default) means there is no limit.
Auto backups	Y	On (default value) Off
Maintenance window	Y	Day of the week, and hour.
Maintenance timing	Y	Any (default value) Later Earlier
Activation policy	Y	ALWAYS NEVER
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.

Threshold

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

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)