- Hello Vadimtk,
Thank you for reaching my post and replied this.
However, I found the resolution to rebuild and repair cluster already by:
Searching for the highest SQNO on all the nodes.
- Power-off all nodes except the highest SQNO one.
- Execute command: systemctl mysql@bootstrap.service on the said highest SQNO node.
- Wait...and cross your fingers, until the MySQL service on the bootstrap node is up.
- Power-on the rest nodes "one at a time" and keep eyes on the cluster sync status. By execute command: clustercheck and cat /var/lib/mysql/grastate.dat to check the GALERA saved state information, etc.
*** My steps above may wrong or not practical same as when the Linux experts investigate the same issue, but this is what I found and it works for my case. ***
Thank you
Teerayuth