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.
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.
Explanation:
B and E
http://dev.mysql.com/doc/refman/5.6/en/replication-features-temptables.html
B, E
B, E
I believe A & E.
A- by allowing table/s which need to be replicated .
E- “– replicate-ignore-table” is best option to ignore to replicate.
Please, Could any one explain why B?
http://dev.mysql.com/doc/refman/5.6/en/replication-rbr-usage.html
Reason for B is : Temporary tables are not replicated when using row-based format.