First its important to ensure that all nodes of galera cluster are in sync. To verify that run the below mysql command on all the galera nodes. The Value must say sync.
MariaDB [(none)]> SHOW STATUS LIKE 'wsrep_local_state_comment'; +---------------------------+--------+ | Variable_name | Value | +---------------------------+--------+ | wsrep_local_state_comment | Synced | +---------------------------+--------+ 1 row in set (0.012 sec)
# cat /var/lib/mysql/grastate.dat # GALERA saved state version: 2.1 uuid: 00000000-0000-0000-0000-000000000000 seqno: -1 safe_to_bootstrap: 0
sudo cat /var/lib/mysql/grastate.dat # GALERA saved state version: 2.1 uuid: f5d6fbc2-31ab-11eb-8a0a-736512fe0cbd seqno: 11067 safe_to_bootstrap: 0
sudo service mysql stop
restarting the cluster
sudo galera_new_cluster
sudo service mysql start
$ sudo mysql -p -e "SHOW STATUS LIKE 'wsrep_cluster_size';" Enter password: +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | wsrep_cluster_size | 3 | +--------------------+-------+