On Monday 05 July 2004 03:06 pm, [EMAIL PROTECTED] wrote:
> This mail store server is responsible for the store of the
> vpopmail/domains directory (NFS mounted by the 'client servers') and run
> SQL select queries to verify passwords... The read / writes on the disks
> are reaching the limit of the IDE RAID controller and the 100-base
Assuming you're using this central machine also as your (only) mysql server
for the cluster, there are several things you can do to increase the
1) replicate the backend mysql server to the front machines and configure
vpopmail with mysql replication support and have each 'node' talk to its own
local mysql server. This will decrease the amount of traffic across the
network, and the load on the nfs server TREMENDOUSLY.
2) set up a dedicated mysql server (or cluster) and perhaps even set it up on
a different physical network from that of your NFS server (multiple NIC cards
in each machine) and have vpopmail talk to that. I would recommend 1 over 2
as it's easier to set up and to 'migrate to' (you can do it while you're
live) and doesn't require purchasing more equipment, and also decentralizes
everything all at once!
Also, on top of that, I would consider disabling auth logging as it performs
an insert/update upon every authentication which, no matter what will go back
to your central mysql server, and if you have mysql being replicated, will be
replicated to the front machines, which will almost nearly negate any
performance increases you may (and very likely will) see by switching to a
replicated mysql configuration.
Also! (last one, I promise!) if you're using vpopmail's roaming users support,
stop now. completely disable roaming users in your vpopmail configuration
and set up Bruce Guenter's relay-ctrl package
(http://untroubled.org/relay-ctrl). No funky cronjob to run, no patches
required to ucspi-tcp (there's a patch out there to make it talk to mysql,
eek) no central cdb file to rebuild upon connection attempts, AND it's safe
to mount the spool directory on NFS (I've done it) as it doesn't require
locking or anything.
Hope this helps.
Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc.
[EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l
kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail