Re: Verifing Data Integrity

To thoroughly verify data in a table slave/master, first stop the db applications.

Then sum any numeric columns (I prefer a floating columns.) e.g.,

select sum(columnfp1), sum(colmnfp2) from table1;

Do this on both master and slave. Should point out that if you choose an index with numeric value it will be much faster.

Bob B

• Original Message ---- From: Andrew Brosnan <andrew@broscom.com> To: Paul Sindelar <paul.lists@mnwebhost.net> Cc: replication@lists.mysql.com Sent: Saturday, July 14, 2007 6:14:55 PM Subject: Re: Verifing Data Integrity

On 7/14/07 at 12:18 PM, paul.lists@mnwebhost.net (Paul Sindelar) wrote:

> Does anyone know a reliable/efficient way of thoroughly verifying
> the integrity of a slave?

Would this be done on a routine basis? I think it's more realistic to do routine sanity checks - perhaps you already do. What I do is check for same number of records on master and slave, thoroughly verify *some* of the data by checking random rows, compare file sizes, etc. I can't imagine going through bit by bit without suspecting a problem. I think I'd be more likely to reset the slave with a new snapshot of the masters data. :-)

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

Regards,
Andrew

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






      ____________________________________________________________________________________
Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center.
http://autos.yahoo.com/green_center/ 

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