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.
Showing posts with label mysql replication. Show all posts
Showing posts with label mysql replication. Show all posts
Wednesday, April 13, 2011
Subscribe to:
Posts (Atom)