ALTER CLUSTER SOFTFAIL
Modifies the Xpand cluster, configures the Rebalancer to move data off of the specified Xpand nodes so that they can be removed from the cluster.
ALTER CLUSTER SOFTFAIL node-id[, node-id...]
This statement softfails Xpand Nodes. It configures the Rebalancer to begin moving replicas off of the designated nodes. Once the rebalancer process finishes, run the ALTER CLUSTER REFORM statement, which initiates a group change to remove the nodes.
It is recommended that you run this operation on a node other than the one you want to remove.
Before softfailing Xpand Nodes, consider the following:
Xpand requires a minimum of three Xpand Nodes to support production systems.
When using zones, Xpand requires a minimum of three zones.
When using zones, Xpand requires an equal number of nodes per zone.
The target cluster must have sufficient disk space.
For additional information about removing a node with
ALTER CLUSTER SOFTFAIL, see "Scale-In with MariaDB Xpand".
Information specific to MariaDB SkySQL can be found on the ALTER CLUSTER SOFTFAIL page in the SkySQL Documentation.