Posted on 2011-10-21
I have three sites and I'd like the mysql databases to be replicated between all three sites. I would like them to all be writeable and then replicate to the other two servers.
I've been reading up on master-slave and it concerns me. I've read about slaves getting out of sync. Tools to make sure they are in sync would be nice too.
The servers are not in use in the middle of the night so I could run some tools that check db checksums and compare, then run tools to re-sync the db's between servers if needed. I need a recommendation of what tools really work.
These aren't facebook servers, medium-lite to medium usage from 7-7pm Mon-Sat.