question

AyJay-9084 avatar image
0 Votes"
AyJay-9084 asked Yufeishao-msft commented

Quorum witness for a 3 node cluster

I have a 3 node Windows Server 2016 DataCenter Failover Cluster with a SQL Always On Availability Group (SQL Server 2019) with no shared storage.

There are two nodes in Site1 and a third node in another remote site Site2.

Is a file share witness the best option for as a quorum witness?

Does it matter which site should the file share witness be placed in?

Does the file share witness have to be Server 2016 and up?

Also, what would happen if the file share witness server was to go offline in the above setup?



sql-server-generalwindows-server-clustering
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlexBykovskyi avatar image
0 Votes"
AlexBykovskyi answered AyJay-9084 commented

Hey,

It is recommended to have file share witness to run on a separate location from the cluster workload. In this scenario cluster nodes will have connection to the Witness regardless site-to-site network communication.
https://docs.microsoft.com/en-us/windows-server/failover-clustering/manage-cluster-quorum

As an alternative, you can deploy StarWind VSAN HA LUN to run as a witness disk between your sites. Might help:
https://www.google.com/search?client=firefox-b-d&q=stariwnd+2+node+hyper-v


Cheers,

Alex Bykovskyi

StarWind Software

Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Alex,

Thanks for the information.

If I do not have a separate third site/data centre location to have a file share witness or the option to use the StarWind solution, could I create a file share witness on both Site1 and Site2?

0 Votes 0 ·
Yufeishao-msft avatar image
0 Votes"
Yufeishao-msft answered Yufeishao-msft commented

Hi @AlexJohn-9084,

Is a file share witness the best option for as a quorum witness?

A file share witness is recommended when you need to consider multisite disaster recovery with replicated storage. Configuring a disk witness with replicated storage is possible only if the storage vendor supports read-write access from all sites to the replicated storage

Does the file share witness have to be Server 2016 and up?

You can host a file share witness on a domain-joined Windows server, or if your cluster is running Windows Server 2019, any device that can host an SMB 2 or later file share.
125496-823.png
https://docs.microsoft.com/en-us/windows-server/failover-clustering/file-share-witness#:~:text=A%20file%20share%20witness%20is%20an%20SMB%20share,to%20a%20router%20as%20a%20file%20share%20witness.

Also, what would happen if the file share witness server was to go offline in the above setup?

A file share witness is not “the quorum”, it is voting member that helps establish quorum. As a general rule, the voting elements in the cluster should be an odd number, there is an odd number of votes in the cluster, this means that the FSW can be lost, the cluster can still stay online.






823.png (6.2 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Yufeishao,

So a file share witness, would be suitable because we have two sites.
But, we don't have a separate third site to host the file share witness, what is usually done in this scenario?

0 Votes 0 ·

One option is to host the file server in one of two data centers, thus making that data center the primary data center.

0 Votes 0 ·