Ansible自动化部署MySQL主从

1、添加hosts文件

# vim /etc/ansible/hosts 
[mysql_slave]
1.1.1.2 ansible_ssh_user=root ansible_ssh_pass=Root
[mysql_master]
1.1.1.1 ansible_ssh_user=root ansible_ssh_pass=Root

2.创建mysql角色文件，用于调用mysql_repl

  1 - hosts: mysql_master
  2   remote_user: root
  3   gather_facts: False
  4   roles:
  5     - {role: mysql_repl,mysql_repl_role: master}
  6 
  7 - hosts: mysql_slave
  8   remote_user: root
  9   gather_facts: False
 10   roles:
 11     - {role: mysql_repl,mysql_repl_role: slave,mysql_repl_master: 1.1.1.1,my    sql_repl_user: [{name: repl,passwd: repl}]}

3.创建变量文件

  1 ---
  2 source_dir: /home/db/mysql/src/
  3 mysql_root_pwd: redhat123
  4 mysql_port: 13306
  5 socket: /tmp/mysql.sock
  6 
  7 mysql_db:
  8 - name: test1
  9   replicate: yes
 10 - name: test2
 11   replicate: no
 12 - name: test3
 13   replicate: no
 14 
 15 mysql_remote_user:
 16 - name: remote
 17   passwd