1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| COPY_INSTALL(){ master=ip1 slave=ip2 read -p "请输入master的IP地址:" IP1 read -p "请输入slave的IP地址:" IP2
systemctl stop firewalld;setenforce 0
cat >> /etc/hosts << EOF $IP1 master $IP2 slave EOF
ping slave &> /dev/null if [ $? -eq 0 ];then echo "网络正常,可以使用" else echo "sorry 网络不通" fi
cat >> /etc/my.cnf << EOF log-bin=/var/lib/mysql/master server-id=1 gtid_mode=ON enforce_gtid_consistency=1 EOF
grant replication slave,super,reload on *.* to slave@'%' identified by 'Qianfeng123!';
flush privileges;
change master to master_host='slave',master_user='slave',master_password='1',master_auto_position=1;
start slave;
show slave status\G }
|