ALTER CLUSTER SOFTFAIL

Overview

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.

USAGE

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 the full procedure to remove a node with ALTER CLUSTER SOFTFAIL, see "Scale-In with MariaDB Xpand".

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.09

  • Present starting in MariaDB Xpand 23.09.1.

6.1

  • Present starting in MariaDB Xpand 6.1.0.

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.1

  • Present starting in MariaDB Xpand 6.1.0.

EXTERNAL REFERENCES