You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by Bob Pierce <pi...@westmancom.com> on 2004/06/23 20:13:02 UTC
Multiple Scanning servers sharing local White list and Bayes
Does anybody know how I might set up multiple scanning servers (3 - already in production) to share central locally served auto white list and bayes rules?
IS this something that might be possible using v3.0's new MySQL functions?
Or would it even be possible to have them share the same nfs share for the rules directories?
Has anybody tried something similar to this, or is there any documentation on something like this?
Thanks for your help,
Bob Pierce.
Re: Multiple Scanning servers sharing local White list and Bayes
Posted by Mike Jackson <mj...@cmc.net>.
> I'm currently running four servers all synced to the same rules database
via
> MySQL. I'm using MySQL replication to keep the servers all in sync with
one
> another. So far, however, I'm just using the local whitelist/bayes dbs on
> these machines. I'm anxiously awaiting the release of 3.0 to add
> bayes/whitelist to my replicated SQL server.
Until recently I was adminning an array of three SA boxes, but they all
referred to a MySQL DB on a fourth box. Any particular reason why you're
using replication instead of just one master server? (I mean, other than for
redundancy, but that doesn't seem to be the motivation here.)
Mike Jackson
Re: Multiple Scanning servers sharing local White list and Bayes
Posted by Michael Parker <pa...@pobox.com>.
Warning, responding to two folks at once....
On Tue, Jun 29, 2004 at 03:15:06PM -0400, Mick Szucs wrote:
> On June 29, 2004 03:07 pm, Sylvain Robitaille wrote:
> > On Wed, 23 Jun 2004, Michael Parker wrote:
> > > Why not just setup a master server and have all your mail servers talk
> > > to it?
> >
> > Single point of failure: what happens to the mail when the database goes
> > down? If you have one database server for this type of thing, you may
> > as well have a single MX host.
>
I never said it had to be a single server, nothing wrong with talking
to a master db server with a slave in reserve as a hotbackup. If it
goes down you aren't going to lose mail, it just won't be scanned.
The current 3.0 design for Bayes SQL is a 90% design, but gives you
plenty of rope to handle the other 10% (see below).
>
> If there were a way to direct writes to the master and reads from the local
> slave copy, that would be ideal - but I think that defies the way things like
> to work.
>
> I'll be playing with 3.0 when it happens and will report back if I come up
> with anything that works.
>
Yes, it is possible, with code, perldoc Mail::SpamAssassin::BayesStore
to get the API for the storage code. Multi-Master setups are also
possible with a little code and time.
Michael
Re: Multiple Scanning servers sharing local White list and Bayes
Posted by Mick Szucs <mi...@onramp.ca>.
On June 29, 2004 03:07 pm, Sylvain Robitaille wrote:
> On Wed, 23 Jun 2004, Michael Parker wrote:
> > Why not just setup a master server and have all your mail servers talk
> > to it?
>
> Single point of failure: what happens to the mail when the database goes
> down? If you have one database server for this type of thing, you may
> as well have a single MX host.
Thanks - I started to respond with this paragraph a couple of days ago and got
swamped with work and forgot about it.
If there were a way to direct writes to the master and reads from the local
slave copy, that would be ideal - but I think that defies the way things like
to work.
I'll be playing with 3.0 when it happens and will report back if I come up
with anything that works.
Mick
Re: Multiple Scanning servers sharing local White list and Bayes
Posted by Sylvain Robitaille <sy...@alcor.concordia.ca>.
On Wed, 23 Jun 2004, Michael Parker wrote:
> Why not just setup a master server and have all your mail servers talk
> to it?
Single point of failure: what happens to the mail when the database goes
down? If you have one database server for this type of thing, you may
as well have a single MX host.
I've been contemplating implementing greylisting via a replicated
database, so that all four of my mail servers can have access to the
same dataset, and it wouldn't matter which of them a sending host
connected to, including retries. I haven't got the implementation yet
(if anyone knows that this has already been done, pointers would be
welcome), but in my setup, I don't think I can use anything like
greylisting otherwise (and I haven't been able to use Bayes, for
example).
--
----------------------------------------------------------------------
Sylvain Robitaille syl@alcor.concordia.ca
Systems analyst / Postmaster Concordia University
Instructional & Information Technology Montreal, Quebec, Canada
----------------------------------------------------------------------
Re: Multiple Scanning servers sharing local White list and Bayes
Posted by Michael Parker <pa...@pobox.com>.
On Wed, Jun 23, 2004 at 02:41:17PM -0400, Mick Szucs wrote:
> On Wednesday 23 Jun 2004 2:13 pm, Bob Pierce wrote:
> > IS this something that might be possible using v3.0's new MySQL functions?
> > Or would it even be possible to have them share the same nfs share for the
> > rules directories?
> >
> > Has anybody tried something similar to this, or is there any documentation
> > on something like this?
>
> I'm currently running four servers all synced to the same rules database via
> MySQL. I'm using MySQL replication to keep the servers all in sync with one
> another. So far, however, I'm just using the local whitelist/bayes dbs on
> these machines. I'm anxiously awaiting the release of 3.0 to add
> bayes/whitelist to my replicated SQL server.
Bayes SQL won't work well on a replicated setup. It uses an
auto_increment column for the userid. It could be made to work with
some minor code changes, but wouldn't work well out of the box.
Why not just setup a master server and have all your mail servers talk
to it?
Michael
Re: Multiple Scanning servers sharing local White list and Bayes
Posted by Mick Szucs <mi...@onramp.ca>.
On Wednesday 23 Jun 2004 2:13 pm, Bob Pierce wrote:
> IS this something that might be possible using v3.0's new MySQL functions?
> Or would it even be possible to have them share the same nfs share for the
> rules directories?
>
> Has anybody tried something similar to this, or is there any documentation
> on something like this?
I'm currently running four servers all synced to the same rules database via
MySQL. I'm using MySQL replication to keep the servers all in sync with one
another. So far, however, I'm just using the local whitelist/bayes dbs on
these machines. I'm anxiously awaiting the release of 3.0 to add
bayes/whitelist to my replicated SQL server.
I had toyed with NFS for the whitelist/bayes stuff, but found locking issues
to be a PITA, and decided I'd just be patient and wait for 3.0.
--
Mick Szucs
Onramp Network Services Inc.