Solved

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

Posted on 2004-08-16
6
341 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
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.
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…

929 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now