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

Script to monitor and bootstrap a cluster

edwhedwh ContributorCurrent User Role Novice
At the moment when I need to bootstrap a cluster, what I need to do is:
  • Make sure everything is down (including my monit)
  • Check the grastrate.dat to find which one has the maximum sequence number
  • Set the safe_to_bootstrap flag
  • /etc/init.d/mysql bootstrap-pxc
  • Wait for that to come up.
  • If it was successful, start the other nodes one at a time, waiting for the SST to complete on each
Has anyone done any automation of this kind of thing?
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.