Other Articles

Cloud SQL – Enable High Availability

Secure Configuration Checks > GCP

This check ensures that Cloud SQL instances are regional, which makes them highly available. A standby instance in a second zone takes over if the main zone fails. Read replicas are not checked.

Check Details

  • Resource: Cloud SQL Instance
  • Check: Enable Cloud SQL high availability
  • Risk: If the zone of a single-zone instance fails, the database goes offline. Applications that depend on it have an outage until the zone recovers.

Remediation via Google Cloud Console

  1. Log in to the Google Cloud Console and navigate to Cloud SQL. Cloud Sql Instance
  2. Click on the affected Cloud SQL instance.
  3. Click Edit to modify the instance configuration. Cloud Sql Instance Edit
  4. Expand Customize your instance and scroll to the Availability section.
  5. Select Multiple zones (Highly available). Cloud SQL High Availability
  6. Click Save to apply the changes.

Remediation via Google Cloud CLI

  1. Open the Google Cloud Console and launch Cloud Shell. GCP Cloud Shell
  2. List the single-zone instances. Read replicas are left out:

    gcloud sql instances list \
    --filter="settings.availabilityType=ZONAL AND instanceType=CLOUD_SQL_INSTANCE" \
    --format="table(name,region,settings.availabilityType)"
    
  3. Update the Cloud SQL instance to be highly available:

    gcloud sql instances patch <INSTANCE_NAME> --availability-type=REGIONAL
    

    Replace <INSTANCE_NAME> with your Cloud SQL instance name. Automated backups must be turned on first. Point-in-time recovery, or binary logging for MySQL, must also be on. The change can cause a short interruption, so apply it in a maintenance window.

  4. Verify the availability type:

    gcloud sql instances describe <INSTANCE_NAME> \
    --format="value(settings.availabilityType)"
    

    The output must be REGIONAL.

Default Value

Unless you choose high availability when you create the instance, it runs in a single zone. High availability costs more, because a standby instance runs in a second zone.

Updated on 09 November, 2026