Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Add third node sql cluster Expand / Collapse
Author
Message
Posted Thursday, November 7, 2013 4:50 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:10 AM
Points: 1,155, Visits: 4,624
I have a 2 node cluster (2-physical servers) “instance1” is passive for “instance2” & “instance2” is passive for "instance1" vice versa.

I want to add/install 3rd SQL “instance3”. No test server to test, I hope it’s just an --> Add node to a SQL server fail-over cluster. Any suggestion or prerequisites.

SQL and Windows = 2008 R2

Thanks for your help.


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1512197
Posted Thursday, November 7, 2013 8:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 6,182, Visits: 13,329
muthukkumaran Kaliyamoorthy (11/7/2013)
I have a 2 node cluster (2-physical servers) “instance1” is passive for “instance2” & “instance2” is passive for "instance1" vice versa.

I want to add/install 3rd SQL “instance3”. No test server to test, I hope it’s just an --> Add node to a SQL server fail-over cluster. Any suggestion or prerequisites.

SQL and Windows = 2008 R2

Thanks for your help.

You'll need to present shared storage to the nodes for the new instance and set the new disks up as cluster resources, once done you can run the wizard on one node and create a new failover clustered instance, then run the add node wizard on the remaining node.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1512306
Posted Thursday, November 7, 2013 9:49 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:10 AM
Points: 1,155, Visits: 4,624
Perry Whittle (11/7/2013)
muthukkumaran Kaliyamoorthy (11/7/2013)
I have a 2 node cluster (2-physical servers) “instance1” is passive for “instance2” & “instance2” is passive for "instance1" vice versa.

I want to add/install 3rd SQL “instance3”. No test server to test, I hope it’s just an --> Add node to a SQL server fail-over cluster. Any suggestion or prerequisites.

SQL and Windows = 2008 R2

Thanks for your help.

You'll need to present shared storage to the nodes for the new instance and set the new disks up as cluster resources, once done you can run the wizard on one node and create a new failover clustered instance, then run the add node wizard on the remaining node.


Thanks Perry Whittle. I understand that, i need to run the wizard on passive node/server or do i need one more server for the third instance. and also is there any downtime for the existing cluster resource/server.


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1512524
Posted Friday, November 8, 2013 12:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:10 AM
Points: 1,155, Visits: 4,624
I did some online searching. Here is the step I have to perform. Am I missing anything.

> Need a Shared disk
> Need a Third server/node
> create a new failover windows cluster on node3
> Install new SQL server failover cluster
> Add node3 to other nodes 1&2



Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1512549
Posted Friday, November 8, 2013 4:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 6,182, Visits: 13,329
muthukkumaran Kaliyamoorthy (11/7/2013)
Thanks Perry Whittle. I understand that, i need to run the wizard on passive node/server or do i need one more server for the third instance.

No, you dont need a 3rd node.



muthukkumaran Kaliyamoorthy (11/7/2013)
and also is there any downtime for the existing cluster resource/server.

Not when insalling a new instance. Unless of course you want to install on a node where an existing instance is running and there are pending reboots, an outage would be required then to reboot the server before commencing installation.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1512598
Posted Friday, November 8, 2013 4:33 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 6,182, Visits: 13,329
muthukkumaran Kaliyamoorthy (11/8/2013)
I did some online searching. Here is the step I have to perform. Am I missing anything.

> Need a Shared disk
> Need a Third server/node
> create a new failover windows cluster on node3
> Install new SQL server failover cluster
> Add node3 to other nodes 1&2


No, that is incorrect. You can stay with 2 nodes and just install a 3rd instance. First thing you need is shared disks for the new instance, these must be attached to the nodes and configured as cluster resources.
Once done, you may then move the new storage to the node wheer you want to start the install, use the option to create new failover cluster instance. Once installed, use the add node wizard on the remaining node


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1512599
Posted Friday, November 8, 2013 5:54 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:10 AM
Points: 1,155, Visits: 4,624
Thank you. Here is the steps:


> Need a Shared disk should be present in the nodes and must be a cluster resource.

http://blogs.technet.com/b/askcore/archive/2009/01/14/adding-a-new-disk-to-an-existing-windows-2008-cluster.aspx?Redirected=true

> Use “Install new SQL server failover cluster installation” from SQL setup.exe in one of the nodes where the new drive is active/ available.

> Use “Add node to the SQL server failover cluster” to add other nodes from SQL setup.exe.


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1512634
Posted Friday, November 8, 2013 11:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 6,182, Visits: 13,329
That is correct

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1512777
Posted Saturday, November 9, 2013 2:43 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:10 AM
Points: 1,155, Visits: 4,624
Thanks Perry Whittle. It helps me.

Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1512893
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse