GCP Associate Cloud Engineer Practice Question 13: Cloud SQL High Availability

Google Cloud Associate Cloud Engineer · Test 2 · question 3 of 10

Cloud SQLmedium

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?

Select one answer
Show answer and explanation

Answer:

  • A. Enable high availability on the instance so that it is configured as regional with a standby in another zone

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.

Reference: About high availability (Cloud SQL for MySQL)

Practice Test 2 ›

Study guides for Google Cloud Associate Cloud Engineer