We are building a new SQL 2012 cluster for our web environment. We decided to use two nodes and utilize AlwaysOn Availability Groups for High Availability. Server01 and Server02 have had a Standalone Instance of SQL installed and both have been joined to Cluster01. An availability group has been created. Server01 and Server02 are nodes in the availability group, and are configured for Synchronous-commit replicas.
However I noticed the other day when Server01 required a reboot for patching that it brought down the entire cluster. When I open Windows Failover Cluster Management mmc on Server02 I see that the cluster is down and requires the service be restarted on Server02 (not sure if this is related to what we ultimately want to achieve). I open up SQL Management Studio on Server02 and the availability group is showing a state of Resolving (doesn't indicate that Server02 has become the primary node). If I expand the Database section in SSMS it shows the databases in a Recovery Pending state. If I try to expand one of the databases (not the system databases ie. master, model, etc.) I get the following error:
The database SiteAdmin is not accessible. (ObjectExplorer)
When I expand Availability Groups in SSMS and then expand Replicas I only see Server02 listed. After Server01 comes back up I open Windows Failover Cluster Management locally on the server. Server01 shows that it is attempting to connect to the cluster. However Server02 shows that the cluster is still down. Though I still need to manually start the cluster service on both the nodes. After I do this the Availability Group comes back online showing Server02 still being the Secondary node.
After seeing this I checked the current Quorum settings for Cluster01. Currently it is set to Node Majority which indicates with the two node configuration we have that it cannot sustain a lost of even one node. I believe that if we stood up a third server with another standalone SQL instance that node majority would work. However we do not have the resources. Based on these settings I think that we need to change the quorum settings for the cluster, but not sure if AlwaysOn supports the use of using a Disk or File Share witness for automatic failover.