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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dominic Cleal Sent: Friday, August 18, 2006 11:24 PM To: [email protected] Cc: [EMAIL PROTECTED] Subject: Re: [exim] Mail Implementation Design On Fri, 18 Aug 2006 10:48:43 +0200 "GamCo - Gawie Marais" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] -- ## 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/ -- ## 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/
