This page describes how to ensure database availability and avoid instance downtime by increasing the cluster storage quota in AlloyDB, how the cluster storage quota recommender works, and how you can use it.
The AlloyDB cluster storage quota recommender helps you detect productions clusters which are at risk of hitting the storage quota.
The AlloyDB cluster storage quota recommender analyzes certain storage related metrics and computes the latest storage quota utilization by the cluster. If the utilization is over a certain threshold, the cluster receives a recommendation to increase the storage quota. Recommendations are generated daily.
Before you begin
Before you can view recommendations and insights, do the following:
Ensure that you enable the Recommender API.
To get the permissions to view and work with insights and recommendations, ensure that you have the required Identity and Access Management (IAM) roles.
Tasks Roles View recommendations recommender.alloydbViewer
oralloydb.viewer
.Apply recommendations recommender.alloydbAdmin
oralloydb.admin
.See Grant access to other users for more information.
List the recommendations
You can list the cluster storage quota recommendations
using the Google Cloud console, gcloud CLI
, or the Recommender API.
Console
In the Google Cloud console, go to the Clusters page.
For more information, see Exploring recommendations.
In the Availability configuration card, click Nearing storage quota.
A list of clusters to which the Nearing storage quota recommendation applies is displayed.
gcloud CLI
To list the cluster storage quota recommendations using gcloud CLI, run the gcloud recommender recommendations list
command as follows:
gcloud recommender recommendations list \ --project=PROJECT_ID \ --location=LOCATION \ --recommender=google.alloydb.cluster.ReliabilityRecommender \ --filter=recommenderSubtype=INCREASE_CLUSTER_STORAGE_QUOTA
Replace the following:
PROJECT_ID
: Your project ID.LOCATION
: A region where your clustres are located, such asus-central1
.
API
To list cluster storage quota recommendations using the Recommendations API, call the
recommendations.list
method as follows:
GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.alloydb.cluster.ReliabilityRecommender/recommendations?filter=recommenderSubtype=INCREASE_CLUSTER_STORAGE_QUOTA
Replace the following:
PROJECT_ID
: Your project ID.LOCATION
: A region where your clusters are located, such asus-central1
.
View insights and detailed recommendations
You can view insights and detailed recommendations about clusters
that require increasing cluster storage quota using the Google Cloud console,
gcloud CLI
, or the Recommender API.
To view insights and detailed recommendations, follow these steps:
Console
On the Clusters page, click the Nearing storage quota recommendation for an instance in the Issues column. The recommendation panel appears, which contains insights and detailed recommendations.
gcloud CLI
Run the gcloud recommender insights list
command as follows:
gcloud recommender insights list \ --project=PROJECT_ID \ --location=LOCATION \ --insight-type=google.alloydb.cluster.ReliabilityInsight \ --filter=insightSubtype=HIGH_STORAGE_UTILIZATION
Replace the following:
- PROJECT_ID: Your project ID.
- LOCATION : A region where your clusters are located, for example,
us-central1
.
API
Call the insights.list
method as follows:
GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.alloydb.cluster.ReliabilityInsight/insights?filter=insightSubtype=HIGH_STORAGE_UTILIZATION
Replace the following:
- PROJECT_ID: Your project ID.
- LOCATION : A region where your clusters are located, for example,
us-central1
.
Apply the recommendation
Evaluate the recommendation carefully and do the following:
Console
To implement the recommendation, do the following:
- Click Edit Quota for your cluster. This automatically displays the IAM & Admin > Quotas & System Limits window.
- Select the entry for your cluster, and click Edit Quotas.
- In the Edit quota window, input the appropriate quota value as per the recommendation.
- Fill in the required details in the Request description field and click Done.
- Click Submit Request.