July 2018
Intermediate to advanced
506 pages
16h 2m
English
Content preview from Google Cloud Platform for Developers
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Cloud SQL locations
When creating a Cloud SQL instance, developers specify the region in which the instance should be created. At the time of writing, both MySQL and PostgreSQL instances are available in all GCP regions, with the exception of asia-southeast1. Additionally, the instance's zone can be specified. If no zone is specified, Google Cloud will choose the zone for you. Once created, an instance's region cannot be changed. Its zone can be changed at any time to another zone within the region. This can be done via the following command:
gcloud sql instances patch <INSTANCE> --gce-zone <ZONE>
Cloud SQL data is stored within the same region that the instance is hosted in. To ensure data availability, backups are stored in two separate ...