Arkadiusz Miskiewicz wrote: > On Friday 27 of March 2009, Seth Mattinen wrote: >> Arkadiusz Miskiewicz wrote: >>> On Friday 27 of March 2009, Xueron Nee wrote: >>>> You can try mysql-proxy: >>>> >>>> http://dev.mysql.com/downloads/mysql-proxy/index.html >>> This introduces single point of failure. >> http://forge.mysql.com/wiki/MySQL_Proxy#Load_Balancing_.26_Failover > > If I get this right if mysql proxy fails I still get nothing. Hm, I would > have > to run mysql proxy on every machine that has dovecot installed. Then it would > make some sense. > > Ok, that should work.
I used to do it that way (using sqlrelay) before switching to hardware load balancers. It's not really much a single point of failure since it's running on the same machine; it's no different than Dovecot having do the work itself. Simpler than creating a HA cluster, too. ~Seth