Spam Filter ISP Forums : 2 spamfilter servers one database https://www.logsat.com/spamfilter/forums/ Fri, 06 Mar 2026 15:58:18 +0000 Sat, 08 May 2004 17:35:00 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=3556 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[2 spamfilter servers one database : Unless the SQL server is really...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=3556&PID=3571&title=2-spamfilter-servers-one-database#3571 Author: LogSat
Subject: 3556
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

]]> Sat, 08 May 2004 17:35:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=3556&PID=3571&title=2-spamfilter-servers-one-database#3571 <![CDATA[2 spamfilter servers one database : Well ... I have 9 instances of...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=3556&PID=3568&title=2-spamfilter-servers-one-database#3568 Author: Desperado
Subject: 3556
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.

]]> Fri, 07 May 2004 17:05:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=3556&PID=3568&title=2-spamfilter-servers-one-database#3568 <![CDATA[2 spamfilter servers one database : As Roberto said, yes, it can be...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=3556&PID=3562&title=2-spamfilter-servers-one-database#3562 Author: bpogue99
Subject: 3556
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

]]> Fri, 07 May 2004 09:55:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=3556&PID=3562&title=2-spamfilter-servers-one-database#3562 <![CDATA[2 spamfilter servers one database : AJ, Yes, it can be done, SpamFilter...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=3556&PID=3558&title=2-spamfilter-servers-one-database#3558 Author: LogSat
Subject: 3556
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

]]> Thu, 06 May 2004 23:46:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=3556&PID=3558&title=2-spamfilter-servers-one-database#3558 <![CDATA[2 spamfilter servers one database : Anyone running spamfilter serviceon...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=3556&PID=3556&title=2-spamfilter-servers-one-database#3556 Author: Guests
Subject: 3556
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

 

]]> Thu, 06 May 2004 22:17:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=3556&PID=3556&title=2-spamfilter-servers-one-database#3556