Monitor MySQL replication
The most important variables are Slave_IO_Running, Slave_SQL_Running and Seconds_Behind_Master. Two first variables should be equal to ‘Yes’, and Seconds_Behind_Master should be 0 or close to it. These variables indicate that both replication threads are running and slave is up to date with master.
Post a Comment