Solved

SQL2008R2 on Window2008R2Sp1 Active Active clustering

Posted on 2013-01-24
4
270 Views
Last Modified: 2013-01-28
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
0
Comment
Question by:itmti
  • 2
4 Comments
 
LVL 23

Expert Comment

by:Ayman Bakr
ID: 38818324
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
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 38818949
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
 

Author Closing Comment

by:itmti
ID: 38819025
Thank for explanation.
0
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 38828063
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

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Determine if SQL is installed in Server 2008 R2 4 77
Problem to search 5 41
vmdk greater than 2TB 2 55
Application Crash 2 21
To effectively work with Diskpart on a Server Core, it is necessary to write some small batch script's, because you can't execute diskpart in a remote powershell session. To get startet, place the Diskpart batch script's into a share on your loca…
Redirected folders in a windows domain can be quite useful for a number of reasons, one of them being that with redirected application data, you can give users more seamless experience when logging into different workstations.  For example, if a use…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

776 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