On Mon, 2009-09-28 at 17:05 -0700, tabris wrote: > Additionally, we do (at my employer) have master<->master replication > setup with both sides able to insert, and afaict everything works fine > except for the occasional clash over the headername table. It's been advised against doing this, do a search through the mailing list archives. There is an issue with IMAP message id's (not auto-increment fields) so some new messages wont be shown on the logged-in imap clients. Might be ok for mostly POP3 installs or for low usage. How many messages per day is this setup storing? What happens when one server starts to lag with the updates?
The clashes in the headername table rings alarm bells for me. If your setup starts to get under stress or has a lot of concurrent requests these problems will escalate. If you're going to use master-master replication setup, just use ucarp or heartbeat and only have one server active. It will save you headaches down the track. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
