Showing posts with label mysql replication. Show all posts
Showing posts with label mysql replication. Show all posts

Wednesday, April 13, 2011

Fix Corrupt relay logs

Master_Log_File: The name of the master binary log file from which the I/O thread is currently reading.
Relay_Log_File: The name of the relay log file from which the SQL thread is currently reading and executing.

Relay_Master_Log_File: The name of the master binary log file containing the most recent event executed by the SQL thread.


-- The status below is most often cause by network connection between slave and master being dropped while slave while slave is reading master's binary log to create the relay log.
-- The "Last_error:" message states that it could be master binary or slave relay log corruption. It is usually slave relay corruption because it is much easier to corrupt this log.