centos7之Mysql主从复制
1、两边主机,开启防火墙端口:firewall-cmd --zone=public --add-port=3306/tcp --permanent # 开放3306端口
2、主服务器:
1、yum install ntp -y
vim /etc/ntp.conf:添加:
server 127.127.主机ip的这个数字.0
fudge 127.127.主机的这个数字.0 stratum 8
2、关闭防火墙,打开 ntp 服务:
systemctl stop firewalld
setenforce 0
systemctl start ntpd.service
systemctl start firewalld
3、编辑 vim /etc/my.cnf
server-id=11
log-bin=master-bin
log-slave-updates=true
4、重启mysql服务:systemctl restart mysqld.service
5、进入 mysql:mysql -u root -p
6、授予服务同步:GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
7、刷新MySQL命令,使立即生效:FLUSH PRIVILEGES;
8、查看主状态: show master status;
3、从服务器
1、yum install ntp -y
2、关闭防火墙,打开 ntp 服务:
systemctl stop firewalld
setenforce 0
systemctl start ntpd.service
/usr/sbin/ntpdate 172.16.76.199
systemctl start firewalld
3、编辑 vim /etc/my.cnf
#修改ID号,切记!每一个MySQL服务器都不一样
server-id=22
#从主服务器上同步日志文件记录到本地
relay-log=relay-log-bin
#定义relay-log的位置和名称
relay-log-index=slave-relay-bin.index
4、重启mysql服务:systemctl restart mysqld.service
5、进入 mysql:mysql -u root -p
6、配置服务主机:CHANGE MASTER TO MASTER_HOST='172.16.76.199', MASTER_PORT=3306, MASTER_USER='root', MASTER_PASSWORD='123456', MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=154;
7、刷新:start slave;
8、查看主服务器状态: show slave status\G