Distributed availability groups of databases for data centers including different commit policies

摘要: A Distributed Availability Group (DAG) spans two AGs, each spanning one or more replica nodes and functioning as primary secondary AG. AG is replicated to the synchronously asynchronously. failover in DAG results AGs swapping their roles. Multiple DAGs can be linked together a chain, which provides many useful features including disaster recovery across geographical regions, massive read scale (numerous readable nodes), online migration of databases (across different operating systems computing environments). The using replicate multiple independent high availability (HA) clusters complex replication topologies allow for manual failback. chaining provision treelike structure replicas numerous without impacting performance. automatically seed new database facilitate building topology DAGs.