Home    Forums    Feature Requests    Beta Issues    SysAid Resources    Documentation    Support
Hello Guest,  Login   
        
DOWNLOAD FREE EDITION
    
     Recent Topics    Hottest Topics    Online Members    Member Listing    Advanced Search
Load balance or mirror server for SysAid  XML
Forum Index » SysAid Installation & Beyond
 
Author Message
[Post New]02/09/2009 11:05:41
    Subject: Load balance or mirror server for SysAid
[Up]
lolokong
SysAider

SysAider from release 5.6 Chile Pathfinder
Joined: 17/12/2008
Messages: 8
Offline
Hello,

Sysaid is one of the central part of my organization so we cannot afford a failure in the Sysaid server machine. I am using MS-SQL as database server and this server is installed with mirroring and failover; This means in case of server failure I have a backup to keep the database runing. My problem is I don't have the same backup for Sysaid server. I don't know what is the best way to implement a failover for SysAid.

I have two Windows 2003 servers with MS-SQL server 2005 installed. One of them has currently running the SysAid server. I think I can choose between:

1. Install SysAid in the second server with the same database configuration than the current Sysaid server, so if I lost my first server I just have to manually change my DNS setting to point to the new server. I don't know if this could lead to some issue with the database o lock issues or something else. Anyway if this could be possible will be great if when one of the server fails the other one automatically take over and configures itself as tha main server.
2. Install SysAid in the second server and configure it as a load balance server. In this way is supposed that windows server must be capable to send web request to one server and then to the other one, balancing the workload. I just know how to do this with IIS but I don't have a clue how to do this with Tomcat.

I don't know if there are another better way to achieve failover sysaid server. But as SysAid is a fundamental part in my organization I really need to be sure that SysAid will be available 99.99%

Do you have some suggestion, walkthrough or something else about this issue? Do you already have implemented Sysaid with failover?

Regards,
Patricio
Patricio Campos
[Email] [Yahoo!] [MSN]
[Post New]02/09/2009 12:38:04
    Subject: Re:Load balance or mirror server for SysAid
[Up]
Israel Lifshitz
CEO & Chief Software Architect

Joined: 27/05/2008
Messages: 61
Location: <a >Help Desk Software</a>
Offline
Hello Patricio,

This is a very interesting question. You mention two separate methods 1.failover server 2. load balancing. We have good experience in both methods when we implement failover and load balancing in our on-demand environment. I will discuss both methods separately.

1. Failover server – You can install SysAid in two servers (one “active” and one “passive”) and link them to the same database. Because SysAid have some services that run on the background like email integration and escalation rules you cannot let both servers run together. That means that the SysAid service in the “active” server is running and the SysAid service in the “passive” server is not running. In case of failure you need a script to start the service in the “passive” server and stop the service in the “active” server. The last question is how to redirect traffic to the running service. DNS setting is easy but you need to configure the DNS in case of failure. Another method is configuring IIS integration (or Apache integration) with tomcat so it will detect automatically failed server and direct traffic to the second server. Our support team can help you to configure IIS integration to do that. One problem of this method is that when IIS itself failed. If your main concern is to recover from failure and not performance I will recommend configuring a failover server.

2. Load balancing. I recommend doing that as a performance solution for very large installations. We implemented load balancing in our on-demand environments where many organizations (in all sizes) use our servers. In that implementation we have many nodes with tomcat that serving web requests. The web server has a load balancer component that distributes the web requests between the nodes. We also have other components that do some background tasks like the escalation rules and email integration. The load balancer also solves failure issues as it automatically stops sending request to a failure node. As this option is much more complex we cannot provide you with instruction on how to do that yourself and we need to do it as a special project. A simple and cost effective solution to use load balancer is to use our on-demand service. In that case your server will be pre-installed and no matter your size our cloud environment can handle it.
Help Desk Software
[WWW] [Yahoo!] aim icon [MSN] [ICQ]
Forum Index » SysAid Installation & Beyond
Go to:   
Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software
    SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Israel:+972-3-533-3675
   Skype account:ilient
   Email:helpdesk@sysaid.com
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   2002-2011 		   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   03:00 AM - 05:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software
Privacy Policy © Terms Of Use