有局限性,主要问题是这个只能用一次,因为这个file、pos、无法实施更新
第一台:主
#!/bin/bash
yum -y install mysql mysql-server
service mysqld start
sed -i '/user=mysql/a log-bin=mysql-bin' /etc/my.cnf
sed -i '/user=mysql/a server_id=1 ' /etc/my.cnf
service mysqld restart
mysql -e "grant all on *.*to 'nihao'@'%' identified by 'nihao';"
mysql -e "show master status;"
第二台 : 从
#!/bin/bash
File=mysql-bin.000002
Pos=233
yum -y install mysql mysql-server
service mysqld start
sed -i '/user=mysql/a relay-log=relay-logs' /etc/my.cnf
sed -i '/user=mysql/a server_id=2' /etc/my.cnf
service mysqld restart
mysql -e "change master to master_host=’192.168.92.128’,master_user=’nihao’,master_password=’nihao’,master_log_file=’$file’,master_log_pos=$pos"
mysql -e "start slave;"
mysql -e “show slave status \G;”