You have a Cloud SQL primary instance and two read replicas. You want to perform maintenance on the primary without downtime. What is the best strategy?

hard📝 Architecture Q9 of 15

GCP - Cloud SQL and Databases

APromote one read replica to primary, update original primary, then reconfigure replicas

BStop all replicas, update primary, then restart replicas

CUpdate primary directly; replicas will handle failover automatically

DDelete replicas, update primary, then recreate replicas

Step-by-Step Solution

Solution:

Step 1: Understand zero downtime maintenance
Promoting a replica allows switching primary role without downtime.
Step 2: Plan maintenance steps
Promote replica, update old primary, then reconfigure replicas to new primary.
Final Answer:
Promote one read replica to primary, update original primary, then reconfigure replicas -> Option A
Quick Check:
Zero downtime = Promote replica first [OK]

Quick Trick: Promote replica to primary for zero downtime updates [OK]

Common Mistakes:

Stopping replicas causing downtime
Assuming automatic failover without promotion
Deleting replicas unnecessarily

Master "Cloud SQL and Databases" in GCP

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More GCP Quizzes

You have a Cloud SQL primary instance and two read replicas. You want to perform maintenance on the primary without downtime. What is the best strategy?

Step 1: Understand zero downtime maintenance

Step 2: Plan maintenance steps

Final Answer:

Quick Check:

Want More Practice?