ansible-playbook一键部署mysql双主集群

怼烎@ 2021-11-17 11:38 951阅读 0赞

前面的博客中，介绍过mysql的双主集群的搭建，那么ansible就是将之前的手动的操作过程转换成剧本的方式，然后执行剧本，就完成了mysql的双主集群的搭建，具体的搭建过程可看之前的mysql的博客模块，下面是ansible部署mysql双主的文件结构

  1. [root@wyl01 mysql]# tree 
  2. .
  3. ├── group_vars
  4. │   └── mysql.yml    # 存放的是所用到的参数
  5. ├── hosts            # 主机清单
  6. ├── README.txt
  7. ├── roles
  8. │   └── mysql
  9. │       ├── files
  10. │       │   └── mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz   # 安装的版本
  11. │       ├── tasks     #目录下面是具体的每一项任务
  12. │       │   ├── add_user.yml                    
  13. │       │   ├── change_slave_to_master.yml
  14. │       │   ├── install_mysql.yml
  15. │       │   ├── main.yml
  16. │       │   └── pre_install.yml
  17. │       └── templates     # 模板文件
  18. │           ├── my.cnf.j2
  19. │           └── mysql.service.j2
  20. └── site.yml   # 执行的入口文件

  1. 查看主机清单和所用到的变量

    [root@wyl01 mysql]# cat hosts #主机清单
    [mysql]
    wyl02 ansible_ssh_host=192.168.52.129 ansible_ssh_pass=123456 master=true
    wyl03 ansible_ssh_host=192.168.52.130 ansible_ssh_pass=123456 slave=true

  1. [root@wyl01 mysql]# cat group_vars/mysql.yml    # 变量，下面有的参数使用是为了多实例部署，是剧本具有高效性
  2. ---
  3. mysql_version: mysql-5.7.20-linux-glibc2.12-x86_64
  4. mysql_install_path: /usr/local
  5. mysql_link: mysql
  6. mysql_sock: /tmp/mysql.sock
  7. mysql_port: 3306
  8. mysql_root_passwd: "123456"
  9. master_ip: 192.168.52.129
  10. slave_ip: 192.168.52.130
  11. repl_user: repl
  12. repl_passwd: "123456"

2 剧本的入口文件

  1. [root@wyl01 mysql]# cat site.yml 
  2. ---
  3. - hosts: all
  4.   gather_facts: yes
  5.   roles:
  6.     - mysql

3 剧本执行的每一项任务

