Scale MySQL semi-sync cluster
Scale MySQL semi-sync cluster
A MySQL semi-sync cloud database cluster can be scaled — for example, increase vCPU and RAM to improve cluster performance.
You can change a fixed node configuration to an arbitrary configuration or an arbitrary configuration to a fixed configuration, but only with more disk space. You can reduce or increase the number of vCPUs and RAM. Look at the list of MySQL semi-sync node configurations.
The process of changing the configuration depends on the availability of replicas:
- if there are no replicas in the cluster — the master node will be stopped while the changes are applied, the cluster will be temporarily unavailable for reading and writing;
- if there are replicas in the cluster — the cluster will be read and write accessible while the changes are applied. The replicas will be stopped one by one, and the configuration of each replica will be changed. The master note will then switch to one of the replicas, and the configuration of the past master note will change.
The configuration change time depends on the amount of data in the cluster.
For your information
If you have previously changed DBMS settings, they may reset after scaling. Learn more about MySQL semi-sync settings.
- In Control Panel, go to Cloud Platform → Databases.
- Open the cluster page → Settings tab.
- Click Scale Cluster.
- Select a different fixed or arbitrary configuration. You can only select a configuration with more disk space. The amount of vCPU and RAM can be decreased or increased.
- Optional: increase the number of replicas in the cluster.
- Click Save.