... But I saw a presentation at the Boston MySQL Meetup.com
group about how to do master-master in mysql 5. We're about to
implement this in the next few weeks. ...
I've run into issues with crash recovery in master-master mode:
- master A is at position X
- master B, replicating from A, gets to position X
- master A syncs to its filesystem that it's at position X
- master A receives some inserts, and is now at position Y
- master B, replicating from A, gets to position Y
- master A crashes before the position gets synced to filesystem
- master A gets rebooted, recovers from innodb log, but has itself
only marked at position X
- master B requests position Y from master A, but that position
doesn't exist yet, so replication breaks.
Perhaps someone here knows the proper recovery procedure at this point?
best,
Jeff
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
