wsrep_cluster_status

DETAILS

When a Cluster Node starts, it attempts to establish network connectivity with the other nodes specified by the wsrep_cluster_address system variable. As nodes connect, they form components. Once they establish connectivity with the Primary Component and synchronize databases, they become operational.

This status variable indicates the component to which the node currently belongs.

Cluster Nodes that belong to non-primary components are non-operational and raise a ER_UNKNOWN_COM_ERROR to SQL queries.

EXAMPLES

Use the SHOW STATUS statement to view the current status:

SHOW STATUS LIKE "wsrep_cluster_status";

+----------------------+---------+
| Variable_name        | Value   |
+----------------------+---------+
| wsrep_cluster_status | Primary |
+----------------------+---------+

DIAGNOSIS

WSREP has not yet prepared node for application use

SHOW STATUS LIKE 'wsrep_cluster_status';

+----------------------+-------------+
| Variable_name        | Value       |
+----------------------+-------------+
| wsrep_cluster_status | Non-Primary |
+----------------------+-------------+

SELECT * FROM test.t1;

ERROR 1047 (08S01): WSREP has not yet prepared node for application use

CHANGE HISTORY

EXTERNAL REFERENCES

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

• Information specific to MariaDB SkySQL can be found on the wsrep_cluster_status page in the SkySQL Documentation.