> -----Original Message----- > From: Dave Warren [mailto:da...@hireahit.com] > Sent: 23. oktober 2013 09:51 > To: users@spamassassin.apache.org > Subject: Re: Shared bayes SQL between machines > > On 2013-10-22 07:52, Jonas Akrouh Larsen wrote: > > Mmm well I'd like to use it, but it's also the manual learning. > > > > We use a web frontend which lists quarantined messages and both users > > and myself do manual training from there (it just calls sa-learn) > > How do you distribute load among your SpamAssassin servers? Is it relatively > balanced, or do different groups of users hit different servers? > > If it's balanced, consider just autolearning on the master and forget about > autolearning on the rest. Sure, you'll get a little less data in overall, but > you'll > still get a representative flow of both spam and ham, and you can still > perform manual training against the master database from other servers. > It's pretty balanced, so actually it's a pretty good idea.
If I combine john's advice with specifying the master in sa-learn's config, and then only autolearn on 1 node everything should work I think. With 1 master taking all the writes and nodes using their local read only copy of the DB for improved performance, it should work. And it's a lot simpler than all sorts of failover mechanisms, master-master replication and whatnot Thanks list :) 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 Web: www.techbiz.dk
