Re: Slave integrity.

2005-01-11 Thread Ware Adams
On Jan 7, 2005, at 5:16 AM, RV Tec 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 help with verifying your slave, bu

Re: Slave integrity.

2005-01-07 Thread Gary Richardson
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

Slave integrity.

2005-01-07 Thread RV Tec
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