SA 3.0.2 and MySQL

[Dhawal Doshy]

    [ The following text is in the "ISO-8859-1" character set. ]
    [ Your display is set for the "US-ASCII" character set.  ]
    [ Some characters may be displayed incorrectly. ]

Simon Brock wrote:
>> Actually with SA 3.0.2 using MySQL has fewer problems, according to the
>> dev list for it. It seems to rock along too.
>
>
> I have been meaning to look into this myself but I was wondering if
> MySQL could be used to store a shared Bayes DB?
>
> We have a number of MailScanner installations here set up for
> different reasons and different clients.  I was wondering if we used
> MySQL for the Bayes DB we could share learnt results between
> machines.  Anyone tried that -- with or without MySQL?
>
> Regards,
> Simon.
>

We've been using it servicewide (for multiple servers, domains and
customers) and it is working as expected.. we use blacklist / whitelists
to override any specific requests from customers (rather than having
different DBs)

The migration to MySQL was simple enough, and speed has never been as
issue. Also now I have a dedicated server doing just that (and
mailwatch) for 3 (and growing) front-end MS servers. Only once in the
last 4-5 months has the database stopped responding (the reason is yet
unknown). The db size as of now is ~450MB (including data and indexes)
and continues to grow, daily volume being in excess of 80K mails.

Check the sa-users and sa-dev lists for more information.

- dhawal

------------------------ MailScanner list ------------------------
To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
'leave mailscanner' in the body of the email.
Before posting, read the MAQ (http://www.mailscanner.biz/maq/) and
the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).

Support MailScanner development - buy the book off the website!