mysql使用gtid方式配置主从同步

log-bin=mysql-bin
binlog_format=mixed
server-id = 1
enforce-gtid-consistency = true
expire_logs_days = 10
gtid_mode = on

log-bin=mysql-bin
binlog_format=mixed
server-id = 2
enforce-gtid-consistency = true
expire_logs_days = 10
gtid_mode = on

SHOW VARIABLES LIKE 'gtid_mode';

CREATE USER 'replication_user'@'从IP' IDENTIFIED BY '密码';

GRANT REPLICATION SLAVE ON *.* TO 'replication_user'@'从IP';

SHOW MASTER STATUS;

CHANGE MASTER TO
  MASTER_HOST = '主IP',
  MASTER_PORT = 3306,
  MASTER_USER = 'replication_user',
  MASTER_PASSWORD = '密码',
  MASTER_AUTO_POSITION = 1;

START SLAVE;