This role aims to rollout mysql clusters consisting of one master and mutliple slaves, as shown on the below diagram:
+---------------+
|node-1 (master)|
+---------------+
/ \
+--------------+ +--------------+
|node-2 (slave)| |node-3 (slave)|
+--------------+ +--------------+
The role is also capable of switching masters as described in https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-switch.html, provided that no new requests are coming to mysql master during ansible-playbook runs.
vagrant up
ansible -i .vagrant/provisioners/ansible/inventory/vagrant_ansible_inventory -m ping all
vagrant provision
ansible-playbook -i .vagrant/provisioners/ansible/inventory/vagrant_ansible_inventory provisioning/main.yml
cluster_size = 3 # number of nodes, first node will become replication master, 2..N will become replication slaves
master_node_id = 2 # changing this shoud result in moving master seamlessly