1.Slave 筛选选项:
--replicate-do-db ,同步复制哪些库
--replicate-ignore-db,忽略哪些库
--replicate-do-table=db_name.tbl_name,如果要做多个表,则将此选项写多次
--replicate-ignore-table=db_name.tbl_name,忽略表
2.master binLog筛选选项:
--binlog-do-db=db_name
3.系统变量:
18.1.6.5 Global Transaction ID Options and Variables
OPTIONS: System Variables
--enforce-gtid-consistency enforce_gtid_consistency
--gtid-mode gtid_mode
II.监控:
a.SHOW SLAVE STATUS\G
b.
SHOW PROCESSLIST \G;
c.SHOW SLAVE HOSTS