Solved

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

Posted on 2004-08-16
6
367 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
Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

 
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

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

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

PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
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…
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
Suggested Courses
Course of the Month4 days, 4 hours left to enroll

630 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