Invention Grant
- Patent Title: Distributed availability groups of databases for data centers for providing massive read scale
-
Application No.: US15402729Application Date: 2017-01-10
-
Publication No.: US10909107B2Publication 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
- US20180096023A1 DISTRIBUTED AVAILABILITY GROUPS OF DATABASES FOR DATA CENTERS FOR PROVIDING MASSIVE READ SCALE Public/Granted day:2018-04-05
Information query