ALTER CLUSTER SET MAX_FAILURES

Overview

Modifies an Xpand cluster, configures the Rebalancer to sets the number of replicas and acceptors to maintain, specifying the maximum number of Xpand nodes that can fail simultaneously without data loss.

USAGE

DETAILS

ALTER CLUSTER SET MAX_FAILURES num

The max_failures system variable determines the number of failures that can occur simultaneously while ensuring that no data is lost. By default, this is the number of node failures that can be tolerated. If zones are in use, this is the number of node or zone failures tolerated. For example, if MAX_FAILURES = 1 (default), the cluster can lose one node or one zone, regardless of the number of nodes in that zone. The value of max_failures is also used to determine the number of replicas created by default for a table or index. If MAX_FAILURES = 1, new database entities are created with REPLICAS = 2.

For additional information, see "MAX_FAILURES for MariaDB Xpand".

max_failures is a read-only global system variable that can only be set using ALTER CLUSTER. For additional information, see "Configure MAX_FAILURES for MariaDB Xpand".

Name

Description

Default Value

MAX_FAILURES

Number of simultaneous failures that the cluster can withstand while maintaining transaction resolution and without suffering data loss.

1

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