Print Page | Close Window

2 spamfilter servers one database

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=3556
Printed Date: 18 October 2017 at 11:52pm


Topic: 2 spamfilter servers one database
Posted By: Guests
Subject: 2 spamfilter servers one database
Date Posted: 06 May 2004 at 10:17pm

Anyone running spamfilter service on two (or more) servers pointing to one quarantine db?  could it be done?

thanks

 




Replies:
Posted By: LogSat
Date Posted: 06 May 2004 at 11:46pm

AJ,

Yes, it can be done, SpamFilter was designed taking into consideration this setup. You will simply need to install SpamFilter on the second server, and then run the 1-2-3 step database wizard. Both SpamFilter installs will point to the same database and use the same quarantine tables. Each one knows about which emails it "owns" and will take care of deleting them / deliver them to the end users.

Roberto F.
LogSat Software



Posted By: bpogue99
Date Posted: 07 May 2004 at 9:55am

As Roberto said, yes, it can be done and it works very well, but it does generate twice the load on the database server so be prepared with that. I wonder though if using two different databases on a SQL server is any faster than two installs using the same database? If it is, it may be better to use individual databases for each install rather than the same one. Roberto, any performance testing or thoughts in that regard.

bill



Posted By: Desperado
Date Posted: 07 May 2004 at 5:05pm

Well ... I have 9 instances of SpamFilter all using the same Database.  No problems at all.

Dan S.



Posted By: LogSat
Date Posted: 08 May 2004 at 5:35pm

Unless the SQL server is really "stressed out", we'd recommend using the same database for the easier management this will allow. If using a single database, all SpamFilter instances will be able to see all of the spam in the quarantine caught by the various servers. The web interface will also be able to show all of the spam without the need to issue complex queries to combine results form the various SQL servers.

Roberto F.
LogSat Software




Print Page | Close Window