The Cloud SQL enable-high-availability recommender
proactively generates recommendations that help you bring your important
instances within SLA by providing data redundancy. This might
be helpful during a zonal outage or when an instance runs out of memory.
This page describes the Cloud SQL enable-high-availability recommender, how this
recommender works, and how to use it.
How it works
The Cloud SQL enable-high-availability recommender analyzes the instance metadata. If the instance
is configured similar to instances that support important workloads but doesn't
have high availability enabled, then Cloud SQL recommends that you enable high
availability for 99.95% availability SLA, or migrate to Cloud SQL Enterprise Plus edition with high
availability for 99.99% availability SLA.
Pricing
The Cloud SQL enable-high-availability recommender
is available free of cost to all Google Cloud customers.
For more information, see Recommender pricing.
Before you begin
Before you can view recommendations and insights, do the following:
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 as us-central1.
View insights and detailed recommendations
Console
To view insights and detailed recommendations about instances that are
configured similar to instances that support important workloads but
don't have
high availability enabled, click the recommendation link in the list of
instances.
gcloud
To view insights and detailed recommendations about instances that are configured similar to instances that support important workloads but don't have
high availability enabled, run the
gcloud recommender insights list
command as follows:
LOCATION: A region where your instances are located, such as us-central1.
API
To view insights and detailed recommendations about instances that are configured similar to instances that support important workloads but don't have
high availability enabled by using the
Recommendations API, call the
insights.list
method 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 as us-central1.
The following table lists the insight and recommendation that the Cloud SQL
enable-high-availability recommender generates. The subtypes
are 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, click View instance and do any of the following:
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-28 UTC."],[],[],null,["# Improve instance reliability by enabling high availability\n\n\u003cbr /\u003e\n\n[MySQL](/sql/docs/mysql/recommender-enable-ha \"View this page for the MySQL database engine\") \\| PostgreSQL \\| [SQL Server](/sql/docs/sqlserver/recommender-enable-ha \"View this page for the SQL Server database engine\")\n\n\u003cbr /\u003e\n\n\u003cbr /\u003e\n\n|\n| **Preview**\n|\n|\n| This feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| Pre-GA features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n\nThe Cloud SQL enable-high-availability [recommender](/recommender/docs/overview)\nproactively generates recommendations that help you bring your important\ninstances within SLA by providing data redundancy. This might\nbe helpful during a zonal outage or when an instance runs out of memory.\n\nThis page describes the Cloud SQL enable-high-availability recommender, how this\nrecommender works, and how to use it.\n\nHow it works\n------------\n\nThe Cloud SQL enable-high-availability recommender analyzes the instance metadata. If the instance\nis configured similar to instances that support important workloads but doesn't\nhave high availability enabled, then Cloud SQL recommends that you enable high\navailability for 99.95% availability SLA, or migrate to Cloud SQL Enterprise Plus edition with high\navailability for 99.99% availability SLA.\n| **Note:** Recommendations are generated daily.\n\nPricing\n-------\n\nThe Cloud SQL enable-high-availability recommender\nis available free of cost to all Google Cloud customers.\nFor more information, see [Recommender pricing](/recommender/pricing).\n\nBefore you begin\n----------------\n\nBefore you can view recommendations and insights, do the following:\n\n- To get the permissions to view and work with insights and recommendations, ensure that you have the required [Identity and Access Management (IAM) roles](/sql/docs/postgres/project-access-control#roles).\n\n For more information about IAM roles, see [IAM basic and predefined roles reference](/iam/docs/understanding-roles) and [Manage access to projects, folders, and organizations](/iam/docs/granting-changing-revoking-access).\n-\n\n\n Enable the Recommender API.\n\n\n [Enable the API](https://console.cloud.google.com/flows/enableapi?apiid=recommender.googleapis.com)\n\nList enable-high-availability recommendations\n---------------------------------------------\n\n### Console\n\nTo list enable-high-availability recommendations by using the\nGoogle Cloud console, follow these steps:\n\n1. Go to the **Recommendation Hub**.\n\n [Go to the Recommendation Hub](https://console.cloud.google.com/home/recommendations/)\n\n For more information, see\n [Getting started with Recommendation Hub](/recommender/docs/recommendation-hub/identify-configuration-problems).\n2. In the **Improve reliability on Cloud SQL instances** card, click **View all**.\n\n### gcloud\n\nTo list enable-high-availability recommendations by using gcloud CLI, run the\n[`gcloud recommender recommendations list`](/sdk/gcloud/reference/recommender/recommendations/list)\ncommand as follows: \n\n```\ngcloud recommender recommendations list \\\n--project=PROJECT_ID \\\n--location=LOCATION \\\n--recommender=google.cloudsql.instance.ReliabilityRecommender \\\n--filter=recommenderSubtype=ENABLE_HIGH_AVAILABILITY\n\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A [region](/docs/geography-and-regions) where your instances are located, such as `us-central1`.\n\n### API\n\nTo list enable-high-availability recommendations by using the\n[Recommendations API](/recommender/docs/using-api), call the\n[`recommendations.list`](/recommender/docs/reference/rest/v1beta1/projects.locations.recommenders.recommendations/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.ReliabilityRecommender/recommendations\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region where your instances are located, such as `us-central1`.\n\nView insights and detailed recommendations\n------------------------------------------\n\n### Console\n\nTo view insights and detailed recommendations about instances that are\nconfigured similar to instances that support important workloads but\ndon't have\nhigh availability enabled, click the recommendation link in the list of\ninstances.\n\n### gcloud\n\nTo view insights and detailed recommendations about instances that are configured similar to instances that support important workloads but don't have\nhigh availability enabled, run the\n[`gcloud recommender insights list`](/sdk/gcloud/reference/recommender/insights/list)\ncommand as follows: \n\n```\ngcloud recommender insights list \\\n--project=PROJECT_ID \\\n--location=LOCATION \\\n--insight-type=google.cloudsql.instance.ReliabilityInsight \\\n--filter=insightSubtype=CRITICAL_INSTANCE_HIGH_AVAILABILITY_NOT_ENABLED\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region where your instances are located, such as `us-central1`.\n\n### API\n\nTo view insights and detailed recommendations about instances that are configured similar to instances that support important workloads but don't have\nhigh availability enabled by using the\n[Recommendations API](/recommender/docs/using-api), call the\n[`insights.list`](/recommender/docs/reference/rest/v1beta1/projects.locations.insightTypes.insights/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.ReliabilityInsight/insights\n\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region where your instances are located, such as `us-central1`.\n\nThe following table lists the insight and recommendation that the Cloud SQL\nenable-high-availability recommender generates. The subtypes\nare visible in the gcloud CLI and API results.\n\nApply the recommendation\n------------------------\n\nEvaluate the recommendation carefully and do any of the following:\n\n- To examine the instance, click **View instance** and do any of the following:\n\n - Configure high\n availability on your instance. For more information, see\n [Enable and disable high availability](/sql/docs/postgres/configure-ha#console_1).\n\n | **Caution:** Once you start the high availability configuration on an instance, you can't stop it. This operation restarts the instance and can lead to an increase in cost and a brief downtime. It typically takes only a few minutes for the configuration and the restart operation to complete. However, if the instance has a large disk or load, then it might take up to an hour.\n - Migrate to the Cloud SQL Enterprise Plus edition. For more information, see\n [Introduction to Cloud SQL editions](/sql/docs/editions-intro).\n\n- To dismiss the recommendation, click **Dismiss**.\n\n- To close the panel without applying or dismissing the recommendation, click\n **Cancel**.\n\nWhat's next\n-----------\n\n- [Google Cloud recommenders](/recommender/docs/recommenders)\n- [Blog: Maximize your Cloud ROI](https://cloud.google.com/blog/products/management-tools/active-assist-comes-to-google-cloud)\n- [Blog: Do more with less](https://cloud.google.com/blog/products/databases/reduce-cloud-sql-costs-with-optimizations-by-active-assist)\n- View all the [Google Cloud services available in locations worldwide](/about/locations)."]]
