延时从库,过滤复制

工作机制，SQL线程，先不执行relay-log，防止逻辑损坏，主库删库，从库没删库。
CHANGE MASTER TO MASTER_DELAY = 300
start slave;
show slave status;
SQL_DELAY:60

show master status;
binlog_do_log
从库
白名单
mysqld 中写 replicate-do-db=test
–replicate-do-db=test
–replicate-do-table=test
–replicate-wild-do-db=test
黑名单
–replicate-ignore-db=test
–replicate-ignore-table=test
–replicate-wild-ignore-db=test