March 24, 2010 at 6:26 pm
Can someone explain me difference between active-active and active-passive cluster.
I was in wrong interpretation all these days thinking " if few instances running on A and few on B its active-active , and all of the instances on A then its active-passive" .I now know iam wrong.
Please explain me exact difference between these .
March 24, 2010 at 6:34 pm
Active/Active is having each node in a cluster hosting a differenet sql instance.
http://www.sqlmag.com/article/clustering/active-passive-vs-active-active-clustering.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 24, 2010 at 6:45 pm
Do you mean to say what i thought before was correct?
If i have two nodes A,B and two instances X,Y .
If X,Y are running on A ,and B is idle its a active\passive cluster? Either X and Y can be moved to B any point of time upon hardware failures in A or manual moving of Cluster Group.
If X is running on A,and Y on B its active\active cluster ?
Please explain using this scenario.
March 24, 2010 at 7:12 pm
SQL Reddy (3/24/2010)
Do you mean to say what i thought before was correct?If i have two nodes A,B and two instances X,Y .
If X,Y are running on A ,and B is idle its a active\passive cluster? Either X and Y can be moved to B any point of time upon hardware failures in A or manual moving of Cluster Group.
If X is running on A,and Y on B its active\active cluster ?
Please explain using this scenario.
That is correct in the Microsoft world.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply