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

Adding a Node to a cluster SQL Server 2008 R2 Expand / Collapse
Author
Message
Posted Monday, September 9, 2013 5:08 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 27, 2014 4:55 AM
Points: 33, Visits: 112
Hi All,

Just looking for a bit of clarification on the steps i need to take to add a node to a 2-node sql server 2008 cluster.

2-node cluster with three instances (instance1 , instance2 & instance3) installed

The steps i was considering are :

1. Infrastructure team build new server and add the new node to the failover cluster at a windows level.
2. Run the Add node to the failover cluster option and select instance1
3. Apply Service Pack 2 to instance1
4. Check instance1 can failover to the new node
5. Repeat steps 2,3 & 4 for instance2 and instance3

Does that seem like a o.k plan ?

Many thanks
Post #1492730
Posted Monday, September 9, 2013 11:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 6:44 AM
Points: 3, Visits: 233
Hi,
The steps are :

1. Add Node3 to the MSCS Cluster
2. Add Node3 to the instance1 With SQL Server Installer. It is active on Node1 or Node2
3. Apply Service Pack To Node1
4. Failover Instance1 to Node1 for validation
5. Do the same for the other instances.

Best Regards
Post #1492995
Posted Wednesday, September 11, 2013 3:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 6:44 AM
Points: 3, Visits: 233
Sorry
Point 3. is Apply SP to Node3
Post #1493521
Posted Wednesday, September 11, 2013 4:21 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 2,302, Visits: 2,773
You could wait with the installation of SP untill you have added the node-installation of all three SQL instances. After the installation of all three SQL instances you can apply the SP (on the third node) to all three instances at once.
1. add server to WFSC at OS level
2. install first SQL instance on node with 'add node' installation
3. install second SQL instance on node with 'add node' installation
4. install third SQL instance on node with 'add node' installation
5. install SP on third node and apply to all three instances



** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1493553
Posted Wednesday, September 11, 2013 4:29 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:56 PM
Points: 6,365, Visits: 13,695
ft55 (9/9/2013)
The steps i was considering are :

1. Infrastructure team build new server and add the new node to the failover cluster at a windows level.
2. Run the Add node to the failover cluster option and select instance1
3. Apply Service Pack 2 to instance1
4. Check instance1 can failover to the new node
5. Repeat steps 2,3 & 4 for instance2 and instance3

Does that seem like a o.k plan ?

Many thanks

Ensure that the server OS build has the same patch level as the existing nodes.
Ensure that all storage has been presented to the new node and that the cluster validation is successful.
Either create a drop merged SQL Server installer with the correct SP or slipstream the SP and\or CU at install time when running the Add Node. See my article here for slipstreaming updates during the install.


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1493559
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse