SQL2008R2 on Window2008R2Sp1 Active Active clustering

Hi,

We already have Windows 2008R2Sp1 with SQL2008R2 on Active Passive cluster.

Any easy way to convert that to Active Active?  
Or should we install new Nodes and Setup new cluster then just move data over.

Anyone has any literature on SQL Active Active step by step instructions on blog or something would be great.    

Thanks
itmtiAsked:
Who is Participating?
 
Ryan McCauleyData and Analytics ManagerCommented:
there's some general confusion around what active/active means - it's not the same as load balancing, which I think is what you're asking about. Active/Active just indicates that you're running active resources on multiple cluster nodes, where active/passive means that all your active resources are running on a single cluster node.

A single-instance cluster is active/passive by nature, since you only have one resource to run, so it can only run on a single node at any given time. If you add a second clustered sql server instance, you can run it on the other node (active/active) or the same node as the first instance (active/passive). This isn't a setting you change somewhere to set it - it just indicates where you're running your resources, and can change at any time when you move a resource.

I wrote an EE article about cluster terminology that attempts to clear up the active/active vs. active/passive confusion, but it's still in editor approval - in the meantime, I have a blog post that covers much of the same material and might be worth taking a look:

http://trycatchfinally.net/2012/09/clearing-up-windows-cluster-terminology/
0
 
Ayman BakrSenior ConsultantCommented:
Although this is related to 2003, I don't think there should be much difference:

http://www.sql-server-performance.com/forum/threads/active-passive-cluster-to-active-active-cluster.17534/
0
 
itmtiAuthor Commented:
Thank for explanation.
0
 
Ryan McCauleyData and Analytics ManagerCommented:
Not sure if there's still anything to clear up, but my EE article about clustering was published, if you're interested:

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/A_11134-Shedding-some-light-on-Windows-clustering-terminology.html
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.

All Courses

From novice to tech pro — start learning today.