Playing with GaleraDB

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/

Leave a Reply

Your email address will not be published. Required fields are marked *