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.
Which two changes would ensure that the temporary table does not propagate to the slave?
A. Set binlog_format=MIXED with the —replicate-ignore-temp-table option.
B. Use the —replicate-do-db, —replicate-do-table, or —replicate-wild-do-table option with the value equal to OLD_INVENTORY.
C. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
D. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.
E. Use the —replicate-ignore-table option with the value equal to
OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.
Answer: CE
你想在OLD_INVENTORY数据库中创建临时表OLD_INVENTORY，并且这个表不会被复制到从库。下面哪两个配置可是实现此需求？
C. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
E. Use the —replicate-ignore-table option with the value equal to
OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.http://www.cndba.cn/hbhe0316/article/22793http://www.cndba.cn/hbhe0316/article/22793http://www.cndba.cn/hbhe0316/article/22793

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL