Hey, I have some code that does a bunch of tests. I keep saying I'm going to release it, but I don't get around to it.
My code does the following: - checks that the schema matches - check that keys match - check that foreign keys match - check that row counts match - checksums the whole table in 5000 row increments to verify the data matches (a lot faster than comparing row by row, but my code requires that each table has a numeric, single primary key, like int(11)) If you're interested, you could be an early beta tester :) On Fri, 7 Jan 2005 05:16:49 -0500 (EST), RV Tec <[EMAIL PROTECTED]> wrote: > Folks, > > I'm doing replication (one master, two slaves) with MySQL 4.0.23. I'm > really happy with it. Although, every once in a while, the slaves get > desync'ed, one at a time (the DB is 6GB large, and has 140 tables). > > I can't explain why this desync happens, but this wouldn't be a problem if > I had a way (smart and trustable) to verify the integrity of the slave. > Does anyone know how I can accomplish this? > > Today I'm doing a thousand queries on both servers (master/slave) to > compare the results, but this keeps my servers unavailable temporarily > (have to flush tables with read lock). > > Any thoughts on this? > > Thanks a lot! > > Best regards, > RV Tec > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
