Henrik K wrote:
On Sat, Aug 15, 2009 at 09:50:41AM +0200, Jorn Argelo wrote:
Henrik K wrote:
On Fri, Aug 14, 2009 at 07:43:37PM +0200, Jorn Argelo wrote:
Hi All,
I'm running spamassassin 3.2.5 on RHEL 5.3 x86_64. We have three
boxes, and all three of them are sharing the same bayes DB using a
MySQL cluster, version 7.0.6 (based on 5.1.34). The cluster has 2
datanodes with a quadcore and 4 GB of memory. Everything is working
fine, even the AWL in SQL, except for Bayes. The bayes database
currently houses a bit less than 500k tokens and the database size
is not very big either, as the datanodes have less than 1 GB of
storage in use. I've followed the instructions from the Spamassassin
wiki, and I also used the supplied bayes_mysql.sql file to create my
tables. In case anyone is interested, you can find the cluster.ini
and the my.cnf used on the SQL nodes here:
http://www.wcborstel.com/web/mysql/my.cnf
skip-innodb
That's pretty much the reason. You _need_ to use InnoDB as it has row level
locking. MyISAM just kills Bayes.
Actually I'm using NDB and not MyISAM. I need a clustered storage
engine, otherwise the bayes DB can't really be shared. If I create an
InnoDB table on one SQL node, it doesn't show up at the other SQL node,
while this is the case with an NDB storage engine.
Ah right sorry.. I have no idea on NDB and how it performs for SA.
What I can do however, is point all mailservers to one SQL node. I just
need to synchronize the bayes_token table to the other SQL node I guess.
Do you have an idea about this?
MySQL replication? Maybe search on spamassassin-users archives to find
experiences.
Thanks for this, I was not aware of it. Running expiry runs manually is
done by sa-learn --force-expiry, correct?
Yep.
In case anybody else comes across the same, I've kicked out the MySQL
cluster and now using MySQL with multi-master replication. There we can
use InnoDB and this definitely solved all of the problems I had with
bayes. Scantimes are now below 1 second. I don't have much load as of
yet, so I expect this to increase somewhat during business hours, but
all in all things look a lot more promising. I've used this howto:
http://capttofu.livejournal.com/1752.html
Thanks for the pointers, Henrik.
Regards,
Jorn
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4336 (20090814) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
