Database Synchronization for Transaction Continuity
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In the event of a primary database failure, existing technologies cannot acquire and process transaction data accurately, leading to interrupted transactions and poor user experience, as they rely on database recovery rather than alternative data sources.
Innovation Solution
A method and device for data storage that synchronizes data values from a primary database to a reading database within M seconds, allowing a transaction processing server to determine accurate data values from either a standby or reading database and store them in the standby database during primary database failures, enabling continuous transaction processing.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If the primary database is used to store and process transaction data, then data accuracy is maintained, but service continuity is interrupted when the database fails
Solution Approach 1:
The patent applies preliminary action by pre-synchronizing data from the primary database to the standby database before any failure occurs. The standby database is maintained with up-to-date data through continuous synchronization, so when the primary database fails, the system can immediately switch to the standby database without interruption, thus maintaining both data accuracy and service continuity.
Solution Approach 2:
The patent introduces a standby database as an intermediary component that receives real-time data synchronization from the primary database. This standby database acts as a mediator that can take over service provision when the primary database fails, ensuring service continuity while maintaining data accuracy through the pre-established synchronization relationship.
2Measurement precision
If the system waits for primary database recovery before processing transactions, then data accuracy is ensured, but transaction processing is interrupted
Solution Approach 1:
The system performs preliminary data synchronization to the standby database before failures occur, eliminating the need to wait for primary database recovery. When failure occurs, transactions can immediately use the pre-synchronized data from the standby database, thus ensuring data accuracy while minimizing transaction interruption time to nearly zero.
Solution Approach 2:
The standby database serves as a cushion prepared in advance that can absorb the impact of primary database failures. By maintaining a current copy of data beforehand, the system cushions against the harmful effect of transaction interruptions, allowing seamless continuation of service without waiting for recovery.
3Productivity
If real-time data synchronization is implemented from primary to standby database, then service continuity is maintained during failures, but system complexity increases
Solution Approach 1:
The patent implements a simplified copying mechanism where the standby database receives incremental data changes from the primary database through real-time synchronization. This copying approach maintains service continuity during failures while keeping the system relatively simple by using standard database replication techniques rather than complex distributed consensus protocols.
Data Source
Figure 1
Figure 2
Figure 3
AI summary
Data values stored in a primary database are synchronized to a reading database in M seconds. In the event of a failure of the primary database, a transaction processing server determines a transaction request in M seconds and performing a transaction processing of the transaction request to acquire a corresponding transaction identification and a data variation value, determines whether a data value corresponding to the transaction identification is stored in a standby database or not; if not, determines an accurate data value corresponding to the transaction identification by using the data value stored in the reading database and the data variation value; and stores the transaction identification and the accurate data value in the standby database to provide a service based on the data value stored in the standby database. The techniques of the present disclosure prevent the transaction from being interrupted and improve user experience.