QuestionQ44

VerifiedEnsuring solution and operations excellence

During a high-traffic period of the day, one of your relational databases crashes, but its replica is never promoted to primary. You want to prevent this from happening again.

What should you do?

Explanation

Regularly scheduled failovers test whether the standby can be promoted and whether clients reconnect correctly during a failure. Cloud SQL recommends testing failover to observe an application’s response to automatic failover; backups and larger instances do not validate the promotion path.

Learn more

Community Discussion

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