You are a DBA at a retail company. The production databases are running in Cloud SQL for MySQL Enterprise Plus edition, version 8.0.34, in the us-centrall region. You need to set up and test…

Question

Options

• AUse advanced DR by setting up a cascading read replica in the region, and designate it
• BCreate a cross-region read replica, version 8.0.37, in the us-west1 region. Designate it as the
• CCreate a cross-region read replica version 8.0.34, in the us-west1 region. Designate it as the
• DCreate a cross-region read replica, version 8.0.34, in the us-west1 region. Test switchover by

• A
  4% (1)
• B
  4% (1)
• C
  85% (23)
• D
  7% (2)

Explanation

You need to use Cloud SQL’s Advanced DR feature (available on Enterprise-Plus) to get true zero-data-loss drills and failovers. That means: 1. Create a direct cross-region read replica in us-west1 using the same MySQL major-&-minor version (8.0.34) as your primary (zero data-loss switchover requires identical versions and Enterprise-Plus) 2. Designate that replica as your DR replica (the “failover DR replica” in the docs). 3. Test DR by running the built-in switchover, e.g.: gcloud sql instances switchover DR_REPLICA_NAME which reverses roles with zero data loss

No community discussion yet for this question.