On Wed, Jan 19, 2005 at 09:09:09AM +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
Won't this only work in an ideal world? As soon as there is any latency in replication, multiple masters will use the same auto_increment value, and kill replication. Am I missing something? xn
