RE: Shared bayes SQL between machines

2013-10-23 Thread Jonas Akrouh Larsen
> -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 l

Re: Shared bayes SQL between machines

2013-10-23 Thread Dave Warren
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 SpamAss

Re: Shared bayes SQL between machines

2013-10-22 Thread Axb
On 10/22/2013 05:21 PM, Jonas Akrouh Larsen wrote: Interesting, my problem is timeouts as well, when the master sql server is down, the other nodes slow down because they are waiting for bayes to timeout, meaning they build of a mail queue because they can't keep up (or well they become a lot slo

RE: Shared bayes SQL between machines

2013-10-22 Thread Jonas Akrouh Larsen
> On 10/22/2013 04:40 PM, Jonas Akrouh Larsen wrote: > >> as if Bayes would be mission critical. .-) I have 47 spamd boxes > >> connecting to one Redis box and a slave as spare. > >> > > > > Did you test what happens when u shutdown the master/main redis box? > > Does it just automatically failover

RE: Shared bayes SQL between machines

2013-10-22 Thread John Hardin
get on the master database. It's the distributed autolearn that's problematic. -Original Message- From: John Hardin [mailto:jhar...@impsec.org] Sent: 22. oktober 2013 16:50 To: SpamAssassin Users List Subject: RE: Shared bayes SQL between machines On Tue, 22 Oct 2013, Jonas

RE: Shared bayes SQL between machines

2013-10-22 Thread Jonas Akrouh Larsen
4, 2. sal 2300 København S   Office: 7020 0979 Direct: 3336 9974 Mobile: 5120 1096 Web: www.techbiz.dk > -Original Message- > From: John Hardin [mailto:jhar...@impsec.org] > Sent: 22. oktober 2013 16:50 > To: SpamAssassin Users List > Subject: RE: Shared bayes SQL between mac

RE: Shared bayes SQL between machines

2013-10-22 Thread John Hardin
On Tue, 22 Oct 2013, Jonas Akrouh Larsen wrote: Use standard master-slave replication. Learn and expire only the master database. I *think* we support separate credentials for learning to a different database than you scan from, but I don't follow the Bayes SQL interface too closely so I'm not

Re: Shared bayes SQL between machines

2013-10-22 Thread John Hardin
On Tue, 22 Oct 2013, Jonas Akrouh Larsen wrote: I tried a couple of years ago to have my bayes DB stored in SQL replicate as MASTER-MASTER between 2 servers. It worked fine for starters, but it often broke down because of irregularities, something about duplicate data/keys if I recall correct

Re: Shared bayes SQL between machines

2013-10-22 Thread Axb
On 10/22/2013 04:07 PM, Jonas Akrouh Larsen wrote: Hi List I tried a couple of years ago to have my bayes DB stored in SQL replicate as MASTER-MASTER between 2 servers. It worked fine for starters, but it often broke down because of irregularities, something about duplicate data/keys if I rec