MySQL一主多从复制（基于GTID）

# must params
server_id =  100
enforce_gtid_consistency       = on
gtid_mode                      = on

# binlog
log_bin = mysqlbin
log_slave_updates = 1
binlog_format = row

# relay log
skip_slave_start = 1

# must params
server_id =  101
enforce_gtid_consistency       = on
gtid_mode                      = on

# binlog
log_bin = mysqlbin
binlog_format = row
master_info_repository = TABLE

# relay log
relay_log_info_repository = TABLE

systemctl restart mysqld

# 备份
mysqldump --single-transaction --master-data=2 --triggers --routines --all-databases -uroot -p > all.sql
# 导出
mysqldump -u username -p dbname > dbname.sql
# 导入
mysqldump -u username -p dbname < dbname.sql

mysql> create user repl@'192.168.43.%' identified by '123456Gao!';
Query OK, 0 rows affected (0.01 sec)

mysql> grant replication slave on *.* to repl@'192.168.43.%';
Query OK, 0 rows affected (0.06 sec)

mysql> change master to master_host = '192.168.43.54',
    -> master_user = 'repl',
    -> master_password = '123456Gao!',
    -> master_auto_position = 1
    -> ;
Query OK, 0 rows affected, 2 warnings (0.07 sec)

start slave;

# 主库创建
create table test_gtid;
# 从库查看
show databases;

mysql -urepl -p123456Gao! -h192.168.43.54