问题描述：
[多选]
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．（）要在主服务器上的OLD_INVENTORY数据库中创建一个名为OLD_INVENTORY的临时表。此表不会复制到从属服务器。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. 在创建OLD_INVENTORY表之前，将binlog_format选项更改为ROW并重新启动mysqld。
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.
参考答案：查看无
答案解析：无
☆收藏
答案解析：无
☆收藏
上一篇：What are three facts about backups with mysqldump？（）关于使用mysqldump进行备份的三个事实是什么？
下一篇：Consider the three binary log files bin．00010， bin．00011， and bin．00012 from which you want to restore data．（）考虑要从中恢复数据的三个二进制日志文件bin．00010、bin．00011和bin．00012。Which method would use mysqlbinlog for greater consistency？哪种方法可以使用mysqlbinlog来实现更高的一致性？
- 我要回答: 网友(216.73.216.168)
- 热门题目: 1.患者，女性，20岁，诊断为精 2.患者，女性，22岁，总经理助 3.患者，女性，36岁。长期社交