SpamAssassin AWL SQL redundancy

[Mark Hennessy <mh...@cloud9.net>]

Is there a way to have SpamAssassin read/write AWL records through more
than one MySQL DB connection at a time?  Also, if one of those DBs stops
responding, is there a way to have SpamAssassin only read from/write to
the MySQL DB connection that is still available?  I have found that MySQL
circular replication doesn't appear to be a good option for this.

Please advise.

--
 Mark Hennessy

Re: SpamAssassin AWL SQL redundancy

[Michael Parker <pa...@pobox.com>]

On Wed, Nov 03, 2004 at 09:50:07AM -0500, Mark Hennessy wrote:
> Is there a way to have SpamAssassin read/write AWL records through more
> than one MySQL DB connection at a time?  Also, if one of those DBs stops
> responding, is there a way to have SpamAssassin only read from/write to
> the MySQL DB connection that is still available?  I have found that MySQL
> circular replication doesn't appear to be a good option for this.

Sounds like you're talking about some sort of High Availability
solution?  Nothing like that built into SA, there are ways in which
you could achieve such a thing.  There is an open bug on this:
http://bugzilla.spamassassin.org/show_bug.cgi?id=2197

also:
http://bugzilla.spamassassin.org/show_bug.cgi?id=2037

Of course, perhaps you mean something else....

Michael

-- 
ApacheCon November 13-17 2004 http://www.apachecon.com/
See three SpamAssassin sessions & more