Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- - name: generate server-id
- shell: hostname -I | sed -e 's/ \+\([a-z0-9]\+\:\)\+[a-z0-9]\+//' | sed -e 's/ /\n/' | grep -v '^$' | tail -1 | awk -F. '{print $3 * 256 + $4}'
- register: mysql_server_id
- - name: check replication slave status
- mysql_replication: mode=getslave
- ignore_errors: true
- register: slave
- - name: get master replication status
- mysql_replication: mode=getmaster login_user={{ mysql_users.phoenixcorp.user }} login_password={{ mysql_users.phoenixcorp.password }}
- delegate_to: "{{ groups['mysql-master'][0] }}"
- register: replication
- when: slave|failed
- - name: define master in slave
- mysql_replication: mode=changemaster master_host={{ groups['mysql-master'][0] }} master_log_file={{ replication.File }} master_log_pos={{ replication.Position }} master_user={{ mysql_users.slave.user }} master_password={{ mysql_users.slave.password }}
- when: slave|failed
- - name: start slave
- mysql_replication: mode=startslave
- - name: mysql backup script symlink
- cron: name="database backup" hour={{ item.0 }} minute={{ item.0 }} user="root" job="/home/live/scripts/cron/backup_db.sh >> /var/log/backup.log" cron_file=backup_database
- when: "'{{ item.1 }}' == '{{ inventory_hostname }}'"
- with_indexed_items: groups['mysql-slave']
Add Comment
Please, Sign In to add comment