Re: [exim] Mail Implementation Design

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Dominic Cleal
Ημερομηνία:  
Προς: exim-users
Υ/ο: gawie
Αντικείμενο: 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@???