Updating a MySQL® cluster

• Can I manage a cluster using SQL commands?

• How do I reduce the size of a disk?

• How do I increase the size of a disk?

• How do I change the disk type?

• Why cannot I add or delete a host?

• How do I perform a manual failover?

• How do I restart a host?

Can I manage a cluster using SQL commands?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?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?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?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?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?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.

How do I restart a host?How do I restart a host?

You cannot restart a separate cluster host. To restart hosts, stop and restart the cluster.