Verifing Data Integrity

Does anyone know a reliable/efficient way of thoroughly verifying the integrity of a slave? I'd like to run occasional tests and compare the data on a slave to that of the master. I've thought about writing a job to go through each table and compare the data (insanely time/resource consuming) or using something outside of MySQL like a filesystem tool to compare the raw files themselves. But I'm not sure if a MD5 or other hash would be accurate enough, or if I'd have to go bit-by-bit. Plus I'd have to lock each table as I compare them. The servers are Linux based and I'm running MySQL 4.1.x and will be upgrading to 5.0 this fall.

Thoughts and comments welcome. Thanks in advance all.

-Paul

--

MySQL Replication Mailing List
For list archives: http://lists.mysql.com/replication To unsubscribe: http://lists.mysql.com/replication?unsub=lists@pantek.com Received on Sat Jul 14 13:18:41 2007