Solved

How to simulate MSCS active - active nodes error condition

Posted on 2013-06-04
6
378 Views
Last Modified: 2013-06-16
Hi

We suspect that we have a few incidents of both our Win 2008 x64 R2
Enterprise becoming active-active (instead of the usual active-passive)
& this caused contention for Quorum & a few cluster SAN disk resources
contention which resulted in the Quorum disk (& the cluster SAN disk)
becoming unavailable for a short while on several occasions.

How can I simulate this error condition?  We want to see if the
Event Viewer event id code matches what we got on those incidents.


We also had 2 incidents of the MSCS cluster IP (or perhaps the MS
SQL virtual IP) address being duplicated (ie both nodes contending to
grab that virtual cluster IP address)

Can we just pull out the LAN cables of both member servers?

The cluster is hosting MS SQL 2008 x64 Enterprise database
0
Comment
Question by:sunhux
[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
  • 4
  • 2
6 Comments
 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 500 total points
ID: 39221417
I would advise to simulate failure by failing over/failing back one instance at the time from one node to the next.  An Active-Active configuration is nothing but a cross node of 2 Active Passive configuration.

Hope this helps.
0
 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 500 total points
ID: 39221426
<<Can we just pull out the LAN cables of both member servers?>>
No.  You don't need to do that:simulating failure can be done through the cluster administrator.  Pulling the cable from two servers will simply bring your entire cluster down.
0
 

Author Comment

by:sunhux
ID: 39222664
I don't want to simulate cluster failure (ie shutdown the
cluster from Failover Cluster Manager ? )

What I want is to simulate a situation where both nodes
became active trying to contend / fight for the same
cluster resources
0
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 500 total points
ID: 39222760
<<What I want is to simulate a situation where both nodes
became active trying to contend / fight for the same
cluster resources>>
I want to make sure I understand your query.

When you say you want both nodes for the same resources what resources are you exactly talking about ?
0
 

Author Comment

by:sunhux
ID: 39225754
I'm referring to the Quorum disk & cluster SAN disk resources.

Will it ever be possible in Win 2008 MSCS that both nodes
become active & broadcast out the MS SQL virtual IP & 
MSCS cluster virtual IP?

I've seen firewall in HA mode becoming active-active ie both
firewalls allowing traffic to pass through.
0
 
LVL 23

Accepted Solution

by:
Racim BOUDJAKDJI earned 500 total points
ID: 39225976
<<I'm referring to the Quorum disk & cluster SAN disk resources.>>
These resources can not be shared between the two virtual instances.

<<Will it ever be possible in Win 2008 MSCS that both nodes
become active & broadcast out the MS SQL virtual IP & 
MSCS cluster virtual IP?>>
In an active active configuration, each node is supposed to broadcast a separate IP, one for each clustered instance.  What is the IP of each virtual instance ?  Can you confirm it?
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

688 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