Cluster : PXC 8.0.27 3 node cluster .
Hi there
How do i check the local state and group state of a node in percona xtradb cluster 8.0.27…?
1 Like
You can use this:
show status like “wsrep%”;
or
show status like “wsrep_local_state”;
or
show status like “wsrep_cluster_status”;
2 Likes
Hi
Iam able to find the show status like “wsrep_local_state”;
but not able to find → group state
mysql2 > show status like '%wsrep_group_state%';
Empty set (0.00 sec)
2 Likes
wsrep_cluster_status should indicate if the cluster is in PRIMARY state or not. What other group information are you looking for? The number of connected nodes is also found wsrep_cluster_size
1 Like
@matthewb
here is the sample one … mentioned in the second line which iam looking for…
1 Like
What is the exact thing you need know about the cluster? There is no wsrep_group_state. What you are pointing out on line 2 is the cluster UUID and a sequence number.
1 Like
@Wayne_Leutwyler
Thanks …
1 Like