This page describes the following types of Cloud SQL Enterprise Plus edition recommenders:
- Upgrade to Cloud SQL Enterprise Plus edition for near-zero maintenance downtime
- Upgrade to Cloud SQL Enterprise Plus edition and enable data cache to improve read performance
- Upgrade to Cloud SQL Enterprise Plus edition with enabling data cache
- Enable data cache to improve read performance
The following sections describe how these recommenders work and how to use them.
Pricing
The recommenders described on this page are all in the standard Recommender pricing tier.
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 required roles.
For more information about roles, see understanding roles and granting Identity and Access Management (IAM) permissions.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.
Upgrade to Cloud SQL Enterprise Plus edition for near-zero maintenance downtime
The Cloud SQL Enterprise Plus edition for near-zero maintenance downtime recommender helps you detect instances that are either critical and take a long time to stop during maintenance or their maintenance has been deferred. It analyzes instance metadata and data about maintenance.
If your instance is a production instance and takes a long time to stop during maintenance or its maintenance has been deferred, it is recommended to upgrade to Cloud SQL Enterprise Plus edition so that you instances will have near-zero maintenance downtime. Recommendations are generated daily.
List near-zero downtime recommendations
You can list upgrade to Cloud SQL Enterprise Plus edition for near-zero maintenance downtime recommendations
using the Google Cloud console, gcloud CLI, or the Recommender API.
Console
To list upgrade to Cloud SQL Enterprise Plus edition recommendations, follow these steps:
-
Go to the Cloud SQL Instances page.
On the Improve instance health by investigating issues and acting on recommendations banner, click Expand Details.
Alternatively, follow these steps:
-
Go to the Recommendation Hub. See also Find and apply recommendations with the Recommendations.
For more information, see Getting started with the Recommendation Hub.
In the All recommendations card, click Performance.
gcloud
Run the gcloud recommender insights list command as follows:
gcloud recommender recommendations list \ --project=PROJECT_ID \ --location=LOCATION \ --recommender=google.cloudsql.instance.PerformanceRecommender \ --filter=recommenderSubtype=UPGRADE_TO_ENTERPRISE_PLUS
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region, such asus-central1.
API
Call the insights.list method as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region, such asus-central1.
If the recommender detects instances that can be upgraded to Cloud SQL Enterprise Plus edition, they are listed in a table showing the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.
View insights and detailed recommendations
You can view insights and detailed recommendations about instances that can be upgraded to Cloud SQL Enterprise Plus edition using the Google Cloud console, gcloud CLI, or the Recommender API.
Console
Do one of the following:
On the Performance Recommendations page, click the Performance recommendations card and then click Not optimized with Enterprise Plus. The recommendation panel appears, which contains insights and detailed recommendations for the instance.
On the Instances page, click Not optimized with Enterprise Plus. The list of instances displays only those instances for which the recommendation applies.
gcloud
Run the gcloud recommender insights list command as follows:
gcloud recommender insights list \ --project=PROJECT_ID \ --location=LOCATION \ --insight-type=google.cloudsql.instance.PerformanceInsight --filter=insightSubtype=INSIGHT_SUBTYPE
Replace the following:
PROJECT_ID: your project IDLOCATION: a region, such asus-central1.INSIGHT_SUBTYPE: set this parameter to one of the following:CRASH_RECOVERY_CAUSED_HIGH_MAINTENANCE_DOWNTIME: display insights for the total number of crash recoveries for your instanceMAINTENANCE_DEFERRED_MULTIPLE_TIMES: display insights for the total number of maintenances deferred for your instance
API
Call the insights.list method as follows:
GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region, such asus-central1.
A panel appears showing insights about metrics or information that the Insights highlight.
Apply recommendations
To implement this recommendation, do the following:
- To upgrade to Cloud SQL Enterprise Plus edition, click Not optimized with Cloud SQL Enterprise Plus edition in the Issues column. An Upgrade to Cloud SQL Enterprise Plus edition window displays providing a recommendation. To proceed with an upgrade, click Edit > Upgrade. For more information on upgrading your instance, see Upgrade an instance to Cloud SQL Cloud SQL Enterprise Plus edition by using in-place upgrade. For more information on zero downtime, see data cache.
Upgrade to Cloud SQL Enterprise Plus edition and enable data cache to improve read performance
The upgrade to Cloud SQL Enterprise Plus edition and enable data cache to improve read performance recommender helps you detect instances which are critical and their buffer pool spills pages.
The upgrade to Cloud SQL Enterprise Plus edition and enable data cache to improve read performance recommender analyzes instance metadata and metrics about buffer pool. If the instance is a production instance and its buffer pool spills pages, it is recommended to upgrade to Cloud SQL Enterprise Plus edition and enable the data cache to improve read performance. Recommendations are generated daily.
List instances that can be upgraded to Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommendations
You can list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommendations
using the Google Cloud console, gcloud CLI, or the Recommender API.
Console
To list upgrade to Cloud SQL Enterprise Plus edition recommendations, follow these steps:
-
Go to the Cloud SQL Instances page.
On the Improve instance health by investigating issues and acting on recommendations banner, click Expand Details.
Alternatively, follow these steps:
-
Go to the Recommendation Hub. See also Find and apply recommendations with the Recommendations.
For more information, see Getting started with the Recommendation Hub.
In the All recommendations card, click Performance.
gcloud
To list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommendations, run the
gcloud recommender recommendations list
command as follows:
gcloud recommender recommendations list \ --project=PROJECT_ID \ --location=LOCATION \ --recommender=google.cloudsql.instance.PerformanceRecommender \ --filter=recommenderSubtype=UPGRADE_TO_ENTERPRISE_PLUS_AND_ENABLE_DATA_CACHE
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
API
To list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommendations, call the
recommendations.list
method as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
If the recommender detects instances that can be upgraded to Cloud SQL Enterprise Plus edition, they are listed in a table showing the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.
View insights and detailed recommendations
You can view insights and detailed recommendations about instances that can be upgraded to Cloud SQL Enterprise Plus edition using the Google Cloud console, gcloud CLI, or the Recommender API.
Console
Do one of the following:
On the Performance Recommendations page, click the Performance recommendations card and then click Not optimized with Enterprise Plus. The recommendation panel appears, which contains insights and detailed recommendations for the instance.
On the Instances page, click Not optimized with Enterprise Plus. The list of instances displays only those instances for which the recommendation applies.
gcloud
To view insights and detailed recommendations about an instance that can be upgraded, run the
gcloud recommender insights list
command as follows:
gcloud recommender insights list \ --project=PROJECT_ID \ --location=LOCATION \ --insight-type=google.cloudsql.instance.PerformanceInsight --filter=insightSubtype=READ_HEAVY_WORKLOAD
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
API
Call the insights.list method as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
A panel appears showing insights about metrics or information that the Insights highlight.
Apply recommendations
To implement this recommendation, do the following:
- To upgrade to Cloud SQL Enterprise Plus edition, click Not optimized with Cloud SQL Enterprise Plus edition in the Issues column. An Upgrade to Cloud SQL Enterprise Plus edition window displays providing a recommendation. To proceed with an upgrade, click Edit > Upgrade. For more information on upgrading your instance, see Upgrade an instance to Cloud SQL Cloud SQL Enterprise Plus edition by using in-place upgrade. For more information on zero downtime, see data cache.
Upgrade to Cloud SQL Enterprise Plus edition with enabling data cache
The upgrade to Cloud SQL Enterprise Plus edition with enabling data cache recommender helps you detect instances which are critical and take a long time to stop during maintenance or their maintenance has been deferred and their buffer pool spills pages.
The Cloud SQL Enterprise Plus edition with enabling data cache recommender analyzes instance metadata and metrics.
If your instance is a production instance and takes a long time to stop during maintenance or its maintenance has been deferred and its buffer pool spills pages, it is recommended to upgrade to Cloud SQL Enterprise Plus edition and enable data cache so that your instances have near-zero maintenance downtime and improved read performance. Recommendations are generated daily.
List Cloud SQL instances that can be upgraded to Cloud SQL Enterprise Plus edition with enabling data cache recommendations
You can list upgrades to Cloud SQL Enterprise Plus edition when enabling data cache recommendations
using the Google Cloud console, gcloud CLI, or the Recommender API.
Console
To list upgrade to Cloud SQL Enterprise Plus edition recommendations, follow these steps:
-
Go to the Cloud SQL Instances page.
On the Improve instance health by investigating issues and acting on recommendations banner, click Expand Details.
Alternatively, follow these steps:
-
Go to the Recommendation Hub. See also Find and apply recommendations with the Recommendations.
For more information, see Getting started with the Recommendation Hub.
In the All recommendations card, click Performance.
gcloud
To list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache recommendations, run the
gcloud recommender recommendations list
command as follows:
gcloud recommender recommendations list \ --project=PROJECT_ID \ --location=LOCATION \ --recommender=google.cloudsql.instance.PerformanceRecommender \ --filter=recommenderSubtype=UPGRADE_TO_ENTERPRISE_PLUS_AND_ENABLE_DATA_CACHE
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region, such asus-central1.
API
To list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache recommendations, call the
recommendations.list
method as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
If the recommender detects instances that can be upgraded to Cloud SQL Enterprise Plus edition with enabling data cache, they are listed in a table showing the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.
View insights and detailed recommendations
You can view insights and detailed recommendations about instances that can be upgraded to Cloud SQL Enterprise Plus edition using the Google Cloud console, gcloud CLI, or the Recommender API.
Console
Do one of the following:
On the Performance Recommendations page, click the Performance recommendations card and then click Not optimized with Enterprise Plus. The recommendation panel appears, which contains insights and detailed recommendations for the instance.
On the Instances page, click Not optimized with Enterprise Plus. The list of instances displays only those instances for which the recommendation applies.
gcloud
To view insights and detailed recommendations about an instance that can be upgraded, run the
gcloud recommender insights list
command as follows:
gcloud recommender insights list \ --project=PROJECT_ID \ --location=LOCATION \ --insight-type=google.cloudsql.instance.PerformanceInsight --filter=insightSubtype=INSIGHT_SUBTYPE
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1INSIGHT_SUBTYPE: set this parameter to one of the following:CRASH_RECOVERY_CAUSED_HIGH_MAINTENANCE_DOWNTIME: display insights for the total number of crash recoveries for your instanceMAINTENANCE_DEFERRED_MULTIPLE_TIMES: display insights for the total number of maintenances deferred for your instanceREAD_HEAVY_WORKLOAD: display insights about CPU usage
API
Call the insights.list method as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region, such asus-central1.
A panel appears showing insights about metrics or information that the Insights highlight.
Apply recommendations
To implement this recommendation, do the following:
- To upgrade to Cloud SQL Enterprise Plus edition, click Not optimized with Cloud SQL Enterprise Plus edition in the Issues column. An Upgrade to Cloud SQL Enterprise Plus edition window displays providing a recommendation. To proceed with an upgrade, click Edit > Upgrade. For more information on upgrading your instance, see Upgrade an instance to Cloud SQL Cloud SQL Enterprise Plus edition by using in-place upgrade. For more information on data cache, see data cache. For more information on near-zero downtime, see near-zero downtime.
Enable data cache to improve read performance
The enable data cache to improve read performance recommender helps you detect instances which are critical and their buffer pool spills pages.
The Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommender analyzes instance metadata and metrics about the buffer pool.
If your instance is a production instance and its buffer pool spills pages, it is recommended to enable the data cache to improve read performance. Recommendations are generated daily.
List Cloud SQL instances qualifying for Enable data cache to improve read performance recommendations
You can list enable data cache to improve read performance recommendations by
using the Google Cloud console, gcloud CLI, or the Recommender API.
Console
To list upgrade to Cloud SQL Enterprise Plus edition recommendations, follow these steps:
-
Go to the Cloud SQL Instances page.
On the Improve instance health by investigating issues and acting on recommendations banner, click Expand Details.
Alternatively, follow these steps:
-
Go to the Recommendation Hub. See also Find and apply recommendations with the Recommendations.
For more information, see Getting started with the Recommendation Hub.
In the All recommendations card, click Performance.
gcloud
To list enable data cache to improve read performance recommendations, run the
gcloud recommender recommendations list
command as follows:
gcloud recommender recommendations list \ --project=PROJECT_ID \ --location=LOCATION \ --recommender=google.cloudsql.instance.PerformanceRecommender \ --filter=recommenderSubtype=ENABLE_DATA_CACHE
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
API
To list enable data cache to improve read performance recommendations, call the
recommendations.list
method as follows:
GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
If the recommender detects instances whose data cache can be enabled, they are listed in a table showing the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.
View insights and detailed recommendations
You can view insights and detailed recommendations about instances that can be upgraded to Cloud SQL Enterprise Plus edition
using the Google Cloud console, gcloud CLI, or the Recommender API.
Console
Do one of the following:
On the Performance Recommendations page, click the Performance recommendations card and then click Not optimized with Enterprise Plus. The recommendation panel appears, which contains insights and detailed recommendations for the instance.
On the Instances page, click Not optimized with Enterprise Plus. The list of instances displays only those instances for which the recommendation applies.
gcloud
To view insights and detailed recommendations about an instance that can be upgraded, run the
gcloud recommender insights list
command as follows:
gcloud recommender insights list \ --project=PROJECT_ID \ --location=LOCATION \ --insight-type=google.cloudsql.instance.PerformanceInsight --filter=insightSubtype=READ_HEAVY_WORKLOAD
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
API
Call the insights.list method as follows:
GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region, such asus-central1.
A panel appears showing insights about metrics or information that the Insights highlight.
Apply recommendations
To implement this recommendation, do the following:
- To upgrade to Cloud SQL Enterprise Plus edition, click Not optimized with Cloud SQL Enterprise Plus edition in the Issues column. An Upgrade to Cloud SQL Enterprise Plus edition window displays providing a recommendation. To proceed with an upgrade, click Edit > Upgrade > Customize your instance > Enable data cache. For more information on upgrading your instance, see Upgrade an instance to Cloud SQL Cloud SQL Enterprise Plus edition by using in-place upgrade.