That is what I have been doing... A -> B -> A with both A & B having lmtp & mysql. I think my hole problem was I had a misconfiguration the command line with out checking what was in the my.cnf file first. I had conflicting options... Helps to read _ALL_ the documentation...
On Wed, 2005-01-19 at 09:09 +0100, Simon Lange wrote: > 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 > > > > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
