Which two are true about binary logs used in asynchronous replication? (Choose two.)
Which two are true about binary logs used in asynchronous replication? (Choose two.)
Binary logs in asynchronous replication contain events that describe database changes on the master, capturing actions such as INSERTs, UPDATEs, and DELETEs. Additionally, in asynchronous replication, the slave typically pulls these binary logs from the master as part of the replication process.
Each replica that connects to the source requests a copy of the binary log. That is, it pulls the data from the source, rather than the source pushing the data to the replica. The replica also executes the events from the binary log that it receives.
A is wrong. Replica pulls from master.
B. They contain events that describe database changes on the master. Binary logs in MySQL contain events that describe changes to the data in the master database. These changes can include INSERTs, UPDATEs, DELETEs, and other data modifications. E. They are pulled from the master to the slave. In asynchronous replication, the slave server typically pulls the binary logs from the master server. The slave connects to the master and requests the binary log events it needs to replicate changes from the master. Option A is not entirely accurate because binary logs are not "pushed" from the master to the slave; instead, they are made available on the master for the slave to pull. Option C and D are incorrect because binary logs do not necessarily contain all queries or administrative commands run on the master; they specifically contain events related to database changes, not all SQL queries or administrative commands.