Link to home
Start Free TrialLog in
Avatar of rot299
rot299

asked on

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

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.
Avatar of Ferrosti
Ferrosti
Flag of Germany image

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?
ASKER CERTIFIED SOLUTION
Avatar of Tim Holman
Tim Holman
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
What would be the issue running these active-active anyway ?  Surely this would be a better way to do things ?
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.
Is this all you need to know ?
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)