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
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
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