December 14, 2010 at 8:40 am
I currently have an active/passive SQL2k8 cluster running on virtual W2k8 Enterprise servers. I'm considering adding another instance of SQL so that I have an active/active configuration. (I figure it's more efficient to have this configuration than 2 active/passive configurations.)
I currently have 4 volumes on my (iSCSI)SANs: one each for system databases, applications databases, Quorum & MS DTC.
Is this as simple as running the Integrated Installation on the passive node to add another instance of SQL & then adding the corresponding failover node to the other node?
Do I need separate volumes for my system databases sets, the quorum and MS DTC? I've already planned to create a new volume for my other application databases.
Do I need to create another cluster in Failover Clustering before installing the new instance of SQL? Seems that I would so that I would create the IP address of the new cluster. Are there any special considerations to take in this area?
Any advice on setting up an active/active environment will be appreciated.
December 14, 2010 at 8:50 am
I think you may find that if you go active/active then your licensing will be twice as expensive, since you'll be running on twice the number of processors.
You will need new volumes for your data/log/system/tempdb files, but since the quorum and MSDTC are cluster resources, you don't need to create them again. You don't need to create a new cluster: your new SQL Server instance will be given its own new resource group on the existing cluster when you do the installation.
John
December 14, 2010 at 2:51 pm
As you are using Windows 2008 you have multiple clustered MSDTC applications, one for each clustered instance of SQL server is possible!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2010 at 2:56 pm
Plan your resources ahead of time (e.g. max memory for sql server).
You will need to have new volumes with different drive letters than the volumes on the first cluster in your set. You will also need to have a new cluster name, dns names, and the ability to add it to AD.
In essence, the same resources for another active/passive cluster - but with different drive letters.
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
December 15, 2010 at 6:38 am
Thanks everyone, this is the information I needed.
If I encounter any problems along the way, I'll post them.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply