Here's how I implemented this using the command line mysql args:
- name: Check if slave is already configured for replication
mysql_replication: mode=getslave
register: slave
ignore_errors: true # on the first run, this will error because not
replicating yet
when: ansible_default_ipv4.address != mysql_master_ip
- name: Get the current master server's replication status
mysql_replication: "mode=getmaster login_user='{{ mysql_replication_user
}}' login_password='{{ mysql_replication_pass }}' login_host='{{
mysql_master_ip }}'"
register: mysql_repl_stat
delegate_to: "{{ mysql_master_name }}"
when: ansible_default_ipv4.address != mysql_master_ip
- name: ensure mysql replication
when: "slave|failed and ansible_default_ipv4.address != mysql_master_ip
command: "
/usr/bin/mysql -u {{ mysql_user }} -p{{ mysql_pass }} -e
\"
STOP SLAVE;
RESET MASTER;
SET GLOBAL gtid_purged='{{ mysql_repl_stat.Executed_Gtid_Set }}';
CHANGE MASTER TO MASTER_HOST='{{ mysql_master_ip }}', MASTER_USER='{{
mysql_replication_user }}', MASTER_PASSWORD='{{ mysql_replication_pass }}',
MASTER_AUTO_POSITION=1;
START SLAVE;
\"
"
On Monday, December 15, 2014 10:07:23 PM UTC-8, Evan Tahler wrote:
>
> Hi!
>
> Is there any (planned) support for GTID-based replication
> <http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-howto.html> in
> the mysql-replication package
> <https://github.com/ansible/ansible-modules-extras/blob/devel/database/mysql/mysql_replication.py>
> ?
>
> It looks like someone started this here
> <http://ops.kinja.com/mysql_replciation-ansible-module-update-1525041688>,
> but didn't get it back into master.
>
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to ansible-project+unsubscr...@googlegroups.com.
To post to this group, send email to ansible-project@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/25400a9c-673e-4c44-a13c-6a2e0b710c4e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
