ansible部署MySQL主从

最新推荐文章于 2024-08-22 14:29:10 发布

" vivian

最新推荐文章于 2024-08-22 14:29:10 发布

阅读量854

点赞数

文章标签： mysql ansible 数据库

本文链接：https://blog.csdn.net/m0_56681539/article/details/127793909

版权

这篇博客详细介绍了如何利用Ansible自动化部署MySQL的主从配置，包括添加主机清单，创建MariaDB角色，定义tasks任务，编写template模板，执行部署脚本以及验证部署效果。

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

添加主机清单

[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] **********************************************************************************************<