April 12, 2024 at 12:37 pm
We have a Windows Server 2022 Failover Cluster with 3 nodes SQL Server 2022 AlwaysOn . Two nodes (Node A and Node B) are in Site 1 and the third node (Node C)is in Site 2.
We also have a File Share Witness server (FSW1) that is also in Site 1.
Node A - is the Primary (Site 1) - synchronous commit
Node B - is the Secondary (Site 1) - synchronous commit
Node C - is the remote secondary (Site 2)used for disaster recovery and is asynchronous commit
FSW1 - is the file share witness server (Site 1)
When we validate the cluster is says we can only sustain a 1 node simultaneous lost otherwise the cluster will down I am confused why this be as I thought as long as you have 50% votes available the cluster would remain.
I my testing if I pull the Nic on Node A or B (not at the same the time) the cluster stay healthy SQL fails over to the other node
If I pull the Nic on Node A and Node B at the same time the cluster goes down despite the File share witness and Node C being available.
Could someone tell me what I am doing wrong I have the Quorum configuration set to Select the Quorum witness and then configure the file share so the 3 nodes and the witness share should have a vote each.
Kind Regards
Paul
April 12, 2024 at 12:44 pm
I have collected the logs from the last 30mins on the cluster during my testing and have attached
April 12, 2024 at 12:44 pm
I have collected the logs from the last 30 mins on the cluster during my testing and have attached
April 12, 2024 at 7:54 pm
For the cluster to be healthy - you need more than 50% quorum votes. With 3 nodes and a witness you have a total of 4 votes - so you need more than 2 votes for a healthy cluster.
That means you can only have a single node down at any given time.
If you modify the node weight on the DR secondary to 0 (removing it from quorum consideration) - you would then have 3 votes and could now have both the DR and one of the servers in the primary site down at the same time.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 15, 2024 at 7:26 am
Hi Jeffrey
Thank you for coming back to me, so can I add another share witness to the Quorum so it will that then give me 5 votes? so I could loose nodes A and B site 1 and be able to failover to Node C in the second site
Kind Regards
Paul
April 15, 2024 at 5:43 pm
This was removed by the editor as SPAM
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply