mysql主从脚本_脚本——mysql主从

主的虚拟机

#!/bin/bash

service iptables stop

setenforce 0

yum -y install mysql mysql-server

sed -i '/log-bin=mysql-bin/d' /etc/my.cnf

sed -i '/server-id=1/d' /etc/my.cnf

sed -i '/symbolic-links=0/a log-bin=mysql-bin \nserver-id=1' /etc/my.cnf

service mysqld restart

mysql -e "grant all on *.* to 'aa'@'%' identified by '123';"

mysql -e "show master status;"

从的虚拟机

#!/bin/bash

file=mysql-bin.000005

pos=304

service iptables stop

setenforce 0

yum -y install mysql mysql-server

sed -i '/server-id=2/d' /etc/my.cnf

sed -i '/relay-log=relay-log/d' /etc/my.cnf

sed -i '/symbolic-links=0/a relay-log=relay-log\nserver-id=2' /etc/my.cnf

service mysqld restart

mysql -e "change master to master_host='192.168.42.129',master_user='aa',master_password='123',master_log_file='$file',master_log_pos=$pos;"

mysql -e "stop slave;"

mysql -e "start slave;"

mysql -e "show slave status \G;"