mysql 5.7 gtid主从复制搭建

mysql tar.gz安装可以参考https://www.jianshu.com/p/31bc85527452
mysql yum 安装可以参考https://www.jianshu.com/p/939c0d934569

mysql datadir目录下存在auto.cnf,里面存放的server-id的配置
10.129.26.26 master server-uuid = 11111111-1111-1111-1111-111111111111
10.129.26.27 slave server-uuid = 22222222-2222-2222-2222-222222222222

主配置:

cat /etc/my.cnf

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
socket = /usr/local/mysql/mysql.sock
port = 3306
log-error = /var/log/mysqld.log
pid-file= /usr/local/mysql/mysqld.pid
tmpdir = /tmp
user = mysql
log-bin = /usr/local/mysql/log/mysql-bin
server-id = 1
binlog-format = row
log-slave-updates = true
enforce-gtid-consistency = true
gtid-mode = on
sync_binlog = 1
innodb_flush_log_at_trx_commit = 1 

sql_mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

主mysql>grant replication slave on . to bak@'%' identified by 'bak'; //ip段与账号密码

从配置:

cat /etc/my.cnf

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
socket = /usr/local/mysql/mysql.sock
port = 3306
log-error = /var/log/mysqld.log
pid-file= /usr/local/mysql/mysqld.pid
tmpdir = /tmp
user = mysql
#log-bin = /usr/local/mysql/log/mysql-bin
relay-log = /usr/local/mysql/log/relay-log-bin
server-id = 2
binlog-format = row
log-slave-updates = true
enforce-gtid-consistency = true
gtid-mode = on
read_only = on
sql_mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
sync_binlog = 1
innodb_flush_log_at_trx_commit = 1 

从mysql>change master to master_host='10.129.26.26',master_user='bak',master_password='bak',master_auto_position=1;
从mysql>start slave;

主mysql>show master status;
主mysql>show slave hosts;
从mysql>show slave status \G

对于从/ect/my.cnf 可以配置 只同步test 和test1数据库

replicate-do-db = test
replicate-do-db = test1

从库 跳过报错gtid点，如果有多个，重复执行
stop slave ;
set @@session.gtid_next='11111111-1111-1111-1111-111111111111:1234';
begin;
commit;
set @@session.gtid_next=automatic;
start slave;

判断只从延时的方法