1Z0-888 Exam Dumps | You want to create a temporary table named OLD_INVENTORYin the OLD

<< Prev Question Next Question >>

Question 31/44

You want to create a temporary table named OLD_INVENTORYin the OLD_INVENTORYdatabase 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. Change the binlog_formatoption to ROW and restart mysqld before you create the OLD_INVENTORYtable.

C. Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.

D. Use the --replicate-ignore-tableoption with the value equal to
OLD_INVENTORY.OLD_INVENTORYand restart mysqldbefore creating the temporary table.

E. Stop SQL_THREADon the slave until you have finished using the OLD_INVENTORYtemporary table.

Question 31/44

LEAVE A REPLY

Download PDF File