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

Two Cluster environment with one Passive node Expand / Collapse
Author
Message
Posted Tuesday, September 21, 2010 12:51 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, September 19, 2014 5:19 PM
Points: 56, Visits: 572
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



Post #990672
Posted Tuesday, September 21, 2010 1:02 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, December 15, 2014 10:16 AM
Points: 1,667, Visits: 1,387
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...
Post #990679
Posted Wednesday, September 22, 2010 5:27 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, November 27, 2014 5:48 AM
Points: 969, Visits: 693
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



Post #991030
Posted Wednesday, September 22, 2010 9:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:55 AM
Points: 6,752, Visits: 14,397
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"
Post #991301
Posted Wednesday, September 22, 2010 10:18 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, September 19, 2014 5:19 PM
Points: 56, Visits: 572
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



Post #991339
Posted Thursday, September 23, 2010 11:04 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: 2 days ago @ 8:24 AM
Points: 1,452, Visits: 740
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.
Post #992204
Posted Wednesday, November 9, 2011 9:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 3:37 PM
Points: 2, Visits: 353
A node can be part of two clusters? Anyone have info on how to set this up?
Post #1203015
Posted Thursday, November 10, 2011 6:54 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 5:58 AM
Points: 924, Visits: 1,445
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



Post #1203497
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse