Solved

Can a hardware load balancer (cisco CSS) start a windows service if it detects another has failed?

Posted on 2004-08-16
6
347 Views
Last Modified: 2010-04-11
Is it possible to configure cisco CSS hardware load balancer to start a windows service (SQLServer) on one machine if it detects the same service on another machine has failed?

We have MS SQL2000 installed on two machines that are being hardare load balanced and we want set them up as active/failover without installing windows clustering, so of the HLB can start windows services this should be possible.
0
Comment
Question by:rot299
  • 3
  • 3
6 Comments
 
LVL 6

Expert Comment

by:Ferrosti
ID: 11818191
Why don´t you install the "log shipping" option for the SQL servers?
Another thing is that all clients try to connect to the IP of your as active declared server. You will also have to change the IP address of the backup server then.

BTW what do you mean by hardware clustering? Which way do you achieve that?
0
 
LVL 23

Accepted Solution

by:
Tim Holman earned 500 total points
ID: 11819485
No - this isn't possible.  This isn't what load balancers do - same applies to Cisco CSS, Alteon, Radware, Top Layer etc.
However, you can do health checking and assign active priority, so if your active server has port 1433 open and is marked with a higher priority, then it will always be used, until such point that port 1433 no longer becomes available, in which case the lower priority server will be used.
Either way, you need to make sure databases are synched between the two.
0
 
LVL 23

Expert Comment

by:Tim Holman
ID: 11819495
What would be the issue running these active-active anyway ?  Surely this would be a better way to do things ?
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 6

Expert Comment

by:Ferrosti
ID: 11821284
Well, this is a really good question...

"Active - hot failover" would make sense, if no clustering is wanted.
The hardware loadbalancer as tim assumed it won´t make any sense then.
0
 
LVL 23

Expert Comment

by:Tim Holman
ID: 11828711
Is this all you need to know ?
0
 
LVL 6

Expert Comment

by:Ferrosti
ID: 11829779
Hmm, strange guy.
With your suggestion he´ll be running an active-active setup.

I won´t use load balancing at all if there is no "clustering" in the sense of better performance wanted. (In this scenario of course)
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If your business is like most, chances are you still need to maintain a fax infrastructure for your staff. It’s hard to believe that a communication technology that was thriving in the mid-80s could still be an essential part of your team’s modern I…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question