Comments (4)

  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 http://download.microsoft.com/download/3/B/5/3B51A025-7522-4686-AA16-8AE2E536034D/WS2008%20Multi%20Site%20Clustering.doc

  3. […] multi-site clustering, “geo-clustering” became available with SQL Server 2008, and is being enhanced in SQL Server 2012. Note: you’ll need storage magic like SAN replication to get your Geo-cluster […]

Leave a Reply to Dave LevyCancel reply