Hi Peter
Sory for top posting but outlook 2007... We run the exact same setup as you do, except we have more servers. My experience says thats its not a great idea top have multiple serves insert info into the bayes db on a central mysql. Our setup uses a mysql MASTER-MASTer setup, which might make it more fragile, but in any case I would stick to learning bayes on 1 server. Unless you split up which servers scans which domains, both servers should get mails from all the domains you scan, and as such it shouldnt be necessary to learn from both servers. That is my 5 cents. Med venlig hilsen / Best regards Jonas Akrouh Larsen TechBiz ApS Laplandsgade 4, 2. sal 2300 København S Office: 7020 0979 Direct: 3336 9974 Mobile: 5120 1096 Fax: 7020 0978 Web: <http://www.techbiz.dk> www.techbiz.dk From: Peter Fastré [mailto:[EMAIL PROTECTED] Sent: 25. november 2008 16:04 To: [email protected] Cc: [EMAIL PROTECTED] Subject: Clustering spamassassin + autolearning Hello guys, I'm running a small-sized hosting provider and currently our setup is following: 1 mailbox server running exim (only local delivery) 1 antispam server running exim + mailscanner + spamassassin + mailwatch -> sends all approved mail to mailbox server 2 mysql servers (master-slave) running databases for mailwatch + spamassassin (bayes) I have two questions about this, hope someone can help me. 1. Because all the load goes to the smtp server now and to add some redundancy to our setup, we would like to add another antispam server, with the same setup (which is working fine). Will this be possible (concerning spamassassin), with two nodes sharing the same bayes database on the mysql servers? Is it possible to have two nodes feeding the same bayes database? 2. On my mailbox server I'd like to have a script which goes into the mailfolders, searches for a folder with the name 'Spam', feeds the message to sa-learn (which should be feeding it to the same bayes database of course), and then delete the message. Do you think this is a well-thought approach of having my users train the spam filters this way? Maybe there are already such scripts available? Thanks in advance, Peter