20190730194840849.png

  1. [root@wyl01 tasks]# cat pre_install.yml    # 安装前的准备工作
  2. - name: install_MySQL-python
  3.   yum:
  4.     name: MySQL-python
  5.     state: latest
  6.   tags:
  7.     - install_MySQL-python
  9. [root@wyl01 tasks]# cat add_user.yml    # mysql的用户
  10. ---
  11. - name: add_mysql_user
  12.   user:
  13.     name: mysql
  14.     create_home: no
  15.     shell: /sbin/nologin
  16.   tags:
  17.     - add_mysql_user
  21. [root@wyl01 tasks]# cat install_mysql.yml    # 解压，授权，启动，修改初始化密码等操作
  22. ---
  23. - name:  unarchive_mysql_tar
  24.   unarchive:
  25.     src:  "{
  26.    { mysql_version }}.tar.gz"
  27.     dest: "{
  28.    { mysql_install_path }}"
  29.     owner: mysql
  30.     group: mysql
  31.   tags:
  32.     - unarchive_mysql_tar
  35. - name: chown_mysql
  36.   file: 
  37.     dest: "{
  38.    { mysql_install_path }}/{
  39.    {mysql_version}}"
  40.     owner: mysql
  41.     group: mysql
  42.     recurse: yes
  43.   tags:
  44.     - chown_mysql
  47. - name: link_mysql
  48.   file:
  49.     src: "{
  50.    { mysql_install_path }}/{
  51.    {mysql_version}}"
  52.     dest: "{
  53.    { mysql_install_path }}/{
  54.    { mysql_link }}"
  55.     owner: mysql
  56.     group: mysql
  57.     state: link
  58.   tags:
  59.     - link_mysql
  63. - name: mkdir_log
  64.   file:
  65.     path: "{
  66.    { mysql_install_path }}/{
  67.    { mysql_link }}/log"
  68.     owner: mysql
  69.     group: mysql
  70.     state: directory
  71.   tags:
  72.     - mkdir_log
  76. - name: touch_mysql.log
  77.   file:
  78.     path: "{
  79.    { mysql_install_path }}/{
  80.    { mysql_link }}/log/mysqld.log"
  81.     owner: mysql
  82.     group: mysql
  83.     state: touch
  84.   tags:
  85.     - touch_mysql.log
  88. - name: copy_my.cnf
  89.   template:
  90.     src: my.cnf.j2
  91.     dest: /etc/my.cnf
  92.   tags:
  93.     - copy_my.cnf
  97. - name: init_mysql
  98.   shell: ./bin/mysqld --initialize  --user=mysql
  99.   args:
  100.     chdir: "{
  101.    { mysql_install_path }}/{
  102.    { mysql_link }}"
  103.   tags: 
  104.     - init_mysql
  107. - name: get_mysql_passwd
  108.   shell: cat log/mysqld.log |grep localhost|awk -F ':' '{print $4}'|cut -c  2-
  109.   register: mysql_init_passwd
  110.   args:  
  111.     chdir: "{
  112.    { mysql_install_path }}/{
  113.    { mysql_link }}"
  114.   tags: 
  115.     - get_mysql_passwd
  119. - name: dispaly_passwd
  120.   debug: 
  121.     msg: "{
  122.    { mysql_init_passwd.stdout }}"
  123.   tags:
  124.     - dispaly_passwd
  128. - name: copy_mysql.server
  129.   copy:
  130.     src: "{
  131.    { mysql_install_path }}/{
  132.    { mysql_link }}/support-files/mysql.server"
  133.     dest: /etc/init.d/mysql-{
  134.    { mysql_port }}.server
  135.     mode: 0755
  136.   tags:
  137.      - copy_mysql.server
  141. - name: add_mysql_systemd
  142.   template:
  143.     src: mysql.service.j2
  144.     dest: /etc/systemd/system/mysql-{
  145.    { mysql_port }}.service
  146.   tags:
  147.     - add_mysql_systemd
  151. - name: start_mysql_service
  152.   systemd:
  153.     name: mysql-{
  154.    { mysql_port }}
  155.     daemon_reload: yes
  156.     enabled: yes
  157.     state: restarted
  158.   tags:
  159.     - start_mysql_service
  163. - name: alter_passwd
  164.   shell: ./bin/mysqladmin -u root -p'{
  165.    {mysql_init_passwd.stdout}}' password '{
  166.    { mysql_root_passwd }}'
  167.   args:
  168.     chdir: "{
  169.    { mysql_install_path }}/{
  170.    { mysql_link }}"
  171.   tags:
  172.     - alter_passwd
  174. [root@wyl01 mysql]# cat roles/mysql/tasks/change_slave_to_master.yml     #change master操作 
  175. ---
  176. - name: create_user
  177.   mysql_user: 
  178.     login_host: 127.0.0.1
  179.     login_port: "{
  180.    { mysql_port }}"
  181.     login_user: root 
  182.     login_password: "{
  183.    { mysql_root_passwd }}"
  184.     name: "{
  185.    { repl_user }}"
  186.     password: "{
  187.    { repl_passwd }}"
  188.     priv: "*.*:ALL"
  189.     state: present 
  190.     host: "%"
  191.   when: master is defined
  192.   tags:
  193.     - create_user
  197. - name: change_slave_to_master1
  198.   mysql_replication:
  199.     login_unix_socket: "{
  200.    { mysql_sock }}"
  201.     login_host: 127.0.0.1
  202.     login_port: "{
  203.    { mysql_port }}"
  204.     login_user: root     
  205.     login_password: "{
  206.    { mysql_root_passwd }}"
  207.     master_host: "{
  208.    { master_ip }} " 
  209.     master_user: "{
  210.    { repl_user }}" 
  211.     master_password: "{
  212.    { repl_passwd }}"
  213.     master_port: "{
  214.    { mysql_port }}"
  215.     master_auto_position: "1"
  216.     mode: changemaster
  217.   when: slave is defined
  218.   tags:
  219.     - change_slave_to_master1 
  222. - name: start_slave1
  223.   mysql_replication: 
  224.     login_unix_socket: "{
  225.    { mysql_sock }}"
  226.     login_user: root 
  227.     login_host: 127.0.0.1
  228.     login_port: "{
  229.    { mysql_port }}"
  230.     login_password: "{
  231.    { mysql_root_passwd }}"
  232.     mode: startslave
  233.   tags: 
  234.     - start_slave1
  237. - name: change_slave_to_master2
  238.   mysql_replication:
  239.     login_unix_socket: "{
  240.    { mysql_sock }}"
  241.     login_host: 127.0.0.1
  242.     login_port: "{
  243.    { mysql_port }}"
  244.     login_user: root
  245.     login_password: "{
  246.    { mysql_root_passwd }}"
  247.     master_host: "{
  248.    { slave_ip }} "
  249.     master_user: "{
  250.    { repl_user }}"
  251.     master_password: "{
  252.    { repl_passwd }}"
  253.     master_port: "{
  254.    { mysql_port }}"
  255.     master_auto_position: "1"
  256.     mode: changemaster
  257.   when: master is defined
  258.   tags:
  259.     - change_slave_to_master2
  262. - name: start_slave2
  263.   mysql_replication:
  264.     login_unix_socket: "{
  265.    { mysql_sock }}"
  266.     login_user: root
  267.     login_host: 127.0.0.1
  268.     login_port: "{
  269.    { mysql_port }}"
  270.     login_password: "{
  271.    { mysql_root_passwd }}"
  272.     mode: startslave
  273.   tags:
  274.     - start_slave2
  276. - name: get_slave_info
  277.   mysql_replication:
  278.     login_host: 127.0.0.1
  279.     login_user: root
  280.     login_port: 3306
  281.     login_password: "123456"
  282.     mode: getslave
  283.   register: info
  284.   tags:
  285.     - get_slave_info
  288. - name: dispaly_slave
  289.   debug:
  290.     msg: "Slave_SQL_Running={
  291.    { info.Slave_IO_Running }}       Slave_SQL_Running={
  292.    { info.Slave_SQL_Running }}"
  293.   tags:
  294.     - dispaly_slave

执行结果如下：

  1. [root@wyl01 mysql]# ansible-playbook  -i hosts  site.yml 
  3. PLAY [all] **********************************************************************************************************************************************************************************
  5. TASK [Gathering Facts] **********************************************************************************************************************************************************************
  6. ok: [wyl03]
  7. ok: [wyl02]
  9. TASK [mysql : install_MySQL-python] *********************************************************************************************************************************************************
  10. ok: [wyl02]
  11. ok: [wyl03]
  13. TASK [mysql : add_mysql_user] ***************************************************************************************************************************************************************
  14. ok: [wyl03]
  15. ok: [wyl02]
  17. TASK [mysql : unarchive_mysql_tar] **********************************************************************************************************************************************************
  18. changed: [wyl03]
  19. changed: [wyl02]
  21. TASK [mysql : chown_mysql] ******************************************************************************************************************************************************************
  22. changed: [wyl03]
  23. changed: [wyl02]
  25. TASK [mysql : link_mysql] *******************************************************************************************************************************************************************
  26. changed: [wyl02]
  27. changed: [wyl03]
  29. TASK [mysql : mkdir_log] ********************************************************************************************************************************************************************
  30. changed: [wyl02]
  31. changed: [wyl03]
  33. TASK [mysql : touch_mysql.log] **************************************************************************************************************************************************************
  34. changed: [wyl02]
  35. changed: [wyl03]
  37. TASK [mysql : copy_my.cnf] ******************************************************************************************************************************************************************
  38. ok: [wyl03]
  39. ok: [wyl02]
  41. TASK [mysql : init_mysql] *******************************************************************************************************************************************************************
  42. changed: [wyl03]
  43. changed: [wyl02]
  45. TASK [mysql : get_mysql_passwd] *************************************************************************************************************************************************************
  46. changed: [wyl03]
  47. changed: [wyl02]
  49. TASK [mysql : dispaly_passwd] ***************************************************************************************************************************************************************
  50. ok: [wyl02] => {
  51.     "msg": "tosEGBto+3xg"
  52. }
  53. ok: [wyl03] => {
  54.     "msg": "&CUQdQ&Qb7S4"
  55. }
  57. TASK [mysql : copy_mysql.server] ************************************************************************************************************************************************************
  58. ok: [wyl03]
  59. ok: [wyl02]
  61. TASK [mysql : add_mysql_systemd] ************************************************************************************************************************************************************
  62. ok: [wyl03]
  63. ok: [wyl02]
  65. TASK [mysql : start_mysql_service] **********************************************************************************************************************************************************
  66. changed: [wyl03]
  67. changed: [wyl02]
  69. TASK [mysql : alter_passwd] *****************************************************************************************************************************************************************
  70. changed: [wyl03]
  71. changed: [wyl02]
  73. TASK [mysql : create_user] ******************************************************************************************************************************************************************
  74. skipping: [wyl03]
  75. changed: [wyl02]
  77. TASK [mysql : change_slave_to_master1] ******************************************************************************************************************************************************
  78. skipping: [wyl02]
  79. changed: [wyl03]
  81. TASK [mysql : start_slave1] *****************************************************************************************************************************************************************
  82. ok: [wyl02]
  83. changed: [wyl03]
  85. TASK [mysql : change_slave_to_master2] ******************************************************************************************************************************************************
  86. skipping: [wyl03]
  87. changed: [wyl02]
  89. TASK [mysql : start_slave2] *****************************************************************************************************************************************************************
  90. changed: [wyl02]
  91. ok: [wyl03]
  93. PLAY RECAP **********************************************************************************************************************************************************************************
  94. wyl02                      : ok=20   changed=12   unreachable=0    failed=0    skipped=1    rescued=0    ignored=0   
  95. wyl03                      : ok=19   changed=11   unreachable=0    failed=0    skipped=2    rescued=0    ignored=0

最后显示sql和i/o进程yes状态，看到两个yes状态表示安装成功

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d5bDk1Mjc_size_16_color_FFFFFF_t_70

发表评论

表情：
评论列表 （有 1 条评论，951人围观）
蒲公英云0DF06D
蒲公英云0DF06DV铁粉 2022-08-03 03:16
亲爱的博主 main.yml和templates下的文件方便发一下吗

相关阅读