Hi, I am trying to use dbmail on two mail server hosts. On both hosts is pointing MX record so both of them receive mails. On each host is running postfix+dbmail+mysql. As I use mysql bidirectional replication, every mail that is stored in database on one host is also stored on another host and vice versa (bidirectional replication). I am doing this to achive load balancing + high availability. If one host dies I still have all mails and there is no downtime.
The only trick I had to do is to put in my.cnf on one host: auto_increment_increment = 2 auto_increment_offset = 1 and on another host: auto_increment_increment = 2 auto_increment_offset = 2 with this I avoid problems with duplicate keys. What I am concerned about is dbmail-util. I suppose that it should run only on one host, but I don't know if it will somehow confrontate with bidirectional replication. Did any of you have experiance with that? Thanks, Andreja -- View this message in context: http://www.nabble.com/dbmail-and-mysql-bidirectional-replication-tf3845449.html#a10890298 Sent from the dbmail users mailing list archive at Nabble.com. _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
