Am 11.11.2006 um 10:48 schrieb Matthias Leisi:
I already took a look at using SQL, but this quote:
| NB: This should be considered BETA, and the interface, schema, or
| overall operation of SQL support may change at any time with future
| releases of SA.
stops me from using it. Unfortunately, I can not run software
officially
considered Beta on this system.
I suppose you could use something like NFS so that all systems share
the same DB, config files, etc.
Use a SQL server backend. If you must have a no-failure option for
the
bayes DB, use a cluster of SQL servers.
Example with mysql:
http://www.howtoforge.com/loadbalanced_mysql_cluster_debian
I suppose that every message passed through SpamAssassin will issue at
least on query and one update statement to the DB. How does a MySQL
cluster perform with 500'000 messages per day, considering that
replication must also take place?
How long is a piece of string? 500,000 queries per day shouldn't
cause any problems for an RDBMS but the architecture of such a system
should be given a bit of consideration - connection pooling et al.
There is in fact a mail system that uses PostgreSQL to store all the
mails. If you want more information on requirements, speed, etc. I'm
pretty sure you could run Spamassassin on the top of it.
What is the "best practice" in that
regard with Spamassassin?
Using SQL is by far the best practice here.
I do not see many mentions of the SQL approach - either because it is
not used much or because it works so well?
Probably the former. And you're right not to use something like the
SQL backend for a large volume production system. Not because it's
unreliable but because it's still in development and keeping the
schema up to date could become a real headache.
I suspect that at some point it might make sense to use something
like SQLite for persistence (because it's relatively easy to
distribute) which would make using alternative backends relatively easy.
Charlie
--
Charlie Clark
Helmholtzstr. 20
Düsseldorf
D- 40215
Tel: +49-211-938-5360
GSM: +49-178-782-6226
