Re: two databases

2009-06-05 Thread Micah Anderson
* Michael Grant [2009-06-05 10:26-0400]: > On Fri, Jun 5, 2009 at 16:08, Micah Anderson wrote: > > Michael Grant writes: > > > >> I did not realize one could store the bayes scores in sql. > >> > >> So I'd store the bayes scores on a third server and let both mxes use > >> the same database. > >

Re: two databases

2009-06-05 Thread Rick Macdougall
Michael Grant wrote: On Fri, Jun 5, 2009 at 16:08, Micah Anderson wrote: Michael Grant writes: I did not realize one could store the bayes scores in sql. So I'd store the bayes scores on a third server and let both mxes use the same database. I did this, but my bayes in mysql and pointed t

Re: two databases

2009-06-05 Thread d . hill
Quoting Micah Anderson : any case I might have had some issues because my MySQL database needed to be optimized, but I was not able to determine how and now I just run one of the spamd's without bayes, which is not too bad because my bayes database seems to be totally worthless at the moment. :P

Re: two databases

2009-06-05 Thread Michael Grant
On Fri, Jun 5, 2009 at 16:08, Micah Anderson wrote: > Michael Grant writes: > >> I did not realize one could store the bayes scores in sql. >> >> So I'd store the bayes scores on a third server and let both mxes use >> the same database. > > I did this, but my bayes in mysql and pointed two diffe

Re: two databases

2009-06-05 Thread Micah Anderson
Michael Grant writes: > I did not realize one could store the bayes scores in sql. > > So I'd store the bayes scores on a third server and let both mxes use > the same database. I did this, but my bayes in mysql and pointed two different spamd machines at it, but I had severe problems that I cou

Re: two databases

2009-05-15 Thread Michael Grant
I did not realize one could store the bayes scores in sql. So I'd store the bayes scores on a third server and let both mxes use the same database. Two equal weighted mx records are a good idea. Michael Grant

Re: two databases

2009-05-15 Thread Michael Scheidell
yes, but he wants two servers, right? I guess I was assuming he meant sql (mysql) you can't 'replicate' the bayes from mx1 to mx2, get lots of weird issues. ps, my patches for ooo messages and vbounce rules... . -- Michael Scheidell, CTO Phone: 561-999-5000, x 1259 > *| *SECNAP Net

Re: two databases

2009-05-15 Thread Justin Mason
another alternative is to use SQL for bayes. --j. On Fri, May 15, 2009 at 11:24, Michael Scheidell wrote: > > > Michael Grant wrote: > > I run spamassassin on my mail server from milter-spam > (http://www.snertsoft.com/sendmail/milter-spamc/). One mail server is > no longer sufficient for both

Re: two databases

2009-05-15 Thread Michael Scheidell
Michael Grant wrote: I run spamassassin on my mail server from milter-spam (http://www.snertsoft.com/sendmail/milter-spamc/). One mail server is no longer sufficient for both reliability and load so I'm building 2 identical mail servers (two mx mailers). aside from the issues of trying to