You are deploying MySQL on Cloud SQL to support many geographically distributed readers, require high availability and low RTO/RPO across regional outages, and want minimal reader interruption during failover. What architecture should you use?
Choose an answer
Tap an option to check your answer.
Correct answer: Create a highly available Cloud SQL instance in region A. Create a highly available read replica in region B. Scale up read workloads by creating cascading read replicas in multiple regions. Promote the read replica in region B when region A is down..
Why this is the answer
The correct architecture uses a highly available Cloud SQL instance in Region A for the primary, and a highly available read replica in Region B. This provides cross-region disaster recovery with low RTO/RPO. Cascading read replicas from the Region B replica distribute read workloads globally and ensure minimal interruption if Region A fails, as they can be reconfigured to point to the promoted Region B instance. Promoting the highly available read replica in Region B ensures a quick and robust failover. Option 1 is incorrect because restoring from a backup is a slow process, leading to high RTO/RPO. Option 2 is incorrect because promoting a standard read replica doesn't guarantee high availability for the new primary. Option 4 is incorrect because read replicas in the same region don't provide protection against regional outages, and failing over to a standby only protects within the same region.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed