wsrep_local_state_comment

Overview

Logical representation of the node's current local state.

See also: Status Variables for MariaDB Enterprise Server 11.4, in 10.6 ES, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS

USAGE

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 logical representation of the node's current local state. To retrieve the numeric representation of the local state, see the wsrep_local_state status variable.

Logical State

Description

Initialized

The node successfully started, but has not yet established network connectivity with the Primary Component.

Synced

The node has established a connection with the cluster and synchronized its local databases with those of the cluster.

Joining

The node is attempting to join the cluster.

Joined

The node has successfully joined the cluster.

Waiting

The node is waiting on a State Snapshot Transfer (SST) to bring its local databases up to date with the cluster.

Donor

The node has blocked itself while it sends a State Snapshot Transfer (SST) to bring a new node up to date with the cluster.

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

11.4 Enterprise

  • Not present.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

EXTERNAL REFERENCES