On Fri, 2007-03-30 at 11:56 +1000, Jake Anderson wrote: > > When I first installed my test systems I had MySQL in master-master > > replication which worked great, but my bubble was burst with the IMAP > > ID not being guaranteed to be incrementing for each message. I found > > that the traffic on the network using the built-in replication was > > about 20% of the traffic on the network using drbd (plus writes should > > be faster) > > > I'd run multi-master and then use a perdition setup on each machine such > that users only access one machine for their email. As all reads/writes > for one user happen on one machine you should avoid that problem. > If you have a failure then all users get pointed to the one machine and > everything keeps going.
Perdition would solve the IMAP UID problem, but it doesn't help with the plain old auto_increment collisions... If we combined Perdition with per-server auto_increment id windows, then I think we'd be onto something! Aaron _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
