Invention Grant
- Patent Title: Transaction processing for a database distributed across availability zones
-
Application No.: US16530350Application Date: 2019-08-02
-
Publication No.: US11436218B2Publication Date: 2022-09-06
- Inventor: Le Cai , Xin Jia , Qinyi Wu
- Applicant: Alibaba Group Holding Limited
- Applicant Address: KY George Town
- Assignee: Alibaba Group Holding Limited
- Current Assignee: Alibaba Group Holding Limited
- Current Assignee Address: KY George Town
- Agency: Van Pelt, Yi & James LLP
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F1/14 ; G06F16/27

Abstract:
Transaction processing for a database distributed across availability zones is disclosed, including: determining that a transaction comprising a set of one or more statements is to be executed on a plurality of database servers across at least two availability zones, wherein each availability zone is associated with a respective hybrid logical clock (HLC)-based centralized time service; causing the set of one or more statements to execute on the plurality of database servers across the at least two availability zones; obtaining a plurality of HLC-based prepare timestamps from the plurality of database servers across the at least two availability zones; selecting a maximum HLC-based prepare timestamp to use as a commit timestamp associated with the transaction; and determining whether to return a commit result corresponding to the transaction after a time delay that is determined based at least in part on a predetermined time skew.
Public/Granted literature
- US20210034605A1 TRANSACTION PROCESSING FOR A DATABASE DISTRIBUTED ACROSS AVAILABILITY ZONES Public/Granted day:2021-02-04
Information query