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/
