This page describes how to delete Cloud SQL instances.
Note the following when you plan to delete an instance:
- You cannot delete an instance that has any replicas. You must delete all replicas first.
- After you delete an instance, it might continue to appear in your project with an "unknown" size but with a "Being deleted" status. This is normal and the instance disappears completely after a brief period of time.
- It can take up to a week for the underlying resources related to an instance to be completely deleted, with the exception of read replicas, which are often deleted within a few minutes.
- The deleted instance name can be reused immediately to create a new instance.
- If deletion protection is enabled on an instance, you must disable it before deleting the instance.
Required permissions
By default, only user or service accounts with the
Cloud SQL Admin
(roles/cloudsql.admin
)
or Owner
(roles/owner
) role have the permission to delete a
Cloud SQL instance (cloudsql.instances.delete
).
You can also define an IAM custom role
for the user or service account that includes the cloudsql.instances.delete
permission. This permission is
supported in
IAM custom roles.
Delete an instance
You can delete a Cloud SQL instance by using gcloud CLI or the API.
Console
-
In the Google Cloud console, go to the Cloud SQL Instances page.
- To open the Overview page of an instance, click the instance name.
- Click Delete.
- In the Delete database instance dialog, click OK.
gcloud
To delete an instance, use the gcloud sql instances delete
command:
gcloud sql instances delete INSTANCE_NAME \ --project=PROJECT_ID
Make the following replacements:
- INSTANCE_NAME: the name of the instance
- PROJECT_ID: the ID or project number of the Google Cloud project that contains the instance that you want to delete
REST v1
Before using any of the request data, make the following replacements:
- PROJECT_ID: the ID or project number of the Google Cloud project that contains the instance that you want to delete
- INSTANCE_NAME: the name of the instance
HTTP method and URL:
DELETE https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/INSTANCE_NAME
To send your request, expand one of these options:
You should receive a JSON response similar to the following:
{ "kind": "sql#operation", "targetLink": "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/INSTANCE_NAME", "status": "PENDING", "user": "user@example.com", "insertTime": "2020-01-15T00:10:22.078Z", "operationType": "DELETE", "name": "OPERATION_ID", "targetId": "INSTANCE_NAME", "selfLink": "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/operations/OPERATION_ID", "targetProject": "PROJECT_ID" }
REST v1beta4
Before using any of the request data, make the following replacements:
- PROJECT_ID: the ID or project number of the Google Cloud project that contains the instance that you want to delete
- INSTANCE_NAME: the name of the instance
HTTP method and URL:
DELETE https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID/instances/INSTANCE_NAME
To send your request, expand one of these options:
You should receive a JSON response similar to the following:
{ "kind": "sql#operation", "targetLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID/instances/INSTANCE_NAME", "status": "PENDING", "user": "user@example.com", "insertTime": "2020-01-15T00:10:22.078Z", "operationType": "DELETE", "name": "OPERATION_ID", "targetId": "INSTANCE_NAME", "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID/operations/OPERATION_ID", "targetProject": "PROJECT_ID" }