Improve instance reliability by enabling high availability
Preview
This feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of theService Specific Terms. Pre-GA features are available "as is" and might have limited support. For more information, see thelaunch stage descriptions.
The Cloud SQL enable-high-availabilityrecommenderproactively generates recommendations that help you bring your importantinstances within SLA by providing data redundancy. This mightbe helpful during a zonal outage or when an instance runs out of memory.
This page describes the Cloud SQL enable-high-availability recommender, how thisrecommender works, and how to use it.
How it works
The Cloud SQL enable-high-availability recommender analyzes the instance metadata. If the instanceis configured similar to instances that support important workloads but doesn'thave high availability enabled, then Cloud SQL recommends that you enable highavailability for 99.95% availability SLA, or migrate to Cloud SQL Enterprise Plus edition with highavailability for 99.99% availability SLA.
Note: Recommendations are generated daily.Pricing
The Cloud SQL enable-high-availability recommenderis available free of cost to all Google Cloud customers.For more information, seeRecommender pricing.
Before you begin
Before you can view recommendations and insights, do the following:
- To get the permissions to view and work with insights and recommendations,ensure that you have the requiredIdentity and Access Management (IAM) roles.
For more information about IAM roles, seeIAM basic and predefined roles reference andManage access to projects, folders, and organizations.Tasks Roles View recommendations One of these roles: recommender.cloudsqlViewerorcloudsql.viewer.Apply recommendations One of these roles: recommender.cloudsqlAdmin,cloudsql.editor, orcloudsql.admin. Enable the Recommender API.
Roles required to enable APIs
To enable APIs, you need the Service Usage Admin IAM role (
roles/serviceusage.serviceUsageAdmin), which contains theserviceusage.services.enablepermission.Learn how to grant roles.
List enable-high-availability recommendations
Console
To list enable-high-availability recommendations by using theGoogle Cloud console, follow these steps:
Go to theActive Assist.
For more information, seeGetting started with Recommendation Hub.
In theImprove reliability on Cloud SQL instances card, clickView all.
gcloud
To list enable-high-availability recommendations by using gcloud CLI, run thegcloud recommender recommendations listcommand as follows:
gcloud recommender recommendations list \--project=PROJECT_ID \--location=LOCATION \--recommender=google.cloudsql.instance.ReliabilityRecommender \--filter=recommenderSubtype=ENABLE_HIGH_AVAILABILITY
Replace the following:
PROJECT_ID: Your project ID.LOCATION: Aregion where your instances are located, such asus-central1.
API
To list enable-high-availability recommendations by using theRecommendations API, call therecommendations.listmethod as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.ReliabilityRecommender/recommendations
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region where your instances are located, such asus-central1.
View insights and detailed recommendations
Console
To view insights and detailed recommendations about instances that areconfigured similar to instances that support important workloads butdon't havehigh availability enabled, click the recommendation link in the list ofinstances.
gcloud
To view insights and detailed recommendations about instances that are configured similar to instances that support important workloads but don't havehigh availability enabled, run thegcloud recommender insights listcommand as follows:
gcloud recommender insights list \--project=PROJECT_ID \--location=LOCATION \--insight-type=google.cloudsql.instance.ReliabilityInsight \--filter=insightSubtype=CRITICAL_INSTANCE_HIGH_AVAILABILITY_NOT_ENABLED
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region where your instances are located, such asus-central1.
API
To view insights and detailed recommendations about instances that are configured similar to instances that support important workloads but don't havehigh availability enabled by using theRecommendations API, call theinsights.listmethod as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.ReliabilityInsight/insights
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region where your instances are located, such asus-central1.
The following table lists the insight and recommendation that the Cloud SQLenable-high-availability recommender generates. The subtypesare visible in the gcloud CLI and API results.
| Insight | Recommendation |
|---|---|
| This instance isn't highly available, even though it's configured similarly to instances that support important workloads. Single zone instances are more susceptible to downtime. Subtype: CRITICAL_INSTANCE_HIGH_AVAILABILITY_NOT_ENABLED | Enable high availability for 99.95% availability SLA, or migrate to Cloud SQL Enterprise Plus edition with high availability for even higher 99.99% availability SLA. Enabling high availability will make your instance multi-zonal, which replicates your data within a region to protect against zonal outages, limit downtime and improve recovery time. Subtype: ENABLE_HIGH_AVAILABILITY |
Apply the recommendation
Evaluate the recommendation carefully and do any of the following:
To examine the instance, clickView instance and do any of the following:
Configure highavailability on your instance. For more information, seeEnable and disable high availability.
Caution: Once you start the high availability configuration on an instance, you can'tstop it. This operation restarts the instance and can lead to an increase in cost and abrief downtime.It typically takes only a few minutes for the configuration and the restartoperation tocomplete. However, if the instance has a large disk or load, then it might take up to anhour.Migrate to the Cloud SQL Enterprise Plus edition. For more information, seeIntroduction to Cloud SQL editions.
To dismiss the recommendation, clickDismiss.
To close the panel without applying or dismissing the recommendation, clickCancel.
What's next
- Google Cloud recommenders
- Blog: Maximize your Cloud ROI
- Blog: Do more with less
- View all theGoogle Cloud services available in locations worldwide.
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-12-17 UTC.