ZBLOG

1. 准备两台虚拟机(克隆) 2. 打开防火墙: systemctl restart firewalld 2.1 开放防火墙端口 :firewall-cmd --zone=public --add-port=3306/tcp --permanent 2.2 更新设置: firewall-cmd --reload; 2.3 查看防火墙端口开放:firewall-cmd --list-ports systemctl restart firewalld &&

#!/bin/bash

Restart firewall and open port 3306

systemctl restart firewalld firewall-cmd –zone=public –add-port=3306/tcp –permanent firewall-cmd –reload firewall-cmd –list-ports

Configure master server

sed -i ’s/#server-id/server-id=200/g’ /etc/my.cnf echo “log-bin=mysql-bin” >> /etc/my.cnf systemctl restart mysqld

Configure slave server

sed -i ’s/#server-id/server-id=201/g’ /etc/my.cnf systemctl restart mysqld

Set MySQL password and create replication user on master server

mysql -uroot -p1234 -e “SET PASSWORD = ‘Root_12root’;

set global validate_password.policy=0; \
set global validate_password.length=1; \
SET PASSWORD = '1234'; \
CREATE USER 'xiaobai'@'8.134.13.188' IDENTIFIED BY '1234'; \
ALTER USER 'xiaobai'@'8.134.13.188' IDENTIFIED WITH mysql_native_password BY '1234'; \
GRANT REPLICATION SLAVE ON *.* TO 'xiaobai'@'8.134.13.188';"

Get master status and set up slave replication

master_status=\((mysql -uroot -p1234 -e "SHOW MASTER STATUS \G;" | grep File) master_file=\){master_status/File: /} master_position=$(mysql -uroot -p1234 -e “SHOW MASTER STATUS \G;” | grep Position | sed ’s/[^0-9]*//g’) mysql -uroot -p1234 -e “CHANGE MASTER TO MASTER_HOST=‘175.178.93.143’,

MASTER_USER='xiaobai', \
MASTER_PASSWORD='1234', \
MASTER_LOG_FILE='$master_file', \
MASTER_LOG_POS=$master_position; \
START SLAVE;"

Allow remote connections

mysql -uroot -p1234 -e “CREATE USER ‘root’@‘%’ IDENTIFIED BY ‘1234’;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; \
FLUSH PRIVILEGES;"

本站部分文章来源于网络,版权归原作者所有,如有侵权请联系站长删除。
转载请注明出处:https://golang.0voice.com/?id=1058

分享:
扫描分享到社交APP
上一篇
下一篇
发表列表
游客 游客
此处应有掌声~
评论列表

还没有评论,快来说点什么吧~

联系我们

在线咨询: 点击这里给我发消息

微信号:3007537140

上班时间: 10:30-22:30

关注我们
x

注册

已经有帐号?