Solved

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

Posted on 2004-08-16
6
361 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
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…

734 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