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下网络 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; # 启动slave服务 start slave; # 查看服务状态,是否有error show slave status\G }
|