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
So your telling me there will never be any lock contention between different
masters? That is not the experience shared on the list earlier. But perhaps
mysql's replication has seen improvements in this field. Only Real-World
experiences like your own can tell, I guess.
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
