Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Adding a new instance on a existing cluster


Adding a new instance on a existing cluster

Author
Message
dgraf
dgraf
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 31
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!
MarkusB
MarkusB
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4449 Visits: 4208

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.

Markus Bohse
dgraf
dgraf
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 31
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!
muth_51
muth_51
Mr or Mrs. 500
Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)Mr or Mrs. 500 (532 reputation)

Group: General Forum Members
Points: 532 Visits: 2862
arr.nagaraj (1/3/2012)
Yes. 'Preferably' additional msdtc and cluster group.


do we require seperate quorum ?
Steve-3_5_7_9
Steve-3_5_7_9
SSC Eights!
SSC Eights! (982 reputation)SSC Eights! (982 reputation)SSC Eights! (982 reputation)SSC Eights! (982 reputation)SSC Eights! (982 reputation)SSC Eights! (982 reputation)SSC Eights! (982 reputation)SSC Eights! (982 reputation)

Group: General Forum Members
Points: 982 Visits: 1584
No, only 1 quorum per cluster.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search