Mpp database disaster recovery method, device and equipment based on pre-write log and object storage

By adopting a three-element backup architecture based on write-ahead logs and object storage, and a distributed recovery point mechanism, the problem of strong dependence on local storage and inflexible recovery in MPP database disaster recovery is solved, realizing an efficient and flexible disaster recovery solution and improving resource utilization and data consistency.

CN122195730APending Publication Date: 2026-06-12HASHDATA LTD
View PDF 0 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN ยท China
Patent Type
Applications(China)
Current Assignee / Owner
HASHDATA LTD
Filing Date
2026-03-18
Publication Date
2026-06-12

AI Technical Summary

Technical Problem

Existing MPP database disaster recovery solutions suffer from problems such as strong dependence on local storage, inflexible recovery point and recovery time targets, and low utilization of disaster recovery resources. They are difficult to achieve efficient and flexible cross-regional data backup and recovery, and lack an effective coordination mechanism in a multi-node distributed environment, making it difficult to guarantee data consistency.

Method used

A three-element backup architecture based on write-ahead logs and object storage is adopted to generate full and incremental backup data chains. Through distributed recovery points and WAL continuous synchronization mechanism, accurate recovery of disaster recovery cluster is achieved. In the recovery pause state, read-only service capability is provided through hot standby and data synchronization integrated mechanism and rapid switchover is achieved in the event of primary cluster failure.

Benefits of technology

It enables efficient off-site disaster recovery for MPP databases, provides flexible recovery point selection and minute-level RPO and RTO metrics, improves the utilization of disaster recovery resources, ensures data consistency and business continuity, and reduces infrastructure costs and complexity.

โœฆ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN122195730A_ABST
    Figure CN122195730A_ABST
Patent Text Reader

Abstract

The application relates to an MPP database disaster recovery method, device and equipment based on pre-write logs and object storage. The method comprises the following steps: based on physical data files and pre-write logs of a master cluster, according to a ternary backup architecture of the pre-write logs and object storage, full backup data chains and incremental backup data chains stored in the object storage are generated; according to the backup data chains and continuously archived WAL logs, through a distributed recovery point and a WAL continuous synchronization mechanism, a disaster recovery cluster that can be restored to a specified time point is acquired; according to the disaster recovery cluster in a recovery suspension state, through a hot backup and data synchronization integrated mechanism, a disaster recovery cluster that has a read-only service capability and can be upgraded to a master cluster is generated. The application constructs a disaster recovery architecture based on object storage, realizes recovery at any time point by using a distributed recovery point, provides a read-only service and rapid switching through hot backup, and realizes a high-availability closed loop.
Need to check novelty before this filing date? Find Prior Art