ALTER CLUSTER SET MAX_FAILURES
This page is part of MariaDB's Documentation.
The parent of this page is: SQL Statements for MariaDB Xpand
Topics on this page:
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.
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_MAX_FAILURES = 1, new database entities are created with REPLICAS = 2.
For additional information, see "MAX_
max_failures is a read-only global system variable that can only be set using ALTER CLUSTER.
Name | Description | Default Value |
|---|---|---|
| Number of simultaneous failures that the cluster can withstand while maintaining transaction resolution and without suffering data loss. |
|