ALTER CLUSTER SOFTFAIL

Overview

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.

See also: SQL Statements in Xpand 6 and in 5.3

DETAILS

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.

Note

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".

CHANGE HISTORY

Release Series

History

6

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

EXTERNAL REFERENCES