Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2004-08-16
6
Medium Priority
?
375 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 1500 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
Turn your laptop into a mobile console!

The CV211 Laptop USB Console Adapter provides a direct Laptop-to-Computer connection for fast and easy remote desktop access with no software to install.

 
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
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…
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…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

722 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