mysql>stop slave;
mysql>CHANGE MASTER TO MASTER_DELAY = 300;
mysql>start slave;
mysql> show slave status \G
SQL_Delay: 300（单位秒）
SQL_Remaining_Delay: NULL

主库 :
create database delay charset utf8mb4;
use delay;
create table t1 (id int);
insert into t1 values(1),(2),(3);
commit;
drop database delay;

从库:
-1.停止 从库SQL 线程,获取relay的位置点
mysql> stop slave sql_thread;
mysql> show slave status \G
Relay_Log_File: db01-relay-bin.000002
Relay_Log_Pos: 320

-2. 找到relay的截取终点
show relaylog events in "db01-relay-bin.000002"；

-3. 截取relay
[root@db01 data]# cd /data/mysql3308/data/
[root@db01 data]# mysqlbinlog --start-position=320 --stop-position=993 db01-relay-bin.000002 >/tmp/relay.sql

-4. 恢复relay到从库
[root@db01 data]# mysql -uroot -p123 -S /data/mysql3308/mysql.sock
mysql> set sql_log_bin=0;
mysql> source /tmp/relay.sql

主库:
show master status ;
binlog_do_db 白名单
binlog_ignore_db 黑名单
从库:
mysql> show slave status \G
库级别（常用）
Replicate_Do_DB: 白名单
Replicate_Ignore_DB: 黑名单
表级别
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:

例子:
vim /data/mysql3308/my.cnf
#从库需要复制指定的库
replicate_do_db=repl
[root@db01 data]# systemctl restart mysqld3308

1) 清理环境
pkill mysqld
\rm -rf /data/mysql/data/*
\rm -rf /data/binlog/*

(2) 准备配置文件 一主两从高可用
主库db01：
cat > /etc/my.cnf <<EOF
[mysqld]
basedir=/application/mysql/
datadir=/data/mysql/data
socket=/tmp/mysql.sock
log_error=/data/mysql/mysql_error.log
server_id=51
port=3306
secure-file-priv=/tmp
autocommit=0
log_bin=/data/binlog/mysql-bin
binlog_format=row
gtid-mode=on
enforce-gtid-consistency=true
log-slave-updates=1
[mysql]
#显示库
prompt=db01 [\\d]>
EOF

slave1(db02)：
cat > /etc/my.cnf <<EOF
[mysqld]
basedir=/application/mysql
datadir=/data/mysql/data
socket=/tmp/mysql.sock
log_error=/data/mysql/mysql_error.log
server_id=52
port=3306
secure-file-priv=/tmp
autocommit=0
log_bin=/data/binlog/mysql-bin
binlog_format=row
gtid-mode=on
enforce-gtid-consistency=true
log-slave-updates=1
[mysql]
prompt=db02 [\\d]>
EOF

slave2(db03)：
cat > /etc/my.cnf <<EOF
[mysqld]
basedir=/application/mysql
datadir=/data/mysql/data
socket=/tmp/mysql.sock
log_error=/data/mysql/mysql_error.log
server_id=53
port=3306
secure-file-priv=/tmp
autocommit=0
log_bin=/data/binlog/mysql-bin
binlog_format=row
gtid-mode=on
enforce-gtid-consistency=true
log-slave-updates=1
[mysql]
prompt=db03 [\\d]>
EOF

(3) 初始化数据
mysqld --initialize-insecure --user=mysql --basedir=/application/mysql --datadir=/data/mysql/data

(4) 启动数据库
/etc/init.d/mysqld start

(5) 构建主从：
master:51
slave:52,53

51:
grant replication slave on *.* to repl@‘10.0.0.%‘ identified by ‘123‘;

52\53:
change master to
master_host=‘10.0.0.51‘,
master_user=‘repl‘,
master_port=3306,
master_password=‘123‘ ,
MASTER_AUTO_POSITION=1; #自动请求日志，获取gtid
start slave;