OVERVIEW

Whenever an entire Galera cluster is not working then you should never stop or restart the entire cluster. You can refer to the below steps for it.                                                     

STEPS –

1 – Take ssh of MySQL/MariaDB node

Take the ssh/web ssh of anyone MySQL/MariaDB node in that cluster.

Go to /var/lib/MySQL

open file grastate.dat

last line is safe_to_bootstrap: 0

change it to

safe_to_bootstrap: 1

Note: Bootstrap is the first node in a cluster. so we are saying it is safe for this node to be the first node in the galera cluster.

2 – Start MySQL

Service MySQL start

Once started, go to the other 2 nodes and start Mysql/MariaDB one by one.

Note: Don’t change grastate on the other 2 nodes.