Which two are true about binary logs used in asynchronous replication? (Choose two.)

Question

Options

• AThey are pushed from the master to the slave.
• BThey contain events that describe database changes on the master.
• CThey contain events that describe all queries run on the master.
• DThey contain events that describe only administrative commands run on the master.
• EThey are pulled from the master to the slave.

• A
  92% (12)
• E
  8% (1)

Explanation

In asynchronous replication, binary logs serve as the master's record of database-changing events (DML like INSERT/UPDATE/DELETE and DDL like CREATE/ALTER), which the master then pushes to the slave's relay log - making B correct because they capture data-changing events, and A correct because the master's dump thread actively sends those events to connected slaves.

C is wrong because binary logs do not record all queries - read-only queries like SELECT are never written to the binary log, only statements that modify data or schema. D is wrong because administrative commands alone are not the focus; data changes are the primary content. E is wrong because the flow is master-to-slave (push), not slave-initiated pulling - the slave connects and the master streams events outward.

Memory tip: Think of binary logs as a "changelog, not a query log." The master broadcasts its changes outward (push), and only writes events that changed something - if it didn't modify data, it wasn't logged.

No community discussion yet for this question.