Answer-first summary for fast verification
Answer: Create a Cloud SQL instance in one zone, and create a failover replica in another zone within the same region.
The recommended approach for ensuring high availability during a zone failure with Cloud SQL (MySQL) involves creating a failover replica in a different zone within the same region. This setup enables automatic failover to the replica instance if the primary zone experiences an outage, thereby reducing downtime and ensuring data remains highly available. It also offers regional redundancy to protect against a complete regional outage.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
To ensure high availability in the event of a zone failure when deploying Cloud SQL using MySQL, which strategy is recommended?
A
Configure an external read replica in a zone in a different region.
B
Create a Cloud SQL instance in one zone, and configure automatic backup to a Cloud Storage bucket in the same region.
C
Create a Cloud SQL instance in one zone, and create a read replica in another zone within the same region.
D
Create a Cloud SQL instance in one zone, and create a failover replica in another zone within the same region.
No comments yet.