You are tasked with deploying a Cloud SQL instance using MySQL for your organization. Ensuring the high availability of this database is critical for your operations, especially in the event of a zone failure within Google's Cloud infrastructure. What steps should you take to ensure high availability for your Cloud SQL deployment?

Exam-Like

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

52.2%

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

30.4%

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

8.7%

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

8.7%

Google Professional Data Engineer