Comments (3)

  1. […] HA feature has gone mostly unnoticed. I haven’t heard anyone talking about it yet, so… [full post] SQLSoldier SQLSoldier sql serverclusteringdenalidisaster recovery 0 0 […]

  2. I noticed your diagrams are showing the geo-clusters as 4 node clusters but everyone I have talked to says that they should be 3 node. I have even heard people claim that MS only supports 3 node geo-clusters but have yet to see any doc to confirm that.

    Personally, I prefer 4 nodes to allow for HA while at the DR site. Have any thoughts one way or the other?

    1. The images were for entertainment purposes only. 😀

      Seriously though, they are talking about node majority. A standard implementation is to have an odd number of nodes (3, 5, 7, etc.) with the greater amount in the primary data center. The reason for this is so that if there is communication loss between the data centers, the site with >half of the nodes will continue to operate whereas the site with

Leave a Reply

Your email address will not be published. Required fields are marked *