If this is on a Unix flavor, you can use 'cmp' to compare the data and index files (off-line, of course). Once you know they are identical, you can simply plot the difference between the slave's update log position and the master's update log position. As long as it's always 0, the two are in sync. You can periodically retest with cmp if you don't trust replication.
jamesm On Fri, 25 Jan 2002, Mitsuru Hirai wrote: > Hello. > What would be the most effective way to compare 2 databases to see if > they are identical? This is for the replication. We would like to check > if a slave DB is identical to the primary DB. > > Thank you very much. > > Mitsur Hirai > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
