Solved

How to simulate MSCS active - active nodes error condition

Posted on 2013-06-04
6
374 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
getting error while running below query  in sql 2 16
add stored proc on publlication 4 20
SQL question - help with insert for missing info 5 21
SQL Help 4 18
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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 date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

730 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