Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - 2 spamfilter servers one database
  FAQ FAQ  Forum Search   Register Register  Login Login

2 spamfilter servers one database

 Post Reply Post Reply
Author
AJ View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote AJ Quote  Post ReplyReply Direct Link To This Post Topic: 2 spamfilter servers one database
    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

 

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
bpogue99 View Drop Down
Groupie
Groupie


Joined: 26 January 2005
Status: Offline
Points: 59
Post Options Post Options   Thanks (0) Thanks(0)   Quote bpogue99 Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post 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.

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.063 seconds.