2 spamfilter servers one database |
Post Reply 
|
| Author | |
AJ 
Guest Group 
|
 Post Options
 Thanks(0)
 Quote Reply
 Topic: 2 spamfilter servers one databasePosted: 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
|
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
bpogue99
Groupie 
Joined: 26 January 2005 Status: Offline Points: 59 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
Desperado
Senior Member 
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.158 seconds.