Solved

Active/Passive Clustering not high availability

Posted on 2009-05-05
3
332 Views
Last Modified: 2012-05-06
I currently have an active passive cluster to support my SQL 2000 OLTP environment. In a recent test of the cluster's fail over (I simulated a server failure by unplugging the nic on the active node) the system dropped. I have 3 applications that rely on the database to function, they all failed. The cluster service died and then restarted changing over the passive node.  I had to manually restart the applications to get back up and running. I spoke Dell (they setup the cluster) and they said that clustering wont provide what I am looking for. Can I get your thoughts on this? Will an active/active cluster provide this?
0
Comment
Question by:wildwoodslots
3 Comments
 
LVL 6

Accepted Solution

by:
page1985 earned 250 total points
ID: 24306310
A failover cluster does not provide instantaneous failover.  When one node in the cluster failes, depending on your configuration, it takes from 15 seconds to a minute for the cluster to begin providing services again.

An active/active cluster would provide better failover times than an active/passive.  However, you may want to consider a load balanced cluster, as unlike a failover cluster, all nodes in a load balanced cluster respond concurrently at all times.  Meaning, if one node fails, all the others are already active and respinding anyway, so the failed node gets evicted until it comes back online.
0
 
LVL 15

Assisted Solution

by:markpalinux
markpalinux earned 250 total points
ID: 24306517

An Active/Active cluster for SQL 2000, means that databases and a sql instance is live on both nodes. However that is very difficult if your users read and write to the databases.  Also it increases the licensing fee from MS, as it doubles the number of Active nodes.


Your cluster should be setup like:
node 1 - node 1 ip address, node 1 network name
node 2 - node 2 ip address, node 2 network name
sql1 - SQL instance - with its own ip address., SQL instance network name

be sure your apps are using the SQL instance name and not the node1 or node2 names.

the sql1 sql instance name and ip address should become active on the "passive" node when a failover occurs.

In cluster admin you should be able to see which nodes are up, which node owns a group.

When I am running failover testing for a cluster I keep open a ping window with "ping -a clustername" so I can see just how many packets drop during switchover.

As far as the cluster service stopping review the event logs. sounds like this maybe a new environment for you maybe upgrade would be a good idea.

Mark

0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Numerous times I have been asked this questions that what is it that makes my machine log on so slow, there have been cases where computers took 23 minute exactly after taking password and getting to the desktop. Interesting thing was the fact th…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.

911 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

21 Experts available now in Live!

Get 1:1 Help Now