Re: Verifing Data Integrity

On Jul 17, 2007, at 11:20 AM, Rick James wrote:

> If you could extract
> SELECT MD5(concat(all the fields)) FROM foo ORDER BY 1;
> would be a nearly perfect hash. It would require a table scan
> (indexes
> useless). Then take the output, store it in a file, and take the
> MD5 of the
> file. This gives you a single, fairly short string that is quite
> adequate
> for comparing between master and slave.

We do something similar to this, we use mysqldump and pipe the output to md5. It's fairly useful, but you will wind up with disagreements on anything with a float in it (at least).

--Ware

-- 
MySQL Replication Mailing List
For list archives: 
http://lists.mysql.com/replication
To unsubscribe:    
http://lists.mysql.com/replication?unsub=lists@pantek.com