QuestionQ119

VerifiedMaintaining and automating data workloads

You have a Cloud SQL for PostgreSQL instance in Region’ with one read replica in Region2 and another read replica in Region3. An unexpected event in Region’ requires you to perform disaster recovery by promoting the read replica in Region2. You need to ensure that your application has the same database capacity available before you switch over the connections. What should you do?

Explanation

After a read replica is promoted, it becomes a standalone writable primary. Other replicas of the former primary must be recreated from the newly promoted primary. Creating two new replicas from the new primary restores the original capacity of one primary and two read replicas before application connections are redirected.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!