Service Packs with Clustering

#11

Just curious, but what would you call it if you had the following:

Instance Month Node1 Node2 Node3
A Jan active passive passive
A Feb passive active passive
A Mar passive passive active
....
B Jan passive active passive
B Feb passive passive active
B Mar active passive passive
....

So, in January the 'passive' node is Node3, February the passive node is
Node1 and Mar the passive node is Node2.

Jeff

Linchi Shea wrote:

Quote:

What if you have a 2-node, 3-instance cluster? ;-)

If the instances are all configured to run on one node in their 'steady
state' and the other node is left for standby, it's active/passive. If some
instances are configured to run on one node and the other instance(s) is
configured to run on the other node, I'd just spell it out, for instance:

Active/Passive, Active/Passive, and Passive/Active corresponding to the
following:

Instance Node1 Node2
---------- --------- ---------
Instance1 active passive
Instance2 active passive
Instance3 passive active

Personally, I think this is intuitive and complete.

Linchi

"Russ Kaufmann [MVP]" wrote:

"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote in message
news:e$7wAuhMIHA.5400 (AT) TK2MSFTNGP04 (DOT) phx.gbl...

What if you have a 2-node, 3-instance cluster? ;-)

Is it Active/Passive? <G

#12

Exactly the way you have outlined already:

Jan: Active\Passive\Passive, Passive\Active\Passive
Feb: Passive\Active\Passive, Passive\Passive\Active
....

and so on. This tells you exactly that (1) you have multiple instances, and
(2) where each instance should be running in its normal steady state
configuration. Just telling somebody, you have multiple instances doesn't
convey sufficient information.

You may say that's crazy, and you would be exactly right on that. Well, if
you are willing to go through the trouble to change the normal state of
configuration of a cluster on monthly basis, you deserve the naming trouble.

Linchi

"Jeffrey Williams" wrote:

Quote:

Just curious, but what would you call it if you had the following:

Instance Month Node1 Node2 Node3
A Jan active passive passive
A Feb passive active passive
A Mar passive passive active
....
B Jan passive active passive
B Feb passive passive active
B Mar active passive passive
....

So, in January the 'passive' node is Node3, February the passive node is
Node1 and Mar the passive node is Node2.

Jeff

Linchi Shea wrote:
What if you have a 2-node, 3-instance cluster? ;-)

If the instances are all configured to run on one node in their 'steady
state' and the other node is left for standby, it's active/passive. If some
instances are configured to run on one node and the other instance(s) is
configured to run on the other node, I'd just spell it out, for instance:

Active/Passive, Active/Passive, and Passive/Active corresponding to the
following:

Instance Node1 Node2
---------- --------- ---------
Instance1 active passive
Instance2 active passive
Instance3 passive active

Personally, I think this is intuitive and complete.

Linchi

"Russ Kaufmann [MVP]" wrote:

"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote in message
news:e$7wAuhMIHA.5400 (AT) TK2MSFTNGP04 (DOT) phx.gbl...

What if you have a 2-node, 3-instance cluster? ;-)

Is it Active/Passive? <G

#13

Yes, that is exactly why just saying you have an active/active or
active/passive cluster is not sufficient. All depends on how many
instances are being hosted on the cluster and what nodes they are hosted
on at any given time.

FWIW - we have a two node single instance cluster where we will be
'active' on either host depending upon the last time we moved the
group. Generally, we only move the group when we apply server patches
and the process is:

Identify the current non-active node, apply patches and reboot.
Move the group to the newly patched server
Apply patches and reboot

Personally, I do not like moving the cluster group more than once if
possible. No reason to move the group back to the original host unless
there are issues with that node.

Jeff

Linchi Shea wrote:

Quote:

Exactly the way you have outlined already:

Jan: Active\Passive\Passive, Passive\Active\Passive
Feb: Passive\Active\Passive, Passive\Passive\Active
...

and so on. This tells you exactly that (1) you have multiple instances, and
(2) where each instance should be running in its normal steady state
configuration. Just telling somebody, you have multiple instances doesn't
convey sufficient information.

You may say that's crazy, and you would be exactly right on that. Well, if
you are willing to go through the trouble to change the normal state of
configuration of a cluster on monthly basis, you deserve the naming trouble.

Linchi

"Jeffrey Williams" wrote:

Just curious, but what would you call it if you had the following:

Instance Month Node1 Node2 Node3
A Jan active passive passive
A Feb passive active passive
A Mar passive passive active
....
B Jan passive active passive
B Feb passive passive active
B Mar active passive passive
....

So, in January the 'passive' node is Node3, February the passive node is
Node1 and Mar the passive node is Node2.

Jeff

Linchi Shea wrote:

What if you have a 2-node, 3-instance cluster? ;-)

If the instances are all configured to run on one node in their 'steady
state' and the other node is left for standby, it's active/passive. If some
instances are configured to run on one node and the other instance(s) is
configured to run on the other node, I'd just spell it out, for instance:

Active/Passive, Active/Passive, and Passive/Active corresponding to the
following:

Instance Node1 Node2
---------- --------- ---------
Instance1 active passive
Instance2 active passive
Instance3 passive active

Personally, I think this is intuitive and complete.

Linchi

"Russ Kaufmann [MVP]" wrote:

"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote in message
news:e$7wAuhMIHA.5400 (AT) TK2MSFTNGP04 (DOT) phx.gbl...

What if you have a 2-node, 3-instance cluster? ;-)

Is it Active/Passive? <G

#14

"Jeffrey Williams" <jeff.williams3188 (AT) verizon (DOT) net> wrote

Quote:

Yes, that is exactly why just saying you have an active/active or
active/passive cluster is not sufficient. All depends on how many
instances are being hosted on the cluster and what nodes they are hosted
on at any given time.

Right. But at the same time, you can't properly describe the cluster without
the terms active and passive.

--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Dec 10 - 13 in Denver
Jan 18 - 31 in Denver

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Service Packs with Clustering

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: Service Packs with Clustering - 11-30-2007 , 11:19 PM

Re: Service Packs with Clustering - 12-01-2007 , 11:55 AM

Re: Service Packs with Clustering - 12-01-2007 , 01:50 PM

Re: Service Packs with Clustering - 12-03-2007 , 07:30 AM