March 20, 2012 at 6:07 am
I have a SQL 2008 R2 Cluster name of say SQLCluster1 on NodeA with an instance name of Instance1 ie. SQLCluster1\Instance1. I also want to install another instance called Instance2 on NodeA/SQLCluster1 ie. SQLCluster1\Instance2.
Is this possible?
Thanks
Steve
March 20, 2012 at 6:15 am
March 20, 2012 at 6:30 am
I thought so too but the documentation I have read doesn't seem to allow it. Do you have a link?
March 20, 2012 at 6:51 am
Instances per computer. Scroll down and you'll see 50 instances per computer or 25 per failover cluster.
March 20, 2012 at 6:55 am
But I don't see which option on the install screen allows me to do this?
I don't want to install a new SQL Cluster name with a named instance but a new instance to an existing SQL Cluster.
Am I missing the point?
Thanks
Steve
March 20, 2012 at 7:01 am
You would install it just like you installed the first instance. Installation > New SQL Server Failover Cluster Installation.
There are prerequisites you need to meet before hand that have to do with the cluster disk resources and stuff, but installing it is no different than any other time.
instance 1
-Node A-Install New SQL Server Failover Cluster Installation
-Node B-Add Node to SQL Server Failover Cluster
sqlclust\instance1
instance 2
-Node A-Install New SQL Server Failover Cluster Installation
-Node B-Add Node to SQL Server Failover Cluster
sqlclust\instance2
March 20, 2012 at 7:07 am
That's maybe the difference - I want to use the same disks as the first instance on SQLCluster1 is using?
March 20, 2012 at 7:19 am
Gotta have a couple fresh disks for the new instance. If you install the second instance on the same disks as the first (which can be done after installation I believe) you can't do active/active and you stand the chance of losing both instances if a disk fails.
March 20, 2012 at 8:40 am
Yes that makes sense.
So you can either have a default instance OR named instance for a SQL cluster, but not both. Also, you can't use the same cluster name more than once even using a different set of disks?
March 20, 2012 at 8:41 am
You can only have one named instance per virtual name. As of SQL 2008R2 you couldn't add a second instance to an existing virtual name.
Keep in mind the various names and ip addresses involved in clustering
Node 1 Name, Node 1 IP Address
Node 2 Name, Node 2 IP Address
Cluster Virtual Name, Cluster IP Address
SQL Virtual Name 1, SQL IP Address 1 (named [only one per cluster] or default instance)
SQL Virtual Name 2, SQL IP Address 2 (named [only one per cluster] or default instance)
It seemed from a previous post that the SQL was being referenced this way [cluster virtual name]\[Instance Name], it *may work as long as the instance is on the same node as the cluster virtual name is residing on. The cluster virtual name is basically just the administration name for the cluster in the case of SQL.
CEWII
March 20, 2012 at 8:47 am
hindle.steve (3/20/2012)
I have a SQL 2008 R2 Cluster name of say SQLCluster1 on NodeA with an instance name of Instance1 ie. SQLCluster1\Instance1. I also want to install another instance called Instance2 on NodeA/SQLCluster1 ie. SQLCluster1\Instance2.Is this possible?
Thanks
Steve
No, each clustered instance requires a virtual network name that is unique in the domain and should conform to standard Windows network name standards, including number of chars and excluded chars.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2013 at 1:13 am
Can a single computer be part of multiple clusters?
February 26, 2013 at 3:47 am
Kaushal.M (2/26/2013)
Can a single computer be part of multiple clusters?
No, a computer can be a member of only one cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 5, 2013 at 11:27 am
I tried to do this (adding SQLName\Instance2 to existing SQLName\Instance1) today (SQL 2008 SP3 cluster) and confirmed it would NOT work @@
I was hoping it would work so I can consolidate multiple old SQL cluster instance names onto new clusters using DNS Alias to re-direct the SQLName part
e.g.
SQL1\I1
SQL2\I2
>> merge into >> SQLNew\I1, and SQLNew\I2 (so a 2-to-1, or N-to-1 merge)
guess the only way to have multiple named instances is a stand-alone server
SQLName\Instance1
SQLName\Instance2
SQLName\Instance3 ...
June 5, 2013 at 1:34 pm
SQL Clusters require a unique virtual name for each instance so you cannot do:
SQLName\Instance1
SQLName\Instance2
SQLName\Instance3
You must do:
SQLName1\Instance1
SQLName2\Instance2
SQLName3\Instance3
I believe this is because the virtual name/IP can only be active on a single node at a time and therefor if you have 3 instances each could be active on a different node.
CEWII
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply