- Selecting the right node: Look at the grastate.dat file on each server to see which machine has the most current data. The node with the biggest seqno is the node with the current data
/var/lib/mysql/grastate.dat
- In the same server execute the following command to bootstrap
mysqld –wsrep-new-cluster
- Next login to node 2 and start MySQL
- Once its success, start MySQL on node 3
- Once the cluster is stable, stop the bootstrap process in node1 and start it using systemctl.