Systems and methods for consistent backup of distributed, transactional databases
AssigneePalantir Technologies Inc.
InventorJames Baker
Life of this patent
Estimating the term…
Abstract
A distributed, transactional database uses timestamps, such as logical clock values, for entry versioning and transaction management in the database. To write to the database, a service requests a timestamp to be inserted into the database with a new version of data. During a backup procedure, a cleanup process is paused, issuing new timestamps is paused, and a backup timestamp is generated, which results in an effective backup copy. During a restore of a backup, a snapshot of the database is loaded and any entries older than the backup timestamp are deleted, which ensures that a consistent restore has occurred.
Claims14
A database system comprising:
- one or more computer hardware processors configured to execute computer-executable instructions to cause the database system to at least:
- pause a cleanup process on a plurality of nodes of a database cluster;
- initiate a hold on issuing one or more new timestamps to one or more external computing devices;
- generate a backup timestamp;
- generate a duplicate copy of data from the plurality of nodes;
- and
- store, in a backup data store, the duplicate copy of data and the backup timestamp.
A method comprising:
- pausing a cleanup process on a plurality of nodes of a database cluster;
- initiating a hold on allowing writes from committing to the database cluster;
- generating a backup timestamp;
- generating a duplicate copy of data from the plurality of nodes;
- and
- storing, in a backup data store, the duplicate copy of data and the backup timestamp,
- wherein the method is performed by one or more computer hardware processors.
Dependencies are inferred from the claim text.