I am running following setup:

qmail 1.03 + mysql patch
tcpserver etc.

Right now qmail is killing the mySQL database server with requests. I've
seen ppl here on the list with 30k-50k users and I wonder how you manage
to keep the mySQL server alive.

We have about 10k clients. On our homepage there is a CGI program that
checks your email the moment you login.

Problems so far:

The maximum connections to the mySQL server exceeds the limit, causing
downtime on our mail- and web server  as it depends on the same mySQL
server.

So, is there any way to keep the mySQL connections down while keeping
a high uptime of web- and mail server? Anyone written a proxy/wrapper
for mySQL to limit the number of connections to the real mySQL server?

Future setup: qmail + vpopmail with even higher number of users.

Please advice

Michael Boman

PS
Having a separate mySQL servers for mail and web is not a option, as
it would give our CGI programs more to do and by that making
the web-server load too high... Plus it would be another server
to manage.
DS


-- 
W I Z O F F I C E . C O M  -  Your Online Wizard 
16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778
Ring  : (65) 844 3228 [ext 118]  Fax : (65) 842 7228
email : [EMAIL PROTECTED]    URL : http://www.wizoffice.com

Reply via email to