Mysql 基于GTID主从复制

环境

主（master）：111.231.44.78
从（salve） ：121.5.71.127

master 配置

# /etc/my.cnf
[mysqld]
server-id=78
log-bin=mysql-bin
log-slave-updates=true
skip_slave_start=1
gtid-mode=ON
enforce_gtid_consistency=on

salve 配置

# /etc/my.cnf
[mysqld]
server-id=127
relay_log=mysql-relay-bin
read_only=1
log-bin=mysql-bin
log_slave_updates=1
gtid-mode=ON
enforce_gtid_consistency=on

master节点建立授权用户

# mysql5.7 版本
GRANT REPLICATION SLAVE ON *.* TO 'copyuser'@'121.5.71.127' IDENTIFIED BY  '密码';
# mysql8.0 版本
create user 'copyuser'@'121.5.71.127' identified by '密码';
grant all privileges on *.* to 'copyuser'@'121.5.71.127' with grant option;
# 刷新
FLUSH PRIVILEGES;、
#  查看主节点状态
SHOW MASTER STATUS;

slave 节点建立链接

CHANGE MASTER TO
MASTER_HOST='111.231.44.78',
MASTER_USER='copyuser',
MASTER_PASSWORD='=密码',
MASTER_PORT=3306,
MASTER_AUTO_POSITION = 1;

# 启动从节点同步
start slave;