Not the answer you need?
Register and ask your own question!

Commandline check if bootstrapped node is member of cluster

YamakasYYamakasY EntrantCurrent User Role Beginner
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

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    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.
  • YamakasYYamakasY Entrant Current User Role Beginner
    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.
  • przemekprzemek Percona Support Engineer Percona Staff Role
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.