You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@spamassassin.apache.org by Mark Hennessy <mh...@cloud9.net> on 2004/08/17 16:28:34 UTC

autowhitelist using a db in a MySQL replication ring?

Has anyone set up a spamassassin autowhitelist db using three or more MySQL
DBMS configured as a replication ring?  The main obstacle AFAIK seems to be
that a unique record ID is kept that uses auto_increment to update, and if
any member of that ring gets disconnected somehow that there would be
conflicting records generated.

--
 Mark Hennessy

Re: autowhitelist using a db in a MySQL replication ring?

Posted by Michael Parker <pa...@pobox.com>.

On Tue, Aug 17, 2004 at 10:28:34AM -0400, Mark Hennessy wrote:
> Has anyone set up a spamassassin autowhitelist db using three or more MySQL
> DBMS configured as a replication ring?  The main obstacle AFAIK seems to be
> that a unique record ID is kept that uses auto_increment to update, and if
> any member of that ring gets disconnected somehow that there would be
> conflicting records generated.

Are you talking about autowhitelist or bayes?  Autowhitelist under SQL
doesn't use an auto_increment column.

Michael