Print Page | Close Window

Quarantine DB using two SF servers

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5386
Printed Date: 01 November 2025 at 5:44pm


Topic: Quarantine DB using two SF servers
Posted By: Simone
Subject: Quarantine DB using two SF servers
Date Posted: 23 November 2005 at 2:46pm

I would like you to suggest me the right configuration of two SF servers (primary and backup) working with the same users and domains and redirecting to the same SMTP mailserver.

I'm considering this two options to get quarantine work correctly and SF efficiently:

1) Twice SF save the quarantine directly to the same MYSQL server installed in the primary SF server.

It would use the same db and i would have no problem in mixing DBs in the web based quarantine admin.
Do u think that it would get slowly the secondary server?

2) Every SF has his own MYSQL server in the same server of SF

It wuold increase performances of the secondary server but it wuold duplicate the quarantine DB so that i would have a double connection from the web interface to see and manage the quarantine.

3) The same as before, but with the difference that every X minutes a scheduled script cut & paste all the quarantine records of the secondary server to the primary so that the web admin could access to only one db

What do u think about it?

Do u have some other configurations to suggest?

Thank you very much!

Simone




Replies:
Posted By: LogSat
Date Posted: 24 November 2005 at 7:34am
Simone,

We developed SpamFilter so that option #1 could be used, and all your SpamFilter installs will know which entries belong to them even though they share the same database. If your database server's hardware is powerful enough to handle DB traffic for both server, that is the option we recommend, as it's the simplest to implement. SpamFilter's performance will not be affected, as long as your DB server is able to handle the load.


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP


Posted By: Rifleman
Date Posted: 30 December 2005 at 9:38am
I am getting a catastrophic failure when conecting. Is there a fail-safe way for this to be set-up?


Posted By: LogSat
Date Posted: 30 December 2005 at 9:54pm
Can you please post more details on what actions/activity is causing the "catastophic failure when connecting"? Please also indicate what you mean by "when connecting".

-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP



Print Page | Close Window