MySQL 8.0 Database Administrator — Question 22

What does the binlog dump thread do?

Answer options

• A. It monitors and schedules the rotation/deletion of the binary logs.
• B. It reads the relay log and executes the events contained in them.
• C. It acquires a lock on the binary log for reading each event to be sent to the slave.
• D. It connects to the master and asks it to send updates recorded in its binary logs.

Correct answer: D

Explanation

The binlog dump thread's primary function is to connect to the master server and request it to send updates recorded in its binary logs, which is why D is correct. Option A is incorrect as it pertains to log management rather than updates, B is about relay logs which are not the focus here, and C incorrectly describes the locking mechanism that is not part of the binlog dump thread's responsibilities.