Patching a 2 node cluster

Question

Patching a 2 node cluster

tmmutsetse

Hall of Fame

Points: 3669
More actions
April 5, 2018 at 12:17 pm

#336958

Good day,
I have a two node cluster A and B running on Windows 2012 R2 OS. Node A is the host,i want to patch Node B first ,please guide me on how to take Node B offline from the cluster for patching.I have been reading but all i am getting is not clear with patching the second Node B first.
Sorry,its my first time patching a cluster.
Many thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Michael L John One Orange Chip Points: 27055 More actions · Answer 1

tmmutsetse - Thursday, April 5, 2018 12:17 PM
Good day,
I have a two node cluster A and B running on Windows 2012 R2 OS. Node A is the host,i want to patch Node B first ,please guide me on how to take Node B offline from the cluster for patching.I have been reading but all i am getting is not clear with patching the second Node B first.
Sorry,its my first time patching a cluster.
Many thanks

When you say "node A is the host", do you actually mean that Node A is the active node on the cluster?
Is the cluster configured as an active / passive cluster?
Or active / active?
Here is a Microsoft article:
https://blogs.msdn.microsoft.com/john_daskalakis/2014/09/05/how-to-install-a-service-pack-at-a-sql-server-2012-failover-instance-best-practices/

Essentially, using Failover Cluster Manager, fail all resources over to one node. In your case, Node A.
Patch Node B
Re-boot Node B
Failover all resources to Node B
Test, Test, and test again.
If everything tests OK, patch Node A
Fail over all resources to Node A
Test, Test, and test again.
If everything tests OK, go have some fun.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

tmmutsetse Hall of Fame Points: 3669 More actions · Answer 2

I am new in this Organization and no one to give me full info,all i can see is all the nodes are up but the host is A. Is this Active/active?

I am new to clustering

thanks

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 3

tmmutsetse - Thursday, April 5, 2018 12:17 PM
Good day,
I have a two node cluster A and B running on Windows 2012 R2 OS. Node A is the host,i want to patch Node B first ,please guide me on how to take Node B offline from the cluster for patching.I have been reading but all i am getting is not clear with patching the second Node B first.
Sorry,its my first time patching a cluster.
Many thanks

Check the failover cluster manager. You can see all the resources and respective owner nodes. If you see Node A & B as owner nodes moves those resources to Node A and then Patch the Node B, Reboot , Failover all resources to Node B and Patch Node A. No need to make anything offline