Improve instance security by rotating server certificates
This page describes how to view and implement recommendations about rotating servercertificates for instances whose server certificates are about to expire within 30 days.If an instance's server certificate is about to expire within 30 days, then the clientsusing this certificate won't be able securely connect to the instance, making them vulnerable to security breaches. Thisrecommender is calledRotate server certificate.
Every day, this recommenderchecks instances for expiring certificates and provides insights and recommendations to improve your instance security. You can view insights and detailed recommendations about these instances by using the Google Cloud console,gcloud CLI, or theRecommender API.
Before you begin
Ensure that youenable the Recommender API.
Required roles and permissions
To get the permissions to view and work with insights and recommendations, ensure that you have the requiredIdentity and Access Management (IAM) roles.
| Tasks | Roles |
|---|---|
| View recommendations | recommender.cloudsqlViewer orcloudsql.admin. |
| Apply recommendations | cloudsql.editor orcloudsql.admin. |
List the recommendations
To list the recommendations, follow these steps:
Console
To list recommendations about instance security, follow these steps:
Go to theCloud SQL Instances page.
View theIssues column in the instance table.
Alternatively, follow these steps:
Go to theRecommendation Hub.
For more information, seeExploring recommendations.
In theAll recommendations card, clickSecurity.
gcloud
Run thegcloud recommender recommendations list command as follows:
gcloud recommender recommendations list \--project=PROJECT_ID \--location=LOCATION \--recommender=google.cloudsql.instance.SecurityRecommender \--filter=recommenderSubtype=ROTATE_SERVER_CERT
Replace the following:
- PROJECT_ID: Your project ID.
- LOCATION: A region where your instances are located, such as us-central1.
API
Call therecommendations.list method as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.SecurityRecommender/recommendations?filter=recommenderSubtype=ROTATE_SERVER_CERT
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
To view insights and detailed recommendations, follow these steps:
Console
After listing the recommendations, click a recommendation.The recommendation panel appears, which contains insights and detailed recommendations.
gcloud
Run thegcloud recommender insights list command as follows:
gcloud recommender insights list \--project=PROJECT_ID \--location=LOCATION \--insight-type=google.cloudsql.instance.SecurityInsight \--filter=insightSubtype=SERVER_CERT_EXPIRING
Replace the following:
- PROJECT_ID: Your project ID.
- LOCATION : A region where your instances are located, such as
us-central1.
API
Call theinsights.list method as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.SecurityInsight/insights?filter=insightSubtype=SERVER_CERT_EXPIRING
Replace the following:
- PROJECT_ID: Your project ID.
- LOCATION: A region where your instances are located, such as
us-central1.
Apply the recommendation
Console
To implement the recommendation, clickManage server certificates androtate server certificateson your instance.
gcloud
To implement the recommendation,rotate server certificateson your instance.
API
To implement the recommendation,rotate server certificateson your instance.
What's next
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-07-14 UTC.