ALTER CLUSTER SOFTFAIL
Starts a softfail process for one or more nodes, which configures the Rebalancer to move data off of the nodes so that they can be safely removed from the cluster.
See also: SQL Statements for MariaDB Xpand 6.1
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 the full procedure to remove a node with
ALTER CLUSTER SOFTFAIL, see "Scale-In with MariaDB Xpand".