What is the log in which data changes received from a replication master server are written?

Solution (By Examveda Team)

This question is about how MySQL manages data replication. Replication is like copying information from one database server (the master) to another (the slave).

Think of it like making a copy of a file on your computer. When you change the original file, you have to update the copy. In MySQL, the slave server needs to know about any changes made on the master server.

So, the question is asking: where does the slave server store the information about the changes it needs to apply?

Here's the breakdown of the options:

Option A: error log: This log records any errors that happen in MySQL, but not changes in the data.

Option B: general query log: This log tracks all the queries executed by the server, but it doesn't focus specifically on replication changes.

Option C: binary log: This log is where the master server records all the changes to the database. The slave server reads this log to learn about the updates. This is a crucial part of replication.

Option D: relay log: This log is where the slave server stores the information it reads from the master's binary log. The slave uses this information to apply the changes to its own database.

Therefore, the answer is Option D: relay log.