Hello All, I would like to setup a redundant mail setup using DBMAIL as the mailstore, and Exim as the MTA.
I currently have 2 dbmail MX's, one hosts the database and the other just does mail relay. What I would like to have is the following: - Two mail servers, both with the dbmail application - One MySQL database on the master MX - One MySQL database on the secondary MX - The primary will be the only database that has data inserted into it from either MX - The secondary database will be a replicated database, identical to the master MX database My question is: Can I have two MX hosts updating the same database? What if there is an insert at precisely the same time from both MX hosts? Will each seperate message that is inserted get it's own message_idnr? Will it all stay consistent? Just in case you are wondering, I am working on a way to use the secondary dbmail database as a failover database. When the main database is deemed unaccessible by some method, the slave database will be changed from a slave to the master database. Then the DNS will be updated to point to the new master database, and the MX host will then start doing updates on the new master database. It's either this, or I will have to wait until a driver is created for dbmail- 1.2.9 that works with MaxDB instead of MySQL. Hopefully someone can answer my questions. Thank you, Angus -- Open WebMail Project (http://openwebmail.org)
