Re: [exim] Mail Implementation Design

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: GamCo - Mail List
Ημερομηνία:  
Προς: 'Dominic Cleal'
Υ/ο: exim-users
Αντικείμενο: Re: [exim] Mail Implementation Design
Hi Dominic

Thanks for the reply. Would you be able to point me to a guide on creating
the flat files from the DB ?

We will also be looking into the proxy connection to mysql.

Thanks for the thoughts.


Gawie

-----Original Message-----
From: exim-users-bounces@??? [mailto:exim-users-bounces@exim.org] On
Behalf Of Dominic Cleal
Sent: Friday, August 18, 2006 11:24 PM
To: exim-users@???
Cc: gawie@???
Subject: 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@???

--
## List details at http://www.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://www.exim.org/eximwiki/