I'm looking to setup a two physical node WFC cluster (server 2016) which has no shared disks. Performing standalone install of SQL server 2016 Standard on each of the nodes and then configuring a BAG on top of that.
In terms of quoroum Im going with node majority as there is no shared disk or witness configured.
Has anyone out there done the similar and is this bad practice? Am I required to give it a qouroum?
Also seems when you shut down SQL service on the primary node there isn't automatic failover... hmm... even though its set the sync commit and auto failover. Something isn't right
Also seems when you shut down SQL service on the primary node there isn't automatic failover... hmm... even though its set the sync commit and auto failover. Something isn't right From testing it appears if one node goes down then the AV resource just fails over to the other node. Just wondering whether we would have splitbrain scenario as using node majority?
Thoughts?