December 29, 2011 at 12:38 am
Hi All
I need to add a new sql instance on the existing cluster, how do i go about?
The current setup of the cluster is Active\Active
2K8 OS Enterprise and 2K8 Enterprise SQL
256GB ram and disk allocation we using mount points
It's better to fail while trying, rather than fail without trying!!!
December 29, 2011 at 1:44 am
Just run the setup and install a new clustered instance.
It's not really different from installing the first instance.
[font="Verdana"]Markus Bohse[/font]
December 29, 2011 at 2:01 am
What about a new ip address and service accounts, as currently running two nodes that are active
Thx
It's better to fail while trying, rather than fail without trying!!!
December 29, 2011 at 2:10 am
smthembu (12/29/2011)
What about a new ip address and service accounts, as currently running two nodes that are activeThx
Of course each new instance needs to have it's own cluster resource group, including IP-adress and shared disk. If you want to use another service account or the same as for the existing instance depends on your internal policy. I've seen companies there they use one account for all instances andothers have a different account for each instance.
What I meant to say in my first post is basically you have to follow the same steps as when you installed the first instance except for the fact that you have a diferent name and cluster group.
[font="Verdana"]Markus Bohse[/font]
December 29, 2011 at 2:13 am
Thanks
It's better to fail while trying, rather than fail without trying!!!
December 30, 2011 at 1:09 pm
Complete the requirements for clustered instance and install it as you installed the first instance
January 2, 2012 at 1:46 am
New instance needs
* Dedicated IP address or SQL
* Dedicated ip address for msdtc
* Dedicated Virtual Name for SQL instance
* Dedicated Shared disks for Data and root directories
* Dedicated shared disk for msdtc
Regards,
Raj
January 3, 2012 at 2:49 am
arr.nagaraj (1/2/2012)
New instance needs* Dedicated IP address or SQL
* Dedicated ip address for msdtc
* Dedicated Virtual Name for SQL instance
* Dedicated Shared disks for Data and root directories
* Dedicated shared disk for msdtc
and preferable a new cluster group for controlled failover. This can be done in the installation wizard but I prefer to prepare in advance.
As far as I'm aware, you dont "need" another msdtc for the instance either but you can add one.
January 3, 2012 at 2:54 am
Yes. 'Preferably' additional msdtc and cluster group.
Regards,
Raj
January 5, 2012 at 6:22 am
Thanks All for assistance
It's better to fail while trying, rather than fail without trying!!!
September 25, 2013 at 3:20 pm
MarkusB (12/29/2011)
Just run the setup and install a new clustered instance.It's not really different from installing the first instance.
Hi MarkusB,
My question pertains to SQL Server 2012, but I haven't received a single reply to my post in the 2012 forum, so I figured I'd ask you in this thread since you appear to have experience with adding more than one instance to a SQL cluster.
I have a Windows Failover Cluster setup across 3 nodes with only 1 service/application running on it - which is SQL Server 2012. Everything works great, however now I need to add another SQL instance for an entirely different project. I have added an additional iSCSI volume to the failover cluster and it shows up just fine. At this point, how to I add an additional instance of SQL 2012 to this cluster using the new storage disk?
I assume I'd just pop the SQL Server 2012 disc in one of the nodes and install a new SQL Server Cluster instance and then go around to the rest of the nodes and just use the 'add node' option, but I just wanted to verify first. I attempted to do this and got cold feet when it came to the part about installing the setup and support files. The reason I got cold feet was because we have a group of people using the existing SQL 2012 instance and I didn't want to disrupt anything.
Any help would be much appreciated. Thanks!
September 26, 2013 at 8:37 am
I assume I'd just pop the SQL Server 2012 disc in one of the nodes and install a new SQL Server Cluster instance and then go around to the rest of the nodes and just use the 'add node' option, but I just wanted to verify first.
That's exactly how you do it.
Because you now have two instances and may want to run them on separate nodes, you should adjust the preferred owner list in cluster manager. Also remember to adjust the max memory settings, in case you have to run both instances on one node.
[font="Verdana"]Markus Bohse[/font]
September 26, 2013 at 9:46 am
Ok great. So just put the disc in one of the nodes and select "New SQL Server failover cluster installation" and then just run through the entire install and it won't affect the current SQL Cluster instance at all?
Thanks so much!
September 27, 2013 at 3:44 am
arr.nagaraj (1/3/2012)
Yes. 'Preferably' additional msdtc and cluster group.
do we require seperate quorum ?
September 27, 2013 at 6:18 am
No, only 1 quorum per cluster.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply