Two Cluster environment with one Passive node

Question

Two Cluster environment with one Passive node

isd83

Ten Centuries

Points: 1066
More actions
September 21, 2010 at 12:51 pm

#227155

We are planning to have two clustering environment, both will be Active/Passive which would require 4 servers. Someone in our group suggested to use the same passive node to handle both cluster environment to save money. Is this possible? We plan to use sql 2008 R2 enterprise edition.
-GW

Viewing 8 posts - 1 through 7 (of 7 total)

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

nary SSCrazy Points: 2869 More actions · Answer 1

Yes it is possible with Active/Active/Passive configuration . but you have to consider lot of factors like the Hardware configuration,Memory,disk space ,Network bandwidth so that performnace should not be impacted incase when both nodes will run on passive node .

HTH...

RichardDouglas SSCarpal Tunnel Points: 4029 More actions · Answer 2

As Nary said this is possible, remember to ensure that the drive letters of your cluster do not clash. This may be a problem if you have different teams setting up each cluster.

Hope this helps,
Rich

[p]
[/p]

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

isd83 (9/21/2010)
We are planning to have two clustering environment, both will be Active/Passive which would require 4 servers. Someone in our group suggested to use the same passive node to handle both cluster environment to save money. Is this possible? We plan to use sql 2008 R2 enterprise edition.
-GW

Basically use 3 nodes instead of 4, this will save on hardware and yes it is perfectly viable!

also there is no such term as active\active\passive. A cluster is either active\passive or active\active whether you have 2 or 8 or (in the case of Windows 2008) 16 nodes!

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

"Ya can't make an omelette without breaking just a few eggs" 😉

isd83 Ten Centuries Points: 1066 More actions · Answer 4

Thank you all for your response. In a few weeks, I will start building the two sql cluster environment with 3 nodes. Thank you again.

-GW

shaun.stuart SSCertifiable Points: 7067 More actions · Answer 5

Regarding the cost issue, you will save money on hardware, but be sure you realize that SQL licenses for passive nodes in clusters are no cost.

frank.jaquier Newbie Points: 8 More actions · Answer 6

A node can be part of two clusters? Anyone have info on how to set this up?

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 7

No. What is being mentioned is a 3 NODE CLUSTER, with ONE instance running on NODE ONE, another sql instance running on NODE TWO and the THIRD NODE being the passive node for failover of either, or both of the ACTIVE nodes.

Steve