【多选题】
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.<br /> Which two changes would ensure that the temporary table does not propagate to the slave?（）
A、Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
B、Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
C、Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
D、Set binlog_format=MIXED with the – replicate-ignore-temp-table option
E、Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
查看正确答案
