|
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 (lesanti
uolsinectis.com.ar)
Date: Wed Jun 11 2003 - 13:56:04 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]