Shell脚本在Centos系统编写MySQL主从

执行之前配好ssh免密
和关闭防火墙
注意改成自己的IP

Centos6

vim mysql-MS.sh

#!/bin/bash
yum -y install mysql mysql-server #主安装mysql
sed -i '/0/a\server-id=1' /etc/my.cnf   #sed修改主配置
sed -i '/1/a\log-bin=mysql-bin' /etc/my.cnf
service mysqld start       #启动mysql
mysql -e "grant all on *.* to he@'%' identified by '123';" #shell mysql授权
mysql -e "flush privileges;"
file=`mysql -e "show master status"|awk '/mysql/{print $1}'` #shell查看mysql二进日志
rz=`mysql -e "show master status"|awk '/mysql/{print $2}'`
yum -y install expect   #安装免交互
#以下属于expect免交互
/usr/bin/expect<<EOF
spawn ssh root@$2      
set timeout 1000
expect "~" {send "yum -y install mysql mysql-server\n"}  
expect "~" {send "sed -i '/0/aserver-id=2' /etc/my.cnf\n"}
expect "~" {send "sed -i '/2/arelay-log=mysql-relay' /etc/my.cnf\n"}
expect "~" {send "service mysqld start\n"} 
expect "~" {send "mysql -e \"change master to master_host='$1',master_user='he',master_password='123',master_log_file='$file',master_log_pos=$rz;\"\n"}
expect "~" {send "mysql -e 'start slave'\n"}
expect "~" {send "exit\n"}
expect eof
EOF

sh mysql-MS.sh 主参数IP 从参数IP

Centos7

修改为阿里源

wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo

vim mysql-MS.sh

#!/bin/bash
yum -y install mariadb mariadb-server #主安装mysql
sed -i '/0/a\server-id=1' /etc/my.cnf   #sed修改主配置
sed -i '/1/a\log-bin=mysql-bin' /etc/my.cnf
systemctl restart mariadb       #启动mysql
mysql -e "grant all on *.* to he@'%' identified by '123';" #shell mysql授权
mysql -e "flush privileges;"
file=`mysql -e "show master status"|awk '/mysql/{print $1}'` #shell查看mysql二进日志
rz=`mysql -e "show master status"|awk '/mysql/{print $2}'`
yum -y install expect   #安装免交互
#以下属于expect免交互
/usr/bin/expect<<EOF
spawn ssh root@$2     
set timeout 1000
expect "~" {send "yum -y install mariadb mariadb-server\n"}  
expect "~" {send "sed -i '/0/aserver-id=2' /etc/my.cnf\n"}
expect "~" {send "sed -i '/2/arelay-log=mysql-relay' /etc/my.cnf\n"}
expect "~" {send "systemctl restart mariadb\n"} 
expect "~" {send "mysql -e \"change master to master_host='$1',master_user='he',master_password='123',master_log_file='$file',master_log_pos=$rz;\"\n"}
expect "~" {send "mysql -e 'start slave'\n"}
expect "~" {send "exit\n"}
expect eof
EOF

sh mysql-MS.sh 主参数IP 从参数IP