Mysql8 数据库集群

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;