In our cluster, a node will experience an issue from time to time. When this happens, nodes 2 and 3 will crash resulting in a
ERROR! MySQL (Percona XtraDB Cluster) is not running, but PID file exists
If I restart mysql on the failed nodes, our Node 1 will no longer service mysql requests. Node 1 will show
| wsrep_local_state_comment | Donor/Desynced
until Node 2 and Node 3 receive updates. After this, MySQL is OK.
This is an issue because I must wait until late at night to restart nodes 2 and 3 to allow our website to function.