April 11, 2016 at 12:33 am
Hi Experts,
We have 2 node active \Passive cluster with 1 instance and 2 node active\active cluster with 3 instances. Can i install service pack without downtime?
When I installed service pack the disk went offline, I am doing something wrong?
April 11, 2016 at 7:34 am
No matter what you will have down time briefly for the failovers, at least once in an active/passive setup, and multiple times for active/active. If all goes well, the down time should only be the time it takes to do a failover. If the patch goes well, the disk should not go offline. If it is, make sure that you are doing the passive node each time. On active/active, you must fail over the instances on one node so all instances are on the node together, then patch the other node, fail over all instances to the patched node (after a reboot natch), then patch the other node, then rebalance. If it goes correctly your outages should just be the failover times.
April 11, 2016 at 10:59 pm
jeff.mason (4/11/2016)
No matter what you will have down time briefly for the failovers, at least once in an active/passive setup, and multiple times for active/active. If all goes well, the down time should only be the time it takes to do a failover. If the patch goes well, the disk should not go offline. If it is, make sure that you are doing the passive node each time. On active/active, you must fail over the instances on one node so all instances are on the node together, then patch the other node, fail over all instances to the patched node (after a reboot natch), then patch the other node, then rebalance. If it goes correctly your outages should just be the failover times.
Thanks a lot Jeff.
For SQL Server CU and SP do we need to install in both nodes? Installing it on one node is fine right.
April 12, 2016 at 6:29 am
Eventually you must install it on both nodes. If you don't, what happens when you have an outage and you fail back to the unpatched node? You can have a short delay between patching the two nodes, but I would not let it be too long, preferably patching them the same day. Otherwise you risk unpredictable outcomes for master if you have DBs failing between cluster nodes.
April 12, 2016 at 7:16 am
VastSQL (4/11/2016)
For SQL Server CU and SP do we need to install in both nodes? Installing it on one node is fine right.
Apply the patches to all nodes that are a possible owner of the FCI
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2016 at 11:24 pm
Thanks Jeff & Perry.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply