Hi Colin,
>1) Are there any recommended configuration optimisations for mysql that
people have found to help with ASSP?
One assp should run as a DB-master, the other(s) as DB-slave
('mysqlSlaveMode').
DB-master should be the one with the lower workload, because DB-slaves are
doing no DB-maintenance. The rebuild should also run on the master, to
prevent access violations.
>Would I be right in saying that as I now have mysql I only
need to run rebuildspamdb on one of the ASSP instances?
Yes, that's right. How ever there is a small issue with the shared corpus.
All file names have the trailing '--counter'. To prevent that one assp
overwrites a corpus file stored by any other, the counter should be set
diffferntly on each assp. There is currently no GUI topic to do this. I
would set one assp to a high starting 'counter' eg.: 1.000.000 - to do
this:
- stop this assp
- delete the folder assp/tmpDB/Stats (if there is one)
- open the file 'asspstats.sav' in an editor and change the number behind
the tag 'counter' to (eg) 1000000 - be carefull, change only the number
(no CR LF dot comma or anything else)
- start assp
Now both assp will generate different file names in the corpus, even if
both are getting mails with the same subject.
To make it more easy to manage both assp configurations (settings, regex
files ....), I recommend to configure the config synch feature (read the
GUI !!).
Thomas
Von: Colin <a...@lanternhosting.co.uk>
An: ASSP development mailing list <assp-test@lists.sourceforge.net>
Datum: 08.04.2012 19:45
Betreff: [Assp-test] Multiple instances and rebuildspamdb
Hi folks,
Further to my recent emails, I scrapped previous attempts and installed
the new Ubuntu 12.04 as 32bit with 32bit perl 5.14.
So, now I have two front end servers running ASSP and Exim and I have
finally managed to get round to building a separate 64bit mysql server.
Both ASSP instances connect successfully to mysql so I have a couple of
simple questions.
1) Are there any recommended configuration optimisations for mysql that
people have found to help with ASSP?
2) Both my ASSP instances save to a shared corpus using subject as
filenames. Would I be right in saying that as I now have mysql I only
need to run rebuildspamdb on one of the ASSP instances?
Thanks,
Colin.
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally
privileged and protected in law and are intended solely for the use of the
individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no
known virus in this email!
*******************************************************
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
