Standby Database Resynchronization Using Differential Update Logs
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing systems face increased processing load during resynchronization of a standby system database after an active system failure, as all data is written to the standby system, leading to inefficiencies.
Innovation Solution
An information processing apparatus that includes an active process executor and a standby process executor, which updates and synchronizes databases based on accumulated update information, determining recovery processing only when necessary, reducing unnecessary load.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If all data is written to the standby system database during resynchronization after failure recovery, then the standby system database is fully synchronized with the active system database, but the processing load increases significantly
Solution Approach 1:
The standby process executor performs preliminary actions by accumulating update information from the active system database during normal operation before a failure occurs. This advance preparation ensures that when resynchronization is needed after a failure, the standby system already has the necessary update information stored, eliminating the need to rewrite all data and significantly reducing processing load during recovery.
Solution Approach 2:
The invention extracts only the necessary update information from the active system database and stores it in the standby system's memory structure. Instead of transferring the entire database, only the differential update information is extracted and accumulated, which reduces the amount of data that needs to be processed during resynchronization while maintaining complete synchronization.
2Productivity
If the standby process executor accumulates update information in memory during standby period, then resynchronization processing load is reduced after failure recovery, but memory resources are consumed during normal operation
Solution Approach 1:
The standby process executor applies local quality by selectively accumulating only the update information that is actually needed for synchronization, rather than storing the entire database. The memory is used efficiently to store only the differential changes, and the accumulation process is localized to occur during standby periods when the standby system is not actively processing requests.
Solution Approach 2:
The update information accumulation is performed periodically during standby periods. The standby process executor accumulates update information in memory during intervals when the standby system is in its idle state, then applies this accumulated information during resynchronization when needed. This periodic accumulation pattern optimizes memory usage by avoiding continuous storage requirements.
Data Source
AI summary
The management server includes an active process executor that updates a database of a first system on the basis of instruction information and accumulates the instruction information in a storage device of the first system as first update information, and a standby process executor that updates a database on the basis of second update information acquired from a storage device of a second system. In a case in which the active period starts in the first system before the standby process executor acquires the second update information from the storage device of the second system, the active process executor determines, upon recovery of the second system, whether to execute the recovery processing reflecting the content of the second update information in the database on the basis of the first update information and the second update information.