Gary W. Smith wrote:
Since 3.0.1 we have had great success with SA and MySQL. In production we have a decent MySQL server serving two separate Servers running SA which in turn are used by 4 frond end relays.
All in all I think it's a good solution if you need a central database shared between multiple instances. It does give you the chance to run queries against it as well to derive some statistical information. We use it for both Bayes and AWL.
Performance isn't bad either. Our most recent dev environment is currently on 1 box (RHEL 4, SA 3.0.2) and we have been slamming it with a fairly good load for about 3 days now and it's been working great.
Gary
-----Original Message-----
From: Steven W. Orr [mailto:[EMAIL PROTECTED] Sent: Saturday, April 23, 2005 11:38 AM
To: spamassassin-users
Subject: Question about spamassassin using MySQL
I just found out that because I use spamassassin/sendmail and spamass-milter, I have to use a sitewide bayes database. I also found
out that as an alternative I can use MySQL to be the Bayes DB. I'm a little leery of tying my sendmail functionality to MySQL. Can people tell me
what they think of this idea? I guess I'm wondering what the paramterizations
are that would make me decide to go this way (or not).
Hi,
We also use it here with 3.0.2, it is much faster to expire old entries than the db based version and we've had no problems with it to date (We've been running it via mysql for user prefs since when ever it came out, 2.4 or 2.6 and with bayes since 3.0.0)
We process about 300K emails a day on one server running spamd with 10 children and the load is quite reasonable, usually around 1.5 - 2.5 (Freebsd 4.8) with 2 MX servers running spamc (different domains supported on the 2 MX severs). We will be adding a second and possibly a third spamd server in the near future as we are at the threshold of overwhelming it.
Regards,
Rick
