个人在部署PXC(Percona-Xtradb-Cluster) 集群遇到的问题及解决方案的补充如下:
1、故障:对第一节点设置的同步账户授权不够,导致另外两个节点无法加入集群
解决:GRANT ALL ON *.* TO 'sstuser'@' localhost’ identified by ‘password’;
2、故障: 重启集群报错It may not be safe to bootstrap the cluster from this node. It was not the last one to leave the cluster and may not contain all the
updates.
解决:查看修改grastate.dat文件将safe_to_bootstrap的值置为1。或从已为1的节点启动集群