You have to make sure all dbmail instances connect to the same master. Dbmail
will create auto_increment keys on all tables, so when a write action occurs on
a multi-master setup those fields will break the replication.
There has been some discussion about how to remedie this, but don't hold your
breath. It's on the 2.4 timeline at the earliest.
Steven Lynn wrote:
I know that this is probably a MySQL question, but I figured I would
start here. Hope no one minds...
Is anybody using multiple dbmail servers that are also running MySQL
with replication? I have two servers and trying to do fail over between
the two. I can not seem to keep the two servers in sync. If I leave both
running, within 24 hours, one is out of sync...
Anybody got any ideas? Once again, sorry for this question...
--
Steven Lynn
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
------------------------------------------------------------------------
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
