[Dovecot] multiple sql servers - loadbalancing and failover

[Seth Mattinen]

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