US 2022/0188196 A1 · CONTINUOUS DATA PROTECTION

Abstract

Changes made to a database table are accumulated, in durable storage, and snapshots of partitions of the table are obtained. For successive snapshots of a partition, the system accesses a previous snapshot, applies changes from the accumulated changes, and stores the updated snapshot to a durable data store. The accumulated changes and the successive partition snapshots are made available to restore the database to any point in time across a continuum between successive snapshots. Although each partition of the table may have a backup snapshot that was generated at a time different from when other partition snapshots were generated, changes from respective change logs may be selectively log-applied to distinct partitions of a table to generate an on-demand backup of the entire table at common point-in-time across partitions. Point-in-time restores of a table may rely upon a similar process to coalesce partition snapshots that are not aligned in time.

Claims20

Dependent claims

A system, comprising:

a plurality of storage nodes, each of which comprises one or more storage devices or logical storage volumes that implement a database service that stores data in partitions;
a change log storage to accumulate change log data for the partitions;
and
a data protection manager to perform a method to at least:
for each of a plurality of successive copy events for a database partition:
access a previous copy of the database partition from a copy data store and apply changes from a change log since the previous copy was created to generate a new copy of the database partition;
and
store the new copy to the copy data store;
wherein changes from the change log and the plurality of successively generated copies are available to restore the database partition to states between successive ones of the plurality of successively generated copies.

6 more elements

A non-transitory computer readable storage medium storing program instruction that, if executed by a computer, cause the computer to perform:

storing a first set of indications of changes to a database, wherein the first set of indications of changes correspond to changes made to the database subsequent to generating a first copy of the database;
storing a second copy of the database, wherein the second copy includes changes made to the first copy of the database indicated by the first set of indications;
and
storing a back-up copy of the first set of indications of changes.

1 more element

Dependencies are inferred from the claim text.

Continuous data protection

Life of this patent

Continuous data protection

Life of this patent

Abstract

Claims20