1include/master-slave.inc 2[connection master] 3connection slave; 4include/stop_slave.inc 5# 6# Category 1) DO_DOMAIN_IDS and IGNORE_SERVER_IDS specified together 7# 8# Id filtering variable values should be empty initially 9# Set id filtering variables 10CHANGE MASTER TO DO_DOMAIN_IDS=(1), IGNORE_DOMAIN_IDS=(), IGNORE_SERVER_IDS=(3), MASTER_USE_GTID=SLAVE_POS; 11# do domain id list: 1 12# ignore domain id list: 13# ignore server id list: 3 14# RESET SLAVE ALL should clear values for all id filtering variables 15RESET SLAVE ALL; 16change master to master_port=MASTER_MYPORT, master_host='127.0.0.1', master_user='root'; 17include/start_slave.inc 18include/stop_slave.inc 19# 20# Category 2) IGNORE_DOMAIN_IDS and IGNORE_SERVER_IDS specified together 21# 22# Id filtering variable values should be empty initially 23# Set id filtering variables 24CHANGE MASTER TO DO_DOMAIN_IDS=(), IGNORE_DOMAIN_IDS=(2), IGNORE_SERVER_IDS=(3), MASTER_USE_GTID=SLAVE_POS; 25# do domain id list: 26# ignore domain id list: 2 27# ignore server id list: 3 28# RESET SLAVE ALL should clear values for all id filtering variables 29RESET SLAVE ALL; 30change master to master_port=MASTER_MYPORT, master_host='127.0.0.1', master_user='root'; 31include/start_slave.inc 32include/stop_slave.inc 33# 34# Category 3) Null check - edge case with all empty lists to ensure a 35# lack of specification doesn't break anything 36# 37# Id filtering variable values should be empty initially 38# Set id filtering variables 39CHANGE MASTER TO DO_DOMAIN_IDS=(), IGNORE_DOMAIN_IDS=(), IGNORE_SERVER_IDS=(), MASTER_USE_GTID=SLAVE_POS; 40# do domain id list: 41# ignore domain id list: 42# ignore server id list: 43# RESET SLAVE ALL should clear values for all id filtering variables 44RESET SLAVE ALL; 45change master to master_port=MASTER_MYPORT, master_host='127.0.0.1', master_user='root'; 46include/start_slave.inc 47include/stop_slave.inc 48############################ 49# Cleanup 50############################ 51connection slave; 52change master to master_port=MASTER_MYPORT, master_host='127.0.0.1', master_user='root'; 53include/start_slave.inc 54include/rpl_end.inc 55