cluster

Percona

Fix: safe_to_bootstrap: 1

# search for node with "safe_to_bootstrap: 1"
cat /var/lib/mysql/grastate.dat
 
killall mysqld
service mysql bootstrap-pxc
#/etc/init.d/mysql bootstrap-pxc
service mysql start
killall -9 mysqld
cat /var/lib/mysql/grastate.dat
mysqld_safe --wsrep-recover
service mysql status
 
service mysql start --wsrep-new-cluster
tail -f /var/log/mysqld.log
 
# n-th hosts
service mysql start
 
 
 
sed -i "/safe_to_bootstrap/s/0/1/" /var/lib/mysql/grastate.dat
 
https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/crash-recovery.html
# https://severalnines.com/blog/updated-how-bootstrap-mysql-or-mariadb-galera-cluster
killall -9 mysqld
cat /var/lib/mysql/grastate.dat
mysqld_safe --wsrep-new-cluster
service mysql restart
 
# restart start on remaining nodes
 
cat /var/lib/mysql/gvwstate.dat

Get cluster status