It would be great to have this baked in to the mysql replication module
<http://docs.ansible.com/mysql_replication_module.html>
On Sunday, December 21, 2014 4:45:21 PM UTC-8, Evan Tahler wrote:
>
> 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 [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/2364a331-b1e9-401f-937e-a59b1e2c748b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
