This PoC helps you to simply use a quorum consensus approach with wsrep (GALERA) and keepalived.
SST is a very important component of GALERA and you should keep it in mind when deploying a new cluster. There are different types of SST (logical and physical), but the most important thing is which one blocks the Donor. wsrep helps you with the option wsrep_sst_donor_rejects_queries but this is not enough, you must select the right backend.
With keepalived 2.0.0+ you can use the track_file function instead of track_script which allows a more faster convergence; in that case, keepalived will automatically detect the machine state of wsrep by reading such file content; for mor informations see this example or keepalived's documentation.
Starting with commit 6f9ace3c, keepalived introduced microsecond timers in track_script; this adjustment allows a fine-grained configuration with VRRRP instances.
- [codership/galera] - state-transfers
- [codership/galera] - state-snapshot-transfer
- [codership/galera] - logical-state-snapshot
- [codership/galera] - physical-state-snapshot
- [codership/galera] - sst-physical-xtrabackup
- [codership/galera] - node-states
- [codership/galera] - notification-cmd/node-status
- [keepalived/manual] - keepalived.conf