Checkpoint-Based Data Replication for Server Cluster Failover

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Ensuring the safety and security of data while optimizing data processing across server clusters and data centers is challenging, particularly in maintaining consistency and coherence of distributed database records, especially when failures occur and data needs to be replicated across multiple systems.

Innovation Solution

Implementing a checkpoint-based data replication method where a computing platform initiates data processing jobs, directs server nodes to execute processing steps, updates a checkpoint table, and replicates results across data centers, allowing for failover capabilities in case of failures by resuming data processing from the last completed checkpoint.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If data is replicated across multiple data centers, then data safety and security are improved, but system complexity increases

Engineering Contradiction:
Improvedata safetyVSAvoidsystem complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The patent implements checkpoint tables that record the state of data processing at regular intervals before failures can occur. These checkpoints are pre-established during normal operation, enabling the system to quickly resume from a known good state without complex real-time coordination between data centers during failure recovery

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent divides the distributed data processing system into independent segments with local checkpoint tables at each data center. Each data center maintains its own checkpoint state and can independently resume processing, reducing the complexity of inter-data-center coordination while maintaining data safety through replication

Inventive Principle:
Principle #1Segmentation

2Stability of the object's composition

If data processing jobs are restarted from the beginning after failure, then data consistency is maintained, but processing time increases

Engineering Contradiction:
Improvedata consistencyVSAvoidprocessing time
Core Design Contradiction:
Stability of the object's compositionVSLoss of time

Solution Approach 1:

Checkpoint tables are continuously updated during normal data processing operations to record the state after each processing step. When a failure occurs, these pre-recorded checkpoints enable immediate resumption from the last known good state, eliminating the time loss associated with restarting from the beginning while maintaining data consistency through the recorded checkpoint states

Inventive Principle:
Principle #10Preliminary action

3Reliability

If checkpoint tables are replicated across data centers, then failover capability is improved, but network bandwidth consumption increases

Engineering Contradiction:
Improvefailover capabilityVSAvoidnetwork bandwidth
Core Design Contradiction:
ReliabilityVSLoss of energy

Solution Approach 1:

Each data center maintains its own local checkpoint table with the processing state specific to that data center. This localization reduces the amount of data that needs to be replicated across the network, as each data center only needs to replicate its own checkpoint state rather than receiving complete checkpoint information from all other data centers, thereby reducing network bandwidth consumption while maintaining failover capability

Inventive Principle:
Principle #3Local quality

Data Source

PatentUS10296425B2Optimizing data processing across server clusters and data centers using checkpoint-based data replication
Publication Date: 2019.05.21 BANK OF AMERICA CORP
  • US10296425B2 patent drawing
  • US10296425B2 patent drawing
  • US10296425B2 patent drawing

AI summary

Aspects of the disclosure relate to optimizing data processing across server clusters and data centers using checkpoint-based data replication. A computing platform may determine to initiate a data processing job associated with identifying one or more features of a source dataset, and the data processing job may include multiple processing steps. Based on determining to initiate the data processing job, the computing platform may generate one or more commands directing one or more cluster server nodes associated with a data center to execute the multiple processing steps. The one or more commands may direct the one or more cluster server nodes to update a checkpoint table as each processing step is completed, and may further direct the one or more cluster server nodes to replicate processing results data to at least one other data center. Subsequently, the computing platform may send the generated commands to the cluster server nodes.