GCP Associate Cloud Engineer Practice Question 13: Cloud SQL High Availability
Google Cloud Associate Cloud Engineer · Test 2 · question 3 of 10
A production Cloud SQL for MySQL instance runs in a single zone. Leadership requires that a zonal outage causes an automatic failover with no manual intervention, and that the application keeps using the same connection endpoint.
What should you do?
Show answer and explanation
Answer:
Enabling high availability makes the instance regional: Cloud SQL keeps a synchronously replicated standby in a different zone of the same region and fails over automatically if the primary zone is unavailable. The instance keeps its name and IP address, so clients reconnect to the same endpoint.
Options B and D rely on read replicas, which use asynchronous replication, do not fail over automatically, and must be promoted by a person, which changes the endpoint. Option C is a recovery method that involves restoring into a new instance and downtime, not automatic failover.