The mailing list for listmasters using Sympa

[address@concealed]

Chris Andrews wrote:
> I was trying to look for some info on sizing a Sympa server.  Here are our
> stats:
>
> 230,000 subscriptions
> 130,000 unique email addresses
> 2300 lists
>
> So based on what I know about Sympa's database needs that is close to
> 400,000 records.  I have setup Sympa to use MySQL, but now I am thinking of
> moving it to an Oracle DB in our database warehouse.  I know a large number
> of these lists are defunct, so we might lose half the lists and one half to
> one quarter of the subscriptions and half the unique email addresses, but
> even so that will be a large data base.
>
> Hardwarewise I have a dual CPU Zeon Blade with 4 GB of ram and 30 GB of
> storage on an EMC SAN.
>
> Other software we are using sendmail, clamav (with the clamav-milter) and
> spamassassin (using MIMEdefang).
>
> Does any one have an install similar to this in terms of defined addresses
> and lists?
>   
Yes it quite similar with our server (hosting address@concealed). We 
have less lists (600) but many very big lists 140,000 subscribers 
260,000 subscriptions. The outgoing traffic is hight (up to 1.5 million 
message per day).

The server is a 5 year old dual CPU with 4 GB of ram. It is configured 
with  a sendmail "smart host" feature in order to relay all outgoing 
mails to a dedicated MTA so the overhead coming from sendmail processus 
is mainly supported by a second server.

The server is dedicated for Sympa and its web interface (both html user 
interface and soap server stronly used). The response time is usually 
quite good but the server is very busy. We known our configuration could 
be stronger . We are going to move to a quadri dual core processor with 
4GB ram in a few weeks.

MySQL is not a limit and the server is running on the same server. (we do not 
use yet database replication)

Serge Aumont