Updating a MySQL® cluster
Can I manage a cluster using SQL commands?
There are some restrictions for cluster management using SQL commands. For more information, see SQL command limits.
How do I reduce the size of a disk?
It is not possible to reduce cluster storage size.
You can create a new cluster with less storage and migrate the data to it.
How do I increase the size of a disk?
Storage size cannot be increased for non-replicated SSD storage: follow the instructions at Updating clusters.
To increase the size of non-replicated SSD storage, restore the cluster from a backup and set the required size.
You can check the disk type in the management console. To do this, find the Storage parameter under Resources on the cluster page.
How do I change the disk type?
To change the disk type, restore your cluster from a backup.
Why cannot I add or delete a host?
The number of hosts in a cluster is limited by quotas. Before adding a host, check the resources currently in use: open the Quotas page and find the Managed Databases section.
You can delete a host as long as it is not the only one in a cluster. To replace the only host, first create a new host and then delete the old one.
Clusters with local disks have a fault-tolerant 3-host configuration. Fewer hosts are not permitted.
How do I perform a manual failover?
In a failover cluster with multiple hosts, you can switch the master role from the current master host to the replica host. After this operation, the current master host becomes the replica host of the new master.
- Go to the cluster page and click the Hosts tab.
- Click Switch master.
If you do not have the Yandex Cloud (CLI) command line interface yet, install and initialize it.
The folder specified when creating the CLI profile is used by default. To change the default folder, use the yc config set folder-id <folder_ID> command. You can specify a different folder using the --folder-name or --folder-id parameter.
To switch the master:
-
View a description of the CLI switch master command:
yc managed-mysql cluster start-failover --help -
Run the
yc managed-mysql cluster start-failovercommand.
How do I restart a host?
You cannot restart a separate cluster host. To restart hosts, stop and restart the cluster.