You plan Cloud SQL (MySQL) and need high availability for a zonal failure. What should you do?

To achieve high availability against a zonal failure for Cloud SQL (MySQL), you need a configuration that can automatically switch to a healthy instance if the primary zone becomes unavailable. Creating a Cloud SQL instance in one zone and a failover replica in another zone within the same region provides this capability. This setup ensures synchronous replication and automatic failover, minimizing downtime during a zonal outage. Creating a read replica in another zone does not provide automatic failover; it's primarily for scaling read operations. An external read replica in a different region is for disaster recovery across regions, not high availability within a region for zonal failures. Enabling automatic backups to Cloud Storage is crucial for data recovery but does not offer immediate high availability or automatic failover in the event of an instance or zonal failure.