MySql

Start a Percona 5.7 cluster after a controlled shutdown

In each node check the content of /var/lib/mysql/grastate.dat

version: 2.1
uuid: 9a50c4ec-4332-11e8-8b88-77564bb9f22a
seqno: 45
safe_to_bootstrap: 0

select the node with the highest value in seqno and edit the value of safe_to_bootstrap to 1

should be like these

version: 2.1
uuid: 9a50c4ec-4332-11e8-8b88-77564bb9f22a
seqno: 45
safe_to_bootstrap: 1

in these node run

systemctl start mysql@bootstrap.service

in the other nodes run

systemctl start mysqld

and finally in the bootstraped node run

systemctl stop mysql@bootstrap.service

systemctl start mysqld

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.