OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: (patch) Enhanced MySQL driver

From: Leandro Santi (lesantiuolsinectis.com.ar)
Date: Wed Jun 11 2003 - 13:40:07 CDT


On Wed, Jun 11, 2003, Leandro Santi wrote:
> On Wed, Jun 11, 2003, Wietse Venema wrote:
> > Leandro Santi:
> > > Features:
> > >
> > > o round robin-like query dispatch, for load balancing. This was already
> > > present on my previous (2.0.10) patch.
> >
> > This is not necessary. Postfix daemon processes are already designed
> > to terminate voluntarily after some number of requests. We still
> > need to figure out an elegant solution to make the trivial-rewrite
> > server go away on a busy system, but that server only queries domain
> > lists (mydestination, virtual_{alias,mailbox}_domains, relay_domains),
> > transport maps and relocated maps.
> >
> > It should therefore be sufficient to toss a coin when selecting a
> > host for the initial MySQL connection. Now, round robin can still
> > be used when you lose a MySQL server and look for a replacement.
>
> The coin method wouldn't work for max_use = 0 (OK, its not a documented
> feature).

On second tought, it *will* work if there are statistically enough spawned
daemons (each with max_use = 0).

Thanks,
Leandro