Join Log in
Score:0
avatar Server

Proper quorum configuration with a 3-node Windows cluster where only 2 nodes can take ownership

se flag
Sam Storie

We operate a 3 node Windows cluster to add HA capability to SQL Server. In this cluster 1 of the 3 nodes is a "reporting" server and is configured to never take ownership of the cluster. At the moment we have one node (node1) and the file share witness in one data center, and the other node (node2) and reporting node (node3) in a second data center. Here's some sanitized pics of our config:

enter image description here

Here's the node view showing how the voting is configured:

enter image description here

Here is the properties showing that only 2 of the 3 nodes can actually take ownership:

enter image description here

I'm trying to confirm, or just better understand, how to prevent the loss of a data center from taking the cluster down to a lost quorum.

Today we suffered an outage because the second data center went offline, which makes sense because we just had node1 available, and it didn't have enough votes to meet quorum. We've added a file share witness in the same data center as node1, with the thought being it could add the second vote required should node2 and node3 disappear. The more I read though I'm not convinced that's the right understanding.

Has anyone run into a configuration like this and figured out how to protect against losing 2 nodes of a 3 node cluster?

20
0 + 0
ธงชาติไทย
Elon Musk
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.