ALTER CLUSTER UNSOFTFAIL

Overview

Cancels a softfail process for one or more nodes.

USAGE

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:

  1. Connect to an existing Xpand Node with the socket file used by the MariaDB Xpand service:

    $ mariadb --socket /data/clustrix/mysql.sock
    
  2. Determine the node ID for the nodes you want to unsoftfail:

    SELECT * FROM system.softfailed_nodes;
    
  3. Use the ALTER CLUSTER UNSOFTFAIL statement to unsoftfail nodes by their node ID's:

    ALTER CLUSTER UNSOFTFAIL 4;
    
  4. Confirm that the node is no longer marked for softfail:

    SELECT * FROM system.softfailed_nodes;
    

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