移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

多选题

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?()

发布日期:2020-04-10

You want to create a temporary table named OLD_INV...
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

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!

此试题出现在

CMS专题

CMS专题

去刷题
热门试题热门资讯 相关试题

暂无相关推荐~