Using vagrant and playbook from https://github.com/cocoy/ansible-galera/tests/galera.yml
$ mkdir galera-test $ cd galera-test ; mkdir roles; cd roles $ git checkout https://github.com/cocoy/ansible-galera.git $ cd .. $ cp roles/ansible-galera/tests/* .
Here’s the final galera-test directory contents:
Vagrantfile ansible.cfg galera.yml roles/ - ansible-galera
To run:
$ vagrant up galera1 $ vagrant up galera2 $ vagrant up galera3
References:
https://www.percona.com/blog/2014/11/17/typical-misconceptions-on-galera-for-mysql/
http://www.severalnines.com/blog/9-tips-going-production-galera-cluster-mysql
http://www.severalnines.com/clustercontrol-mysql-galera-tutorial
https://mariadb.com/kb/en/mariadb/about-xtradb/
https://www.percona.com/blog/2013/05/14/is-synchronous-replication-right-for-your-app/
https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-features/
https://www.percona.com/blog/2014/09/01/galera-replication-how-to-recover-a-pxc-cluster/