Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/#!/StackDBAs/status/449818158686556160
edited tags
Link
Thomas Stringer
Thomas Stringer
  • 42.4k
  • 9
  • 119
  • 155
Removed the "active/active/active" description and replaced it with "three-node three-instance"
Source Link
Eric Enger
Eric Enger
  • 103
  • 8

We are creating a three node "active/active/active"-node three-instance cluster with SQL 2008 R2 (not cutting edge, but that is what the application supports) and think it should be able to maintain quorum with two physical nodes down. What is the best way to configure this?

My manager has been pushing for a witness server that acts like an additional quorum vote on top of a node and disk majority. That gives us a vote per node, a vote for the quorum disk, but is it possible to setup a witness server that receives a vote?

I thought a witness was for mirroring, which we have no plans to implement on this cluster. I have been told that adding a fourth node is not a possbility, even if it is only a passive node.

We are creating a three node "active/active/active" cluster with SQL 2008 R2 (not cutting edge, but that is what the application supports) and think it should be able to maintain quorum with two physical nodes down. What is the best way to configure this?

My manager has been pushing for a witness server that acts like an additional quorum vote on top of a node and disk majority. That gives us a vote per node, a vote for the quorum disk, but is it possible to setup a witness server that receives a vote?

I thought a witness was for mirroring, which we have no plans to implement on this cluster. I have been told that adding a fourth node is not a possbility, even if it is only a passive node.

We are creating a three-node three-instance cluster with SQL 2008 R2 (not cutting edge, but that is what the application supports) and think it should be able to maintain quorum with two physical nodes down. What is the best way to configure this?

My manager has been pushing for a witness server that acts like an additional quorum vote on top of a node and disk majority. That gives us a vote per node, a vote for the quorum disk, but is it possible to setup a witness server that receives a vote?

I thought a witness was for mirroring, which we have no plans to implement on this cluster. I have been told that adding a fourth node is not a possbility, even if it is only a passive node.

Source Link
Eric Enger
Eric Enger
  • 103
  • 8

Three Node Cluster that Allows For Two Failures

We are creating a three node "active/active/active" cluster with SQL 2008 R2 (not cutting edge, but that is what the application supports) and think it should be able to maintain quorum with two physical nodes down. What is the best way to configure this?

My manager has been pushing for a witness server that acts like an additional quorum vote on top of a node and disk majority. That gives us a vote per node, a vote for the quorum disk, but is it possible to setup a witness server that receives a vote?

I thought a witness was for mirroring, which we have no plans to implement on this cluster. I have been told that adding a fourth node is not a possbility, even if it is only a passive node.