主从centos7链接
执行之前配好ssh免密 和关闭防火墙
vim aa.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 $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 aa.sh 主参数IP 从参数IP