principlesqlMinor
New Cluster Testing - Best Practice
Viewed 0 times
newpracticetestingclusterbest
Problem
We've finished setup of a 4-node SQL Server 2005 cluster. We are using Windows 2008 R2 as the underlying OS.
We are looking for suggestions on a set of tests we could perform to test failover of the SQL Instances?
We are looking for suggestions on a set of tests we could perform to test failover of the SQL Instances?
Solution
Not even close to comprehensive, but I'd start with:
Those represent the main types of failure that MS Clustering will compensate for in the first place...
I think I'd have my real/prod db detached or offline while I played these games.*
- Pull the ethernet cable(s) for your public ip interface on your primary/active node. Confirm the failover.
- Pull the SAN fibre cable(s) for your active node. Confirm the failover.
- Pull the power cable(s) for you active node. Confirm the failover.
Those represent the main types of failure that MS Clustering will compensate for in the first place...
I think I'd have my real/prod db detached or offline while I played these games.*
Context
StackExchange Database Administrators Q#21858, answer score: 5
Revisions (0)
No revisions yet.