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]

Reply via email to