Solved

Active/Passive Clustering not high availability

Posted on 2009-05-05
3
331 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Organizations create, modify, and maintain huge amounts of data to help their businesses earn money and generally function.  Typically every network user within an organization has a bit of disk space to store in process items and personal files.   …
Learn about cloud computing and its benefits for small business owners.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

744 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