Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to simulate MSCS active - active nodes error condition

Posted on 2013-06-04
6
Medium Priority
?
389 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 1500 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 1500 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 1500 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 1500 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

610 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