Invention Grant
- Patent Title: High availability and automated recovery in scale-out distributed database system
-
Application No.: US17077028Application Date: 2020-10-22
-
Publication No.: US11455219B2Publication Date: 2022-09-27
- Inventor: Krishna Kantikiran Pasupuleti , Boris Klots , Vijayakrishnan Nagarajan , Anantha Kiran Kandukuri , Nipun Agarwal
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Becker Bingham Ledesma LLP
- Agent Brian N. Miller
- Main IPC: G06F11/00
- IPC: G06F11/00 ; G06F11/20 ; G06F16/2453 ; G06F16/2455

Abstract:
Herein are acceleration techniques for resuming offloaded execution by replacing a failed computer with a hot spare computer. In an embodiment, a distributed system configures a DBMS, a set of participating computers, and a set of spare computers. The DBMS receives a query of a database. From the query, an offload query plan is generated for distributed execution. The DBMS sends the offload query plan and a respective portion of the database to each participating computer. The distributed system detects that a participating computer failed after the offload query plan was sent. Responsively, the DBMS sends the same offload query plan and same respective portion of the database of the failed computer to a replacement computer from the spare computers. Despite the computer failure, the DBMS receives results of successful distributed execution of the offload query plan that include a result from the replacement computer.
Public/Granted literature
- US20220129358A1 HIGH AVAILABILITY AND AUTOMATED RECOVERY IN SCALE-OUT DISTRIBUTED DATABASE SYSTEM Public/Granted day:2022-04-28
Information query