Noc Phibee wrote:
Hii 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
smime.p7s
Description: S/MIME Cryptographic Signature
