Overall Satisfaction with Windows Server Failover Clustering
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.
- 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.
- 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.
- One of the most important features in the high availability of the SQL cluster ensuring we have minimum downtime.
- The automatic fail over feature. Making sure the database is always up when a failure occurs on the hardware level.
- The ease of managing the resource in the Failover clustering manager.
- A positive impact is that we are able to setup the Windows Server Failover Clustering with just the Standard Windows server and SQL license.
- We have hardware redundancy on our SQL server so we won't have to worry about hardware failures on maintenance windows. We can work on the passive node while the database is up on the active node.
- We were able to setup a virtualization cluster without having to purchase additional licenses for a test instance.
- We are able to utilize MS SQL for some of our more critical infrastructure because of the Windows Failover clustering, since the database was always up as long as one node was up.
We fell the Windows Server Failover Clustering was better than the Oracle Real Application Clusters. Although the Oracle Real Application cluster provided an active setup it was more unstable. On more than one occasion a split brain issue had occurred when both nodes thought the other node was down and attempted to take control of the database causing the application to go down. Support pointed to drop pings between the two nodes on the clustering network. We had initially connected the clustering network thru a switch so we changed that to a direct connect crossover cable. Even after that, it would still occasionally have an issue. We never had that issue on the Windows Failover Clustering, it had been very stable and we never had an outage.
Do you think Windows Server Failover Clustering delivers good value for the price?
Yes
Are you happy with Windows Server Failover Clustering's feature set?
Yes
Did Windows Server Failover Clustering live up to sales and marketing promises?
Yes
Did implementation of Windows Server Failover Clustering go as expected?
Yes
Would you buy Windows Server Failover Clustering again?
Yes