Re: [Dovecot] multiple sql servers - loadbalancing and failover

2009-03-27 Thread Noel Butler
On Sat, 2009-03-28 at 06:42, Arkadiusz Miskiewicz wrote: > > # MySQL supports multiple host parameters for load balancing / HA. > > Cool! Can load balancing be disabled and HA left, too? :-) > I find it really works that way only, well noticeably anyway :) <>

Re: [Dovecot] multiple sql servers - loadbalancing and failover

2009-03-27 Thread Arkadiusz Miskiewicz
On Friday 27 of March 2009, Timo Sirainen wrote: > On Mar 27, 2009, at 3:20 AM, Arkadiusz Miskiewicz wrote: > > Is there a way for dovecot to use a pool of sql (mysql) servers and > > load > > balance queries between these? > > > > Also fallback to next available sql server if connection to previou

Re: [Dovecot] multiple sql servers - loadbalancing and failover

2009-03-27 Thread Timo Sirainen
On Mar 27, 2009, at 3:20 AM, Arkadiusz Miskiewicz wrote: Is there a way for dovecot to use a pool of sql (mysql) servers and load balance queries between these? Also fallback to next available sql server if connection to previous one fails. Can dovecot do such things currently? (If not th

Re: [Dovecot] multiple sql servers - loadbalancing and failover

2009-03-27 Thread 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.

Re: [Dovecot] multiple sql servers - loadbalancing and failover

2009-03-27 Thread Arkadiusz Miskiewicz
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. > > Plus use of heartbeat,

Re: [Dovecot] multiple sql servers - loadbalancing and failover

2009-03-27 Thread Arkadiusz Miskiewicz
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/

Re: [Dovecot] multiple sql servers - loadbalancing and failover

2009-03-27 Thread Rick Romero
On Fri, 2009-03-27 at 13:26 +0100, 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. > > Support for switching to next mysql server in

Re: [Dovecot] multiple sql servers - loadbalancing and failover

2009-03-27 Thread Seth Mattinen
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. > Plus use of heartbeat, HA, etc.

Re: [Dovecot] multiple sql servers - loadbalancing and failover

2009-03-27 Thread Seth Mattinen
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

Re: [Dovecot] multiple sql servers - loadbalancing and failover

2009-03-27 Thread Arkadiusz Miskiewicz
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. Support for switching to next mysql server in list if previous fails would be enough. -- Arkadiusz MiƛkiewiczPLD/L

Re: [Dovecot] multiple sql servers - loadbalancing and failover

2009-03-27 Thread Xueron Nee
You can try mysql-proxy: http://dev.mysql.com/downloads/mysql-proxy/index.html On Fri, 27 Mar 2009 11:20:37 +0100 Arkadiusz Miskiewicz wrote: > > Hi, > > Is there a way for dovecot to use a pool of sql (mysql) servers and load > balance queries between these? > > Also fallback to next ava

[Dovecot] multiple sql servers - loadbalancing and failover

2009-03-27 Thread Arkadiusz Miskiewicz
Hi, Is there a way for dovecot to use a pool of sql (mysql) servers and load balance queries between these? Also fallback to next available sql server if connection to previous one fails. Can dovecot do such things currently? (If not this is feature request). -- Arkadiusz Miƛkiewicz