Systems and methods for performing a database backup for repairless restore

A system for performing a database backup for repairless restore, the system comprising:

• a receiving module, stored in memory, that receives, during a database backup operation by a reconciliation node in a backup cluster, replica data records representing copies of a database from each of a plurality of data storage nodes in a production cluster, such that all replicas of a single key are received by a single one node;
• a processing module, stored in memory, that processes the replica data records in parallel without inter-node communication between the data storage nodes;
• a merging module, stored in memory, that merges updates to the replica data records, wherein the updates are merged by:
• communicating with the production cluster;
• and
• performing a record synthesis operation that merges updates to a plurality of different data columns in the replica data records at a plurality of different times to re-create a complete data record for the replica data records;
• an identification module, stored in memory, that identifies stale or redundant data records in the updated replica data records;
• a discarding module, stored in memory, that discards the stale or redundant data records from the updated replica data records to create a single copy of updated data records;
• a restoring module, stored in memory, that restores the copy of the updated data records to the production cluster by replicating the updated data records to each of the data storage nodes, wherein each of the updated data records is consistent thereby obviating subsequent repair;
• and
• at least one physical processor configured to execute the receiving module, the processing module, the merging module, the identification module, the discarding module, and the restoring module.

A non-transitory computer-readable medium comprising one or more computer-executable instructions that, when executed by at least one processor of a computing device, cause the computing device to:

• receive, during a database backup operation by a reconciliation node in a backup cluster, replica data records representing copies of a database from each of a plurality of data storage nodes in a production cluster, such that all replicas of a single key are received by a single one node;
• process the replica data records in parallel without inter-node communication between the data storage nodes;
• merge updates to the replica data records, wherein the updates are merged by:
• communicating with the production cluster;
• and
• performing a record synthesis operation that merges updates to a plurality of different data columns in the replica data records at a plurality of different times to re-create a complete data record for the replica data records;
• identify stale or redundant data records in the updated replica data records;
• discard the stale or redundant data records from the updated replica data records to create a single copy of updated data records;
• and
• restore the copy of the updated data records to the production cluster by replicating the updated data records to each of the data storage nodes, wherein each of the updated data records is consistent thereby obviating subsequent repair.