question

Moon12-1537 avatar image
0 Votes"
Moon12-1537 asked ·

2 Node SQL Server 2016 Cluster in Virtual environment

I have a 2 Node SQL Server Failover Cluster between two data centres
Node 1 - Primary - Site1
Node 2 - Secondary - Site2
Data disks - Storage Replica (setup between site1 and 2)
Fileshare witness - on Site 2 on a separate server ( standalone server)

My question is if Site 2 is completely cut off or power down, What happens to the Windows cluster and SQL Services? will it continue to run from Site1? No impact at all?




windows-server-clustering
10 |1000 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.

XiaoweiHe-MSFT avatar image
0 Votes"
XiaoweiHe-MSFT answered ·

Hi,

As far as I'm concerned, when site 2 node is down, the SQL instance in Node 2 will failover to node 1, and node 1 will keep running. We need to ensure the Node 1 could access the file share witness.

Although SQL cluster can keep running with one node + wintess, it's recommended to add at least two nodes in each site, so the cluster may have more fault tolerance.

Thanks for your time!
Best Regards,
Anne


If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our [documentation][20] to enable e-mail notifications if you want to receive the related email notification for this thread.
[20]: https://docs.microsoft.com/en-us/answers/articles/67444/email-notifications.html


·
10 |1000 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 ·

Hey,

You can use StarWind VSAN free to create a small replicated device to run as a disk witness for your cluster. In this case, if one of sites fails it will still have a connection to witness drive. Check the following guide for more:
https://www.starwindsoftware.com/resource-library/starwind-virtual-san-for-hyper-v-2-node-hyperconverged-scenario-with-windows-server-2016/#975a9857211a3b66215d3a2bb624b10e77312268

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.

·
10 |1000 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.