Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Quarantine DB using two SF servers
  FAQ FAQ  Forum Search   Register Register  Login Login

Quarantine DB using two SF servers

 Post Reply Post Reply
Author
Simone View Drop Down
Groupie
Groupie


Joined: 06 July 2005
Status: Offline
Points: 42
Post Options Post Options   Thanks (0) Thanks(0)   Quote Simone Quote  Post ReplyReply Direct Link To This Post Topic: Quarantine DB using two SF servers
    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

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

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

LogSat Software

Spam Filter ISP
Back to Top
Rifleman View Drop Down
Groupie
Groupie


Joined: 08 August 2005
Location: United States
Status: Offline
Points: 53
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rifleman Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

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

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.262 seconds.