mysql的shell脚本_mysql主从shell脚本

#!/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<

spawn ssh 192.168.11.132

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='192.168.11.128',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