1. 两台mysql服务器,并处于同一局域网中。(参见mysql8安装)
2. Master创建账号并授权Replication Slave权限
CREATE USER 'admin'@'%' IDENTIFIED BY '123456';
GRANT REPLICATION SLAVE ON *.* TO 'admin'@'%';
3. Master下/etc/my.cnf文件中加入
log-bin = mysql-bin
server-id = 1 #必须为纯数字,不能为0或空
4. 重启Master下mysql
systemctl restart mysqld.service
5. Slave下/etc/my.cnf文件中加入
server-id = 2
6. 重启Slave下mysql
systemctl restart mysqld.service
7. Master下查询状态
SHOW MASTER STATUS
8. Slave配置连接master参数
停止slave
stop slave;
配置连接参数
CHANGE MASTER TO
MASTER_HOST = '192.168.1.111', #master地址
MASTER_USER = 'admin', #master上创建的账户
MASTER_PASSWORD = '123456',
MASTER_LOG_FILE = 'mysql-bin.000001', #master的file
MASTER_LOG_POS = 156; #master的position
开启slave
start slave;