Windows Failover Clustering, one of the best features available in Windows Server OS!!
Use Cases and Deployment Scope
We utilized Windows Server Failover Clustering as an integral part of a MS SQL cluster setup. We utilized it for almost zero downtime on our Microsoft SQL serving our on prem Sharepoint implementations, as well as several critical IT infrastructure systems that need a SQL database back end. This allows us to perform maintenance and patching without affecting the applications that use the SQL server. It's deployed on a active passive setup. We also set up a test Hyper-V high availability cluster.
Pros
- It allows us to perform maintenance and patching on the passive node without having to shutdown the database and incurring downtime.
- We are able to repair a failed server but failing the database over if there is a hardware failure on the active node. Minimizing downtime on the database.
- It provides an automated recovery when there is failure without IT intervention when there is an issue.
Cons
- The setup of the Windows Server Failover Clustering is complex, requiring different networks and multiple network cards.
- Better integration between the Windows Failover clustering and Hyper-V. Unlike VMWare you have to make changes to two places instead of just one panel.
- I wish there was a web portal to manage the cluster. Instead you have to remote desktop into the VIP address and go to the Cluster manager.
Likelihood to Recommend
It works fantastic in conjuncture with the MS SQL cluster setup. When a SQL node had a hardware failure, it failed over to the passive node. No one was the wiser that anything happened to the system until our Operations department realized that node was down. We were able to repair the server and bring it back up without causing issues on the database. Which meant the application was also still up, which we were very happy with. I didn't like it when used with Hyper-V to setup a cluster, although it allowed us to set it up similar to a VMWare cluster, I did not like having to go between the Windows Failover Clustering manager then the Hyper-V manager to work on a VM. It also caused a small issue when one of my colleagues setup a VM, he forgot to add Windows Failover Cluster.

