Multiple Subnets with Windows 2008 Clusters

re: Multiple Subnets with Windows 2008 Clusters

krish — Mon, 30 Nov 2009 11:05:38 GMT

I am using MS cluster 2008. I want to get all the nodes associated for a given RG, for this I saw follow steps,

There is link

msmvps.com/.../multiple-subnets-with-windows-2008-clusters.aspx

This supports ORing of resource.

1) Get all nodes in the cluster using

ClusterOpenEnum(hCluster, CLUSTER_ENUM_NODE); as "Preferred Owners"

RG - N1 N2 N3 N4 N5 N6

2) Get handler to RG

ClusterGroupOpenEnum(hGroup, CLUSTER_GROUP_ENUM_CONTAINS);

3) then open handler to indidual resources

ClusterResourceOpenEnum(hResource, CLUSTER_RESOURCE_ENUM_NODES);

4) Now get intersection/sunset of all nodes by getting nodes for every resource,

Now I should consider nodes associated with each respource for RG as when RG switchover happens,

Q1-> Resource-group could be activated on ANY node when all it's resources can be activated on the node. Is it correct ?

R1 - N1, N2, N3

R2 - N2, N3, N4

R3 - N2, N3, N6

In this case the nodes are - N2, N3.

Q2-> Is this a possible combination for resources and nodes added as a "Possible Owners" ?

As ORing is supported as per above link and my logic may fail as offline resource may not have requied nodes as "Possible Owners" even it may have NONE as "Possible Owners".

Q3-> The nodes in item 4 is always subset of item 1?

Q4-> Could resource nodes be different from nodes got item 1?

Q5->Is my logic correct when ORing is supported? Or should I consider all resources but 'offline' one for a RG?

Q6-> We have API

DWORD WINAPI SetClusterGroupNodeList(

__in HGROUP hGroup

)

But there is no API which gives nodes for a RG like GetClusterGroupNodeList() :-)

Appreciate your thoughts and inputs.

I posted this question in social.technet.microsoft.com but no reply.

Could you answer to "kri_thi@yahoo.com"

Thanks in advance

- Krish

re: Multiple Subnets with Windows 2008 Clusters

ChrisW — Fri, 30 Jan 2009 14:23:31 GMT

In our four-node geocluster environment we have noticed the the time is dependent on arp cache refresh.

More specfically with the network switches\routers. If after a failover the arp cahe is not flushed some clients can not find the resources. Sometimes our network admins need to set a static configuration.

Granted this is with our 2003 servers since it affects network config's I'd expect you might find the same with 2008.

Howto: Have a Clustered instance of SQL Server listen on multiple virtual IP addresses

Esoteric — Wed, 31 Dec 2008 03:43:56 GMT

Recently a colleague asked me if there were any changes specific to Windows Server 2008 which allow SQL

Howto: Have a Clustered instance of sql SERVER listen on multiple virtual IP addresses

Esoteric — Tue, 30 Dec 2008 11:03:24 GMT

Recently a colleague asked me if there were any changes specific to Windows Server 2008 which allow SQL