wsrep_local_state

DETAILS

Cluster Nodes record the current operations they undertake as their local states. Such operations can indicate when the node is initialized, joining the cluster, waiting a State Snapshot Transfer (SST), or providing an SST to another node.

This status variable provides the numeric representation of the node's current local state. To retrieve the logical representation of the local state, see the wsrep_local_state_comment status variable.

EXAMPLES

Use the SHOW STATUS statement to retrieve the current local state.

SHOW STATUS LIKE "wsrep_local_state";

+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| wsrep_local_state | 4     |
+-------------------+-------+

CHANGE HISTORY

EXTERNAL REFERENCES

• Additional information on this topic may be found in the MariaDB Public Knowledge Base.