?
Solved

Active/Passive Clustering not high availability

Posted on 2009-05-05
3
Medium Priority
?
337 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
[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 Comments
 
LVL 6

Accepted Solution

by:
page1985 earned 1000 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 1000 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

770 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