Gordan Bobic wrote: > James Greig wrote: >> Hi, >> >> I've probably asked this before however can someone remind me why mysql >> master-master (innodb) replication is not recommend with dbmail? > > It's not "recommended" with anything. By the very nature of it, there is > a potential very nasty race condition inherent in multi-master MySQL > replication. In practice you'd have to be extremely unlucky to encounter > it, but since there is no cluster-wide locking available in this setup, > it is a possibility. FWIW, I use it with multi-master replication. YMMV.
These conditions will not be very rare at all once you start putting pressure on it. But there is another reason in the imap requirements: UID values must be strictly ascending within a mailbox. Since these UID values are the autoincremented primary key on the mailboxes table the only way to avoid collisions in the first place is by stepping them differently on the separate masters, but doing that will collide with the imap requirement I mentioned. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
