QuestionQ76

VerifiedDeploy scalable and highly available databases in Google Cloud

You are a DBA at a retail company. The production databases run on Cloud SQL for MySQL Enterprise Plus edition, version 8.0.34, in the us-centrall region. You must configure and test disaster recovery (DR) with zero data loss in the us-west1 region. What should you do?

Explanation

Cloud SQL for MySQL Enterprise Plus advanced DR requires a directly connected cross-region read replica designated as the DR replica. The DR replica must use the same database version as the primary, so it must run version 8.0.34. A switchover reverses the primary and designated DR replica roles with zero data loss and is the supported operation for testing DR.

Learn more

Community Discussion

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