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