Re: [exim] Mail Implementation Design

Page principale
Supprimer ce message
Répondre à ce message
Auteur: Dominic Cleal
Date:  
À: exim-users
CC: gawie
Sujet: Re: [exim] Mail Implementation Design
On Fri, 18 Aug 2006 10:48:43 +0200
"GamCo - Gawie Marais" <gawie@???> wrote:

> We are currently using TCP connections to the MySQL database from
> Exim. We have been using MySQL 4.x which is giving us a lot of
> problems with connections and threads used by Exim, due to the
> multiple lookups per any one mail that comes into our mail system. Up
> to a stage where the MySQL database falls over with memory problems.
> Once restarted the MySQL database works perfectly for a couple of
> days again.


I'd suggest using flat files dumped regularly from the database or
using a "proxy" for MySQL which will cache the connections. I think
SQLRelay could perform that task.

> We have been thinking of having the Database server and the Exim
> server running on the same hardware in stead of having one server for
> Exim and one for MySQL.


Have you considered running a slave MySQL server using replication on
the local machine?

--
Dominic Cleal
dominic@???