How to verify if master and slave are in sync
Posted by: Ramdas Hegde
Date: May 14, 2008 06:47PM

I am using MySql community version 5.0.19 in a master-slave combination on Debian Linux.
Being fairly new to MySql administration, i am not sure of the best way to identify if the master and slave are in sync. I did a "show slave status" which showed Seconds_Behind_Master = 0. But when i compare the number of rows for a particular table between the master and slave, i find that the slave has far fewer rows.
Since i just started the replication process on the slave on a new server, i assume the slave is still trying to catch up. Are there any stats that will reflect how delayed the slave is when compared to the master since the "Seconds_Behind_Master" value does not seem to be reliable even though the master and slave are connected on the same LAN via a fast network.



Options: ReplyQuote

Written By
How to verify if master and slave are in sync
May 14, 2008 06:47PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.