To get the status of the replication slave, it is possible to
check the Last_Error and Last_Errno
fields from SHOW SLAVE STATUS. Unfortunately, they
only give information about the status of the SQL thread
(and not always that either). If the I/O thread fails, for
example, because the server configuration is not correctly set up,
or if the connection to the master is lost due to a network
outage, it is necessary to dig through the error log to find out
the reason. This might be possible, although annoying, for a DBA
to do since he has access to the files on the machine where the
server is running, but when using automatic recovery applications
that watch the status of the replication, this is not practical.
It is also easier to see the status of the server through a
normal client connection, …
Dec
22
2006