MySQL 8.0 Database Administrator — Question 42

You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database.
Which replication filter contributes to your goal?

Answer options

• A. on slave: --replicate-wild-ignore=example.%
• B. on slave: --replicate-ignore-db=example
• C. on master: --replicate-ignore-db=example
• D. on master: --binlog-ignore-db=example
• E. on slave: --binlog-ignore-db=example

Correct answer: C

Explanation

The correct answer is C because using --replicate-ignore-db=example on the master prevents the replication of the example database to the slave, thereby reducing the amount of data transferred. The other options either apply filters on the slave or do not correctly address the data transfer from the master, making them ineffective for this goal.