ALTER CLUSTER UNSOFTFAIL
This page is part of MariaDB's Documentation.
The parent of this page is: SQL Statements for MariaDB Xpand
Topics on this page:
Overview
Cancels a softfail process for one or more nodes.
DETAILS
ALTER CLUSTER UNSOFTFAIL node-id[, node-id...]
Softfail operations are begun using an ALTER CLUSTER SOFTFAIL statement. Use this statement to cancel a softfail operation. Once canceled, Xpand restores the node to its prior configuration.
Unsoftfailing Nodes
To unsoftfail nodes:
Connect to an existing Xpand Node with the socket file used by the MariaDB Xpand service:
$ mariadb --socket /data/clustrix/mysql.sockDetermine the node ID for the nodes you want to unsoftfail:
SELECT * FROM system.softfailed_nodes;Use the
ALTER CLUSTER UNSOFTFAILstatement to unsoftfail nodes by their node ID's:ALTER CLUSTER UNSOFTFAIL 4;Confirm that the node is no longer marked for softfail:
SELECT * FROM system.softfailed_nodes;