Deleting MySQL clusters
Before deleting a cluster
-
Disable deletion protection for the cluster if it is enabled.
-
The cluster ID is required to restore a deleted cluster from a backup.
After you delete a database cluster, its backups are kept for 7 days for recovery purposes.
Deleting a cluster
- Open the folder page
in the management console. - Select Managed Service for MySQL.
- Click the
If you do not have the Yandex Cloud command line interface yet, install and initialize it.
The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name
or --folder-id
parameter.
To delete a cluster, run the command:
yc managed-mysql cluster delete <cluster_name_or_ID>
You can request the cluster ID and name with a list of clusters in the folder.
Terraform
For more information about the provider resources, see the documentation on the Terraform
If you change the configuration files, Terraform automatically detects which part of your configuration is already deployed, and what should be added or removed.
If you don't have Terraform, install it and configure the Yandex Cloud provider.
To delete a cluster created using Terraform:
-
In the command line, go to the folder that houses the current Terraform configuration file with an infrastructure plan.
-
Delete the resources using this command:
terraform destroy
Alert
Terraform will delete all the resources you created using it, such as clusters, networks, subnets, and VMs.
-
Type
yes
and press Enter.
Time limits
A Terraform provider sets the timeout for Managed Service for MySQL cluster operations:
- Creating a cluster, including by restoring one from a backup: 15 minutes.
- Editing a cluster, including the MySQL version update: 60 minutes.
- Deleting a cluster: 15 minutes.
Operations exceeding the set timeout are interrupted.
Add the timeouts
block to the cluster description, for example:
resource "yandex_mdb_mysql_cluster" "<cluster_name>" {
...
timeouts {
create = "1h30m" # 1 hour 30 minutes
update = "2h" # 2 hours
delete = "30m" # 30 minutes
}
}
To delete a cluster, use the delete REST API method for the Cluster resource or the ClusterService/Delete gRPC API call and provide the cluster ID in the clusterId
request parameter.
You can fetch the cluster ID with a list of clusters in the folder.