Details
Description
select * from mysql.wsrep_cluster;
|
ERROR 1047 (08S01): WSREP has not yet prepared node for application use
|
|
select * from mysql.wsrep_cluster_members;
|
ERROR 1047 (08S01): WSREP has not yet prepared node for application use
|
|
select * from mysql.wsrep_streaming_log;
|
Empty set (0.001 sec)
|
For some reason, wsrep_streaming_log works (but is empty), but wsrep_cluster and wsrep_cluster_members both fail.
For sysadmin purposes, it would be nice to have this information available
Just an FYI, the primary reason I need this.
With Galera 4, wsrep_incoming_addresses shows "AUTO" now, and the only way to see (that I'm aware of) which nodes are connected is via these tables. When a network split occurs, I use the information about which nodes can still communicate with which other nodes to determiner course of action. It two nodes are broken off from the main cluster at the same time, I use the information of if they can still communicate with one-another while non-primary to determine which route should be taken to resolve the issue.