Commandline check if bootstrapped node is member of cluster

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

HI All,

Is it possible to check if a bootstrapped node is member of a cluster and synced with it’s members ?

This to prevent I restart the node using a script as bootstrapped one.

I hope someone can help out.

Cheers,

Matt

2

We call a node “bootstraped” when this is the first one and forming a new cluster. When you join a new node to a cluster, then you should check whether it’s state (wsrep_local_state_comment) changed to “Synced” and wsrep_cluster_size changed reflecting total number of nodes.

3

Yes, but when you bootstrap a that server again instead of staring mysql when it’s in the cluster and have members… the bootstrap started node is starting on it’s own again and will be out of sync… I ask this because of cluster that are provisioned.

4

If you bootstrap a node when it’s cluster is already (or still) up, you will create another cluster. So instead of making this node to join the cluster, this will cause a split brain.