Invention Grant
- Patent Title: Distributed availability groups of databases for data centers including different commit policies
-
Application No.: US15402756Application Date: 2017-01-10
-
Publication No.: US10909108B2Publication Date: 2021-02-02
- Inventor: Girish Mittur Venkataramanappa , Zhengguo Sun , Varun Kunjbihari Tibrewal , Steven John Lindell , Sameer Arun Verkhedkar , Sandeep Lingam , Colin Neville
- Applicant: Microsoft Technology Licensing, LLC
- Applicant Address: US WA Redmond
- Assignee: Microsoft Technology Licensing, LLC
- Current Assignee: Microsoft Technology Licensing, LLC
- Current Assignee Address: US WA Redmond
- Agency: Ray Quinney & Nebeker, P.C.
- Agent Thomas M. Hardman; Timothy J. Churna
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F16/23 ; G06F16/27 ; G06F16/182 ; G06F11/20 ; G06F11/14

Abstract:
A Distributed Availability Group (DAG) spans two AGs, each spanning one or more replica nodes and functioning as primary or secondary AG. A primary AG is replicated to the secondary AG synchronously or asynchronously. A failover in the DAG results in the AGs swapping their roles. Multiple DAGs can be linked together as a chain, which provides many useful features including disaster recovery across geographical regions, massive read scale (numerous readable secondary nodes), online migration of databases (across different operating systems and computing environments). The systems using DAGs can replicate databases across multiple independent high availability (HA) failover clusters using complex replication topologies and allow for manual failover and failback. The systems allow chaining of multiple AGs to provision a treelike structure of replicas and numerous secondary replicas without impacting performance. The systems automatically seed new database replicas to facilitate building a complex topology of DAGs.
Public/Granted literature
- US20180095836A1 DISTRIBUTED AVAILABILITY GROUPS OF DATABASES FOR DATA CENTERS INCLUDING DIFFERENT COMMIT POLICIES Public/Granted day:2018-04-05
Information query