07saltstack生产实例mysql主从

2.服务部署抽象&＃xff1a;功能模块redis 安装、配置、启动mysql 安装、配置&＃xff08;my.cnf可以统一 目录默认配置可以统一&＃xff09;master: server_id 1111slave: server_id 22221.redis 主从 (已经实现)2.mysql 主从 2.1 mysql-install.sls 安装 配置 初始化 2.2 my.cnf配置不同-server id2.3 创建主从同步用户2.4 master上获取binlog 和 pos值2.5 slave上&＃xff0c;change master && start slave2.6 检查主从状态GRANT replication slave on 3.apache&＃43;php4.haproxy&＃43;keepalived

[root&＃64;# localhost /srv/salt/prod/modules/mysql]# cat install.sls
mysql-install:pkg.installed:- pkgs:- mariadb- mariadb-servermysql-config:file.managed:- name: /etc/my.cnf- source: salt://modules/mysql/files/my.cnf- user: root- group: root- mode: 644

[root&＃64;# localhost /srv/salt/prod/modules/mysql]# cat master.sls
include:- modules.mysql.installmaster-config:file.managed:- name: /etc/my.cnf.d/mariadb-server.cnf- source: salt://modules/mysql/files/mariadb-server-master.cnf- user: root- group: root- mode: 644master-service:service.running:- name: mariadb- enable: True

[root&＃64;# localhost /srv/salt/prod/modules/mysql]# cat slave.sls
include:- modules.mysql.installslave-config:file.managed:- name: /etc/my.cnf.d/mariadb-slave.cnf- source: salt://modules/mysql/files/mariadb-server-slave.cnf- user: root- group: root- mode: 644slave-service:service.running:- name: mariadb- enable: True

[root&＃64;# localhost /srv/salt/prod/modules/mysql]# cp /etc/my.cnf.d/server.cnf files/mariadb-server-master.cnf
[root&＃64;# localhost /srv/salt/prod/modules/mysql]# cp /etc/my.cnf.d/server.cnf files/mariadb-server-slave.cnf

[root&＃64;# localhost /srv/salt/prod/modules/mysql/files]# vim mariadb-server-master.cnf
[root&＃64;# localhost /srv/salt/prod/modules/mysql/files]# vim mariadb-server-slave.cn

[root&＃64;# localhost ~]# salt &＃39;linux-node1*&＃39; state.sls modules.mysql.master saltenv&＃61;prod
[root&＃64;# localhost ~]# salt &＃39;linux-node2*&＃39; state.sls modules.mysql.slave saltenv&＃61;prod

[root&＃64;# localhost /srv/salt/prod/modules/mysql]# cat master.sls
include:- modules.mysql.installmaster-config:file.managed:- name: /etc/my.cnf.d/mariadb-server.cnf- source: salt://modules/mysql/files/mariadb-server-master.cnf- user: root- group: root- mode: 644master-service:service.running:- name: mariadb- enable: Truerepl-user: ## 创建用户mysql_user.present:- name: repl_user- host: 192.168.194.0/255.255.255.0- password: repl_usergrant-user: ##授权mysql_grants.present:- grant: replication slave- database: &＃39;*.*&＃39;- user: repl_user- host: 192.168.194.0/255.255.255.0

[root&＃64;# localhost /srv/salt/prod/modules/mysql]# cat slave.sls
include:- modules.mysql.installslave-config:file.managed:- name: /etc/my.cnf.d/mariadb-slave.cnf- source: salt://modules/mysql/files/mariadb-server-slave.cnf- user: root- group: root- mode: 644slave-service:service.running:- name: mariadb- enable: True
[root&＃64;# localhost /srv/salt/prod/modules/mysql]#

[root&＃64;# localhost /srv/salt/prod/modules/mysql]# cat master.sls
include:- modules.mysql.installmaster-config:file.managed:- name: /etc/my.cnf.d/mariadb-server.cnf- source: salt://modules/mysql/files/mariadb-server-master.cnf- user: root- group: root- mode: 644master-service:service.running:- name: mariadb- enable: Truemaster-grant:cmd.run:- name: mysql -e "GRANT replication slave,super on *.* to &＃39;repl_user&＃39;&＃64;&＃39;192.168.194.0/255.255.255.0&＃39; identified by &＃39;repl_user&＃64;pass&＃39;"- unless: mysql -h 192.168.194.131 -u repl_user -prepl_user&＃64;pass -e "exit"

[root&＃64;# localhost /srv/salt/prod/modules/mysql]# cat master.sls
include:- modules.mysql.installmaster-config:file.managed:- name: /etc/my.cnf.d/mariadb-server.cnf- source: salt://modules/mysql/files/mariadb-server-master.cnf- user: root- group: root- mode: 644master-service:service.running:- name: mariadb- enable: True[root&＃64;# localhost /srv/salt/prod/modules/mysql]# cat slave.sls
include:- modules.mysql.installslave-config:file.managed:- name: /etc/my.cnf.d/mariadb-slave.cnf- source: salt://modules/mysql/files/mariadb-server-slave.cnf- user: root- group: root- mode: 644slave-service:service.running:- name: mariadb- enable: True

[root&＃64;# localhost /srv/salt/prod/shop-user/files]# cat start_slave.sh
#!/bin/bash
for i in &＃96;seq 1 10&＃96;;domysql -h 192.168.194.131 -u repl_user -prepl_user&＃64;pass -e "exit"if [ $? -eq 0 ];thenPOS&＃61;$(mysql -h 192.168.194.131 -u repl_user -prepl_user&＃64;pass -e "show master status" | awk -F &＃39;|&＃39; &＃39;NR&＃61;&＃61;2 {print $1}&＃39; | awk &＃39;{print $2}&＃39;)mysql -e "change master to master_host&＃61;&＃39;192.168.194.131&＃39;, master_user&＃61;&＃39;repl_user&＃39;, master_password&＃61;&＃39;repl_user&＃64;pass&＃39;, master_log_file&＃61;&＃39;mysqlbin.000001&＃39;
, master_log_pos&＃61;$POS; start slave;"
touch /etc/my.cnf.d/slave.lockexit;elsesleep 60;fi
done

[root&＃64;# localhost /srv/salt/prod/shop-user]# cat mysql-master.sls
include:- modules.mysql.mastermaster-grant:cmd.run:- name: mysql -e "GRANT replication slave,super on *.* to &＃39;repl_user&＃39;&＃64;&＃39;118.190.201.0/255.255.255.0&＃39; identified by &＃39;repl_user&＃64;pass&＃39;"- unless: mysql -h 192.168.194.131 -ur repl_user -prepl_user&＃64;pass -e "exit"

[root&＃64;# localhost /srv/salt/prod/shop-user]# cat mysql-slave.sls
include:- modules.mysql.slaveslave-grant:file.managed:- name: /tmp/start_slave.sh- source: salt://shop-user/files/start_slave.sh- user: root- group: root- mode: 755cmd.run:- name: /bin/bash /tmp/start_slave.sh- unless: test -f /etc/my.cnf.d/slave.lock

[root&＃64;# localhost /srv/salt/base]#
[root&＃64;# localhost /srv/salt/base]# cat top.sls
base:&＃39;*&＃39;:- init.init-allprod:&＃39;linux-node1.example.com&＃39;:- shop-user.mysql-master&＃39;linux-node2.example.com&＃39;:- shop-user.mysql-slave

[root&＃64;# localhost ~]# cd /var/lib/mysql/
[root&＃64;# localhost /var/lib/mysql]# rm -rf *
[root&＃64;# localhost /var/lib/mysql]# yum remove mariadb-server

[root&＃64;# localhost ~]# salt &＃39;*&＃39; state.sls modules.mysql.master saltenv&＃61;prod

[root&＃64;# localhost ~]# salt &＃39;*&＃39; state.highstatelinux-node2.example.com:
----------
.......省略部分.......
Summary
------------
Succeeded: 6 (changed&＃61;1)
Failed: 0
------------
Total states run: 6
linux-node1.example.com:
----------
.......省略部分.......
Summary
------------
Succeeded: 6 (changed&＃61;1)
Failed: 0
------------
Total states run: 6