SQL Cluster - Multi Instance

  • 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

  • yes

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • I thought so too but the documentation I have read doesn't seem to allow it. Do you have a link?

  • Instances per computer. Scroll down and you'll see 50 instances per computer or 25 per failover cluster.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • 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

  • 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

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • That's maybe the difference - I want to use the same disks as the first instance on SQLCluster1 is using?

  • 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.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • 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?

  • 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

  • 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" 😉

  • Can a single computer be part of multiple clusters?

  • 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" 😉

  • 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 ...

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005
  • 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