Hi Paul J Stevens wrote:
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.
not true. a correct setup of circle replication will do what he needs. we have currently 3 database servers (mysql) configured as a circle replication and two lmtp dbmail instances are running on different server usin "their" own databaseserver. even auto_increment keys are not a problem since any change to the database is spreaded immidietly.... :D
cant await mysql5 stable with real clustering support. :)
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.
as mentioned above. just use mysql's recommended circle replication configuration.
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
-- Simon Lange Director [EMAIL PROTECTED] =================================== PolyNature Design Limited Lueneburger Str 15 DE-21360 Voegelsen Germany FON +49 [0]4131 220121 FAX +49 [0]4131 224730 CELL +49 [0]160 903 000 77 LONDON OFFICE +44 [0]20 7127 6332 =================================== Consulting Management Development Hosting Administration Housing ----------------------------------- If you wish ENCRYPTED mails, ensure you have a certified signature and our public key. You can get both at https://www.trustcenter.de for free
begin:vcard fn:Simon Lange n:Lange;Simon org:PolyNature Design adr:;;Lueneburger Str 15;Voegelsen;NDS;21360;Germany email;internet:[EMAIL PROTECTED] tel;work:+44 (0)20 71276332 tel;fax:+49 (0)4131 224730 tel;home:+49 (0)4131 220121 tel;cell:+49 (0)160 90300077 note;quoted-printable:Consulting=0D=0A= Management=0D=0A= Development=0D=0A= Hosting=0D=0A= Administration=0D=0A= Housing x-mozilla-html:FALSE url:http://www.polynaturedesign.com version:2.1 end:vcard
smime.p7s
Description: S/MIME Cryptographic Signature
