【无标题】

ansible部署MySQL主从

---

添加主机清单

[root@ansible /etc/ansible]#vim hosts
...
[mysql]
node1
node2

[mysql_master]
node1

[mysql_slave]
node2

创建mariadb角色

[root@ansible /etc/ansible]#cd roles/
[root@ansible /etc/ansible/roles]#ansible-galaxy init mariadb
- Role php was created successfully

编写tasks任务

[root@ansible mariadb]# vim tasks/main.yml 

---
# tasks file for mariadb
- name: stop firewalld
  service:
    name: firewalld
    state: stopped
    enabled: no

- name: stop selinux
  lineinfile:
    path: /etc/selinux/config
    regexp: '^SELINUX='
    line: SELINUX=disabled


- name: install mariadb
  yum:
    name: "{{ packages }}"
  vars:
    packages:
    - mariadb-server
    - mariadb

- name: cp config1
  template:
    src: mastermy.cnf.j2
    dest: /etc/my.cnf
  shell:
    cmd: mysql -uroot -e "grant all privileges on *.* to root@'%' identified by '111';"

- name: master
  shell:
    cmd: mysql -uroot -e "grant replication slave on *.* to 'user'@'slave' identified by '111';"
  when: inventory_hostname in {{ groups.mysql_master }}

- name: master
  shell:
    cmd: mysql -uroot -e "change master to master_host='master',master_user='user',master_password='111';"
  when: inventory_hostname in {{ groups.mysql_slave }}

- name: start slave
  shell:
    cmd: mysql -uroot -e "start slave;"
  when: inventory_hostname in {{ groups.mysql_slave }}

编写template文件

[root@ansible /etc/ansible/roles/mariadb]#vim templates/mastermy.cnf.j2
[mysqld]
log_bin=mysql-bin
server_id=10
[root@ansible /etc/ansible/roles/mariadb]#vim templates/slavemy.cnf.j2
[mysqld]
log_bin=mysql-bin
server_id=20

编写执行文件

[root@ansible ansible]# cat m.yml 
---
- name: mariadb
  hosts: mysql
  roles:
    - mariadb

执行

[root@ansible ansible]# ansible-playbook m.yml

PLAY [mariadb] *******************************************************************************************************************************************

TASK [Gathering Facts] ***********************************************************************************************************************************
ok: [node1]
ok: [node2]

TASK [mariadb : stop firewalld] **************************************************************************************************************************
ok: [node1]
ok: [node2]

TASK [mariadb : stop selinux] ****************************************************************************************************************************
ok: [node1]
changed: [node2]

TASK [install mariadb] ***********************************************************************************************************************************
ok: [node1]
changed: [node2]

TASK [mariadb : cp config1] ******************************************************************************************************************************
[WARNING]: conditional statements should not include jinja2 templating delimiters such as {{ }} or {% %}. Found: inventory_hostname in {{
groups.mysql_master }}
[WARNING]: conditional statements should not include jinja2 templating delimiters such as {{ }} or {% %}. Found: inventory_hostname in {{
groups.mysql_master }}
skipping: [node2]
ok: [node1]

TASK [mariadb : cp config2] ******************************************************************************************************************************
[WARNING]: conditional statements should not include jinja2 templating delimiters such as {{ }} or {% %}. Found: inventory_hostname in {{
groups.mysql_slave }}
[WARNING]: conditional statements should not include jinja2 templating delimiters such as {{ }} or {% %}. Found: inventory_hostname in {{
groups.mysql_slave }}
skipping: [node1]
changed: [node2]

TASK [start mariadb] *************************************************************************************************************************************
changed: [node1]
changed: [node2]

TASK [mariadb : grant for root] **************************************************************************************************************************
changed: [node1]
changed: [node2]

TASK [mariadb : master] **********************************************************************************************************************************
[WARNING]: conditional statements should not include jinja2 templating delimiters such as {{ }} or {% %}. Found: inventory_hostname in {{
groups.mysql_master }}
[WARNING]: conditional statements should not include jinja2 templating delimiters such as {{ }} or {% %}. Found: inventory_hostname in {{
groups.mysql_master }}
skipping: [node2]
changed: [node1]

TASK [mariadb : master] **********************************************************************************************************************************
[WARNING]: conditional statements should not include jinja2 templating delimiters such as {{ }} or {% %}. Found: inventory_hostname in {{
groups.mysql_slave }}
[WARNING]: conditional statements should not include jinja2 templating delimiters such as {{ }} or {% %}. Found: inventory_hostname in {{
groups.mysql_slave }}
skipping: [node1]
changed: [node2]

TASK [mariadb : start slave] *****************************************************************************************************************************
[WARNING]: conditional statements should not include jinja2 templating delimiters such as {{ }} or {% %}. Found: inventory_hostname in {{
groups.mysql_slave }}
[WARNING]: conditional statements should not include jinja2 templating delimiters such as {{ }} or {% %}. Found: inventory_hostname in {{
groups.mysql_slave }}
skipping: [node1]
changed: [node2]

PLAY RECAP ***********************************************************************************************************************************************
node1                      : ok=8    changed=3    unreachable=0    failed=0    skipped=3    rescued=0    ignored=0   
node2                      : ok=9    changed=7    unreachable=0    failed=0    skipped=2    rescued=0    ignored=0