On Fri, Jan 25, 2002 at 03:12:02PM +0900, 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. What, you don't trust it?! :-) Seriously, though... The brute force approach is to compare one to the other by running lots of queries and seeing that you get identical results. Another approach might be to run checksums against the raw data file for the table on each machine and compare them. This, of course, only works well if the slave is completely caught up with the master. There's no single answer. It really depends on how hard you want to work. Anymore, I trust that it's working well, but we've been running replication since it was first introduced. So I've got a lot of good experience to provide some confidence. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 22 days, processed 513,362,219 queries (265/sec. avg) --------------------------------------------------------------------- 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
