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: Wietse Venema (wietseporcupine.org)
Date: Wed Jun 11 2003 - 13:15:23 CDT


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.

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

        Wietse