Point-in-time storage volume for database replication undo
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database systems require extensive time, complexity, and resources to restore a database to a previous state, especially during replication, and lack efficient mechanisms for processing UNDO and REDO commands, leading to potential data loss and system unavailability.
Innovation Solution
The system allows for the creation of point-in-time copies of data volumes, enabling selective UNDO and REDO operations by copying data to a point-in-time storage volume before replicating the actual volume, and issuing commands to revert or restore data to previous states, thereby simplifying the recovery process and reducing resource overhead.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data is retrieved from external backup to reset the database to an older state, then data recoverability is ensured, but the recovery time and system unavailability increase significantly
Solution Approach 1:
The system creates point-in-time copies of the target volume before replication begins, storing them in a point-in-time storage box. This preliminary action ensures that a restore point is already available when needed, eliminating the need for time-consuming external backup retrieval and enabling immediate restoration to the pre-replication state.
2Reliability
If the last known good version of the database is retrieved and brought up to date using data from a data log or point in time copy, then data restoration is achieved, but the process complexity and error susceptibility increase
Solution Approach 1:
The system extracts and stores a point-in-time copy of the target volume in a separate point-in-time storage box before replication. This extracted copy is maintained independently, allowing simple restoration by copying data back to the target volume without complex data log processing or multiple restoration steps, thereby reducing process complexity and potential errors.
3Adaptability or versatility
If point-in-time copies are created and stored before replication, then UNDO capability is enabled, but storage resource requirements increase
Solution Approach 1:
The system creates a point-in-time copy of the target volume and stores it in a dedicated point-in-time storage box. This copy serves as a restore point that can be used to undo replication if needed. The copy is maintained separately from the main replication data, enabling UNDO capability while managing storage resources through targeted duplication of only the necessary restore state.
Data Source
AI summary
A method for replicating a volume of data including selecting a target storage box to receive a physical copy of the actual volume of data stored on the source storage box for replication of the actual volume of data, selecting a point in time storage box to receive a physical copy of actual data stored on the target storage box, physically copying actual data stored on the target storage box to the point in time storage box, performing the replication of the actual volume of data by initiating the physical copying on the target storage box of the actual volume of data, and selectively undoing the physical copying on the target storage box of the actual volume of data by replacing the current actual data stored on the target storage box with the physical copy of actual target storage box data stored on the point in time storage box.