Yes, thiz why the slave be localhost on same machine work many time faster, backup host set for master database server as last resort fallover since network traffic bottleneck
Hope Timo comment on option, so far he ignore thread, so maybe no plan now.
On Fri, May 24, 2013 at 6:24 PM, Reindl Harald h.reindl@thelounge.netwrote:
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