Question: You plan to deploy Cloud SQL using MySQL. You need to ensure high availability in the event of a zone failure. What should you do?

You plan to deploy Cloud SQL using MySQL. You need to ensure high availability in the event of a zone failure. What should you do?

A Create a Cloud SQL instance in one zone, and create a failover replica in another zone within the same region.

B Create a Cloud SQL instance in one zone, and create a read replica in another zone within the same region.

C Create a Cloud SQL instance in one zone, and configure an external read replica in a zone in a different region.

D Create a Cloud SQL instance in a region, and configure automatic backup to a Cloud Storage bucket in the same region.

EVERY WHERE I AM GEETING ANSWER C BUT I AM CONFUSED ALL THE GOOGLE BLOG IS SHWOING A AND THE JUSTTIFIACTION IS Multiple zones (Highly available) Automatic failover to another zone within your selected region. Recommended for production instances. Increases cost."

hence please help to guide only the correct answer will be appreciated else i will directly give you negative rating

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!