Best Choice for Bayes filtering on SpamAssassin

[Noc Phibee <no...@phibee.net>]

Hi

i have 6 servers running on spamassassin 3.1.7 (now after a upgrades).
Actually, all have Bayes Filering with local Db (default db, not sql)

I want know what is the best choice ? :
       - Default Db or MySQL db ?
       - 1 Bayes Db per server or 1 Bayes on Sql for all server (same 
database)

My server receive 500 000/ 750 000 mails /days

thanks bye

Re: Best Choice for Bayes filtering on SpamAssassin

[JamesDR <ro...@bellsouth.net>]

Noc Phibee wrote:
> Hi
> 
> i have 6 servers running on spamassassin 3.1.7 (now after a upgrades).
> Actually, all have Bayes Filering with local Db (default db, not sql)
> 
> I want know what is the best choice ? :
>       - Default Db or MySQL db ?
>       - 1 Bayes Db per server or 1 Bayes on Sql for all server (same 
> database)
> 
> My server receive 500 000/ 750 000 mails /days
> 
> thanks bye
> 

MySQL DB, make sure you expire manually. Master/Slave config depends on 
how you learn, I learn on one machine, so that machine is the master and 
does the expiration while the others simply just 'look' at the data. I 
don't receive quite the load you do, but my boxes are quite undersized 
(anyone say P2? :-D ) I'm not sure if you are using AWL or user_prefs, 
but these are also in the same configuration. AWL connects to the master 
only however.

I saw a marked in bayes performance when I changed from DB to MySQL. If 
all your servers are local to themselves, then master/slave config is 
the easiest to accomplish and as far as upgrades go, if all your boxes 
are the same (hardware wise) when you get one setup and tuned you'd 
simply image over the the other 4/5 in the chain. (Of course there are 
the box independent configs -- name ip etc. But I'm sure with that 
volume of mail, you have a system to keep all servers the 'same')
-- 
Thanks,
JamesDR