Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 393
  • Last Modified:

How to simulate MSCS active - active nodes error condition

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
sunhux
Asked:
sunhux
  • 4
  • 2
4 Solutions
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
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
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<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
 
sunhuxAuthor Commented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<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
 
sunhuxAuthor Commented:
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
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now