Solved

How to simulate MSCS active - active nodes error condition

Posted on 2013-06-04
6
371 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
  • 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
Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

808 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