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