1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ151

Architecture

What function does the slave SQL thread perform?

  • A connects to the master and asks it to send updates recorded in its binary logs
  • B monitors and maintains channel connections if multiple replication channels are used
  • C reads the relay log and executes the events contained in them
  • D acquires a lock on the binary log for reading each event to be sent to the slave
Explanation

The replication SQL (applier) thread reads events from the relay log and executes them on the replica. The replication I/O/receiver thread, by contrast, connects to the source and writes received events to the relay log.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!