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:56:04 CDT


On Wed, Jun 11, 2003, Wietse Venema wrote:
> Leandro Santi:
> > 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).
>
> "max_use = 0" is rejected with a fatal error message.

Oh. But... what about the proxymap? If someone uses the proxymap as a way
to save lots of MySQL connections, then the coin method can have somewhat
poor fairness performance (because the number of processes won't be
always high enough -statistically speaking, of course-).

Thanks,
Leandro