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]