September 27, 2012 at 7:48 am
Perry Whittle (9/27/2012)
Have you worked with windows server failover clusters before, do you understand the concepts?
Yes I have and I do, sort of
We currently have 2 node clusters combined with Log Shipping
September 27, 2012 at 8:06 am
ok, so you understand that the 2 nodes participating in the failover cluster instance share the resources in the cluster group, they don't each have a G drive, they share between them. Only one node may access the resource at any one time.
Given that then your scenario below is valid
Something like this?(G Drive is the location on the data and log files)Clusternode1 - G Drive(Shared) only accessible
Clusternode2 - G Drive(Shared) on one node at a time
Clusternode3 - G Drive(Local)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2012 at 8:23 am
Perry Whittle (9/27/2012)
ok, so you understand that the 2 nodes participating in the failover cluster instance share the resources in the cluster group, they don't each have a G drive, they share between them. Only one node may access the resource at any one time.Given that then your scenario below is valid
Something like this?(G Drive is the location on the data and log files)Clusternode1 - G Drive(Shared) only accessible
Clusternode2 - G Drive(Shared) on one node at a time
Clusternode3 - G Drive(Local)
Great
That's what I meant with my post
Cluster nodes 1 & 2 will share the same G drive and Cluster Node 3 has it's own G drive
The way I understand it is that Cluster nodes 1 & 2 will become "SQLCluster1" with the database created on the G drive
And, "SQLCluster1" with be in an AG with Clusternode3
September 27, 2012 at 8:26 am
yes, correct
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2012 at 8:31 am
Perry Whittle (9/27/2012)
yes, correct
Thanks for your help
Because the 3 nodes involved in the same Cluster but only 2 of them will be partners to each other, what do you recommend as the quorum setting? Node majority or Node and Disk?
September 27, 2012 at 9:42 am
You want to try and achieve an odd number of voting nodes to help maintain quorum, with three nodes Node majority would be default.
However, take this scenario.
You have 3 nodes ClusterNode1, ClusterNode2 and ClusterNode3.
Nodes 1 and 2 are hosting an FCI and this instance is part of an AO Group with an instance on Node3.
Your quorum type is node majority.
There is a power outage on one section of the datacenter and Nodes 2 and 3 go down. Although Node 1 would theoretically still be able to service the FCI, with a loss of quorum the cluster becomes unavailable.
You can in WSFC 2008 R2 remove a nodes votes within a cluster, is that valid in this case who knows, all scenarios and requirements are different.
You could revoke the vote from Node3 and implement a disk or file share witness to act as the third vote that way if the situation above happens Node 1 can still service the FCI and only your reporting replica will be offline 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 12:00 am
Perry Whittle (9/27/2012)
You want to try and achieve an odd number of voting nodes to help maintain quorum, with three nodes Node majority would be default.However, take this scenario.
You have 3 nodes ClusterNode1, ClusterNode2 and ClusterNode3.
Nodes 1 and 2 are hosting an FCI and this instance is part of an AO Group with an instance on Node3.
Your quorum type is node majority.
There is a power outage on one section of the datacenter and Nodes 2 and 3 go down. Although Node 1 would theoretically still be able to service the FCI, with a loss of quorum the cluster becomes unavailable.
You can in WSFC 2008 R2 remove a nodes votes within a cluster, is that valid in this case who knows, all scenarios and requirements are different.
You could revoke the vote from Node3 and implement a disk or file share witness to act as the third vote that way if the situation above happens Node 1 can still service the FCI and only your reporting replica will be offline 😉
Very interesting, do you know if it's possible to remove a nodes vote in a Windows 2012 Cluster?
What would happen if Nodes 1 and 2 went down?
Thanks
September 28, 2012 at 3:55 am
SQLSACT (9/28/2012)
Very interesting, do you know if it's possible to remove a nodes vote in a Windows 2012 Cluster?
Haven't had chance to look at the 2012 OS yet, can't see why it hasn't persisted from 2008R2 to 2012
SQLSACT (9/28/2012)
What would happen if Nodes 1 and 2 went down?Thanks
A crash scenario or an admin shutdown?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 4:07 am
Perry Whittle (9/28/2012)
SQLSACT (9/28/2012)
Very interesting, do you know if it's possible to remove a nodes vote in a Windows 2012 Cluster?Haven't had chance to look at the 2012 OS yet, can't see why it hasn't persisted from 2008R2 to 2012
SQLSACT (9/28/2012)
What would happen if Nodes 1 and 2 went down?Thanks
A crash scenario or an admin shutdown?
In a crash scenario, with Node and Disk Majority setting and with Node3's vote removed.
September 28, 2012 at 4:55 am
you would have to force service on the 3rd node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 5:07 am
Perry Whittle (9/28/2012)
you would have to force service on the 3rd node
Thanks
How would I do that?
Is that the same as failing-over ?
October 1, 2012 at 8:24 am
you would need to use the forcequorum switch, have a search for this and you'll find more info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 12 posts - 16 through 26 (of 26 total)
You must be logged in to reply to this topic. Login to reply