ALTER CLUSTER for MariaDB Xpand
This page is part of MariaDB's Documentation.
The parent of this page is: Node Maintenance
Topics on this page:
Overview
The ALTER CLUSTER statement contains several sub-statements that can be used to alter an Xpand cluster:
ALTER CLUSTER ADD: Add node(s) to increase cluster size
ALTER CLUSTER DROP: Forcibly remove node(s) from your cluster.
ALTER CLUSTER RELOAD RSA: Re-load the keypair for
sha256_passwordauthenticationALTER CLUSTER RELOAD SSL: Re-load TLS/SSL keys and certificates
ALTER CLUSTER RESIZE DEVICES: Increase the size of the file allocated for permanent database storage.
ALTER CLUSTER SET MAX_
FAILURES : Specify the number of simultaneous failures that can be safely tolerated.ALTER CLUSTER SOFTFAIL: Remove node(s) from your cluster.
ALTER CLUSTER ZONE: Assign nodes to a zone.
One change may be made at a time.
Privileges
The privileges required for ALTER CLUSTER depend on the version of MariaDB Xpand:
In Xpand 6.1, the statements require the
CLUSTER ADMINprivilegeIn Xpand 6.0 and before, the statements require the
SUPERprivilege
Example Syntax
ALTER CLUSTER ADD 'ip' [, 'ip'] ...
ALTER CLUSTER SOFTFAIL nodeid [, nodeid] ...
ALTER CLUSTER UNSOFTFAIL nodeid [, nodeid] ...
ALTER CLUSTER REFORM
ALTER CLUSTER DROP nodeid
ALTER CLUSTER RESIZE DEVICES size
ALTER CLUSTER nodeid [, nodeid] ... ZONE zone
ALTER CLUSTER SET MAX_FAILURES = number of simultaneous failures
ALTER CLUSTER RELOAD SSL