1Z0-908 practice question 15 of 25
What does the binlog dump thread do?
Full set: 140 questionsThe binlog dump thread is a thread that runs on the source (master) server. When a replica (slave) connects, the source starts a dedicated binlog dump thread for that replica. This thread's primary responsibility is to read events from the source's binary log files and send them over the network to the replica's I/O thread. To ensure data consistency and prevent corruption while reading, the binlog dump thread acquires a lock on the binary log for each event it reads before sending it.
A. This describes binary log maintenance, which is managed by server settings like expirelogsdays or manual commands such as PURGE BINARY LOGS, not the binlog dump thread.
B. This describes the function of the SQL thread (or applier thread) on the replica server, which applies changes from the relay log to the replica's database.
D. This describes the function of the I/O thread (or receiver thread) on the replica server, which is responsible for connecting to the source and requesting the binary log stream.
1. MySQL 8.0 Reference Manual
Section 17.2.4
"Replication Threads":
"On the source
there is one thread per connected replica
called a binary log dump thread (or just dump thread). This thread reads events from the binary log and sends them to the replica. Before it starts sending events
it acquires a lock on the binary log. The lock is released when it has read the last requested event." This directly supports option C.
"When a START REPLICA statement is issued on a replica
the replica creates an I/O thread
which connects to the source and asks it to send the events recorded in its binary logs." This confirms that option D describes the replica's I/O thread.
"The replica has an SQL thread that reads the events from the relay log and executes them." This confirms that option B describes the replica's SQL thread.
2. MySQL 8.0 Reference Manual
Section 5.4.4
"The Binary Log":
This section details the PURGE BINARY LOGS statement and the expirelogsdays system variable
which are the mechanisms for managing binary log file deletion. This confirms that option A is a separate administrative function.
Keep practicing
Take the free 1Z0-908 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-908 practice questions
- Question 2You must run multiple instances of MySQL Server on a single host. Which three methods are…
- Question 3Which two tools are available to monitor the global status of InnoDB locking? (Choose two…
- Question 4Which two MySQL Server accounts are locked by default? (Choose two.)
- Question 5All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled. Y…
- Question 6t is a non-empty InnoDB table. Examine these statements, which are executed in one sessio…
- Question 8Examine this command, which executes successfully: $ mysqlrouter --bootstrap user@hostnam…
