I have configured all nodes in my cluster with the following:
wsrep_sst_donor = "node01,"
and restarted mysqld/galera. However, I am unable to verify if this has actually been picked up by the cluster. I've tried the following:
mysql -e "SHOW GLOBAL STATUS LIKE 'wsrep%';"
and
mysql -e "SHOW GLOBAL STATUS LIKE 'wsrep_sst_donor';"
to look for the preferred donor, but there is nothing returned. Does anyone have any suggestions on how to verify whether or not a preferred sst donor has been configured properly?
Thanks in advance.