On Fri, 2013-05-24 at 10:24 +0200, Reindl Harald wrote:
Am 24.05.2013 09:52, schrieb Edwardo Garcia:
But mysql not problemo, it be Dovecot talk to both, do not want Dovecot to talk to both at same time unless slave (local) copy die
and this mostly for a good resason to support your argument
if you configure "localhost" and the slave in postfix you can be sure in case of postfix that all day long "localhost" is used and only if it fails the slave over TCP/IP
dovecot is using randomly the manitudes slower salve and to make it perfectly worse if you reboot the slave in the wrong moment you trigger errors on the dovecot side which is not the idea of having redundancy on the mysql side
This is how an old broken dovecot used to work, then someone complained and Timo fixed it, I asked him nearly 2 years ago whn he fixed it, that since he was changing its behaviour, it would be beneficial for an option to make it work only in failover mode, he at the time said " might be useful " but has said nothing more since, so NFI if he's even given it a second thought or even put it on his official todo list (since this was back in the 1.2.x days)