Answer-first summary for fast verification
Answer: 1. Provision a Cloud SQL for MySQL instance in us-central1-a. 2. Create a multiple-zone instance in us-central1-b. 3. Create a read replica in us-east1-b.
To ensure the most fault-tolerant and highly available solution for the Cloud SQL for MySQL backend database, the strategy involves setting up a primary instance in the primary region (us-central1) with high availability (multiple-zone instance) and a read replica in the backup region (us-east1). This setup allows the database to survive both zonal and regional failures. Option B correctly implements this strategy by provisioning a Cloud SQL for MySQL instance in us-central1-a (primary zone), creating a multiple-zone instance in us-central1-b (ensuring high availability within the primary region), and setting up a read replica in us-east1-b (backup region). This configuration ensures that if a zonal failure occurs, the multiple-zone instance can take over, and if a regional failure occurs, the read replica in the backup region can be promoted to primary.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you design a highly available and fault-tolerant solution for your organization's critical business app using Cloud SQL for MySQL, ensuring it withstands both zonal and regional failures with us-central1 as the primary region and us-east1 as the backup region?
A
B
C
D
No comments yet.