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:36:05 CDT


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).

> > o timeout detection, so that the Postfix system doesn't hang while
> > querying or connecting to broken MySQL server (new).
> >
> > Patch:
> >
> > http://webs.uolsinectis.com.ar/lesanti/postfix/postfix-2.0.11-dict_mysql.patch
> >
> > Applies to 2.0.12 as well.
>
> That is a lot of change. I recommend some testing with a memory
> leak tester.

Always do (I use valgrind and YAMD). But I'm not asking for this to go in
2.0.12 in any way, I just need to get this running by the end of the month
and It'd be better for me if someone find this useful, test it and report
possible problems.

Thanks,
Leandro