ansible角色部署mysql主从

最新推荐文章于 2023-06-22 05:39:35 发布

山客泛舟游Y

最新推荐文章于 2023-06-22 05:39:35 发布

阅读量475

点赞数

文章标签： mysql ansible 数据库

本文链接：https://blog.csdn.net/weixin_72898853/article/details/127789781

版权

本文介绍了如何在Linux环境中利用Ansible进行MySQL主从部署。首先，重新定义了主机清单，然后详细阐述了配置MySQLzc角色的过程，包括编写配置文件模板、创建并执行MySQLzc剧本的步骤。最后，检查了MySQL主从复制的状态，确保部署成功。

摘要由CSDN通过智能技术生成

linux ansible角色部署mysql主从

ansible主机创建角色重新定义主机清单

[root@ansible ~]# cd /etc/ansible/
[root@ansible ansible]# ls
ansible.cfg  apache.yml  haproxy.yml  hosts  httpd.yml  mysql.yml  php.yml  roles
[root@ansible ansible]# vim hosts 
[webservers]
node1
node2

[haproxy]
node3

[mysql]
node4
node5

[mysql_master]
node4

[mysql_slave]
node5
[root@ansible roles]# ansible-galaxy init mysqlzc
- Role mysqlzc was created successfully
[root@ansible roles]# ls
apache  haproxy  httpd  mysql  mysqlzc  php
[root@ansible roles]# cd mysqlzc/
[root@ansible mysqlzc]# ls
defaults  files  handlers  meta  README.md  tasks  templates  tests  vars

ansible主机配置mysqlzc角色

[root@ansible ansible]# cd roles/mysqlzc/
[root@ansible mysqlzc]# ls
defaults  files  handlers  meta  README.md  tasks  templates  tests  vars
[root@ansible mysqlzc]# vim tasks/main.yml 
---
# tasks file for mysqlzc
- name: stop firewalld
  service: 
    name: firewalld
    state: stopped
    enabled: no
 
- name: stop selinux
  lineinfile: 
    path: /etc/selinux/config
    regexp: '^SELINUX='
    line: SELINUX=disabled

- name: stop selinux1
  shell: 
    cmd: setenforce 0

- name: install mariadb
  yum: 
    name: 
      - mariadb-server
      - mariadb
    state: present

- name: cp config
  template: 
    src: mastermy.cnf.j2
    dest: /etc/my.cnf
  when: inventory_hostname in {
  { gro