Database Switching Load Management via Transaction List Migration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database switching techniques often result in a temporary increase in load on the switching destination apparatus, leading to degraded response performance and inefficient use of computational resources in standby systems.
Innovation Solution
An information processing apparatus that manages a database by generating a list of transactions and migrating update data to another apparatus during switching, prioritizing migration based on transaction status to reduce load and optimize resource usage.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If all update data is migrated to the switching destination apparatus after switchover, then data consistency is ensured, but the load on the switching destination apparatus temporarily increases and response performance degrades
Solution Approach 1:
The patent applies preliminary action by migrating update data for committed transactions to the standby apparatus before the switchover occurs. The system identifies transactions that have been committed on the active apparatus and proactively transfers their update data to the standby apparatus in advance. This ensures that when switchover happens, the standby apparatus already possesses the necessary update data, eliminating the need for post-switchover migration and avoiding load spikes that would degrade response performance.
2Reliability
If the standby apparatus synchronizes with every transaction commit, then data consistency is maintained, but computational resources are wasted as the standby cannot serve other purposes
Solution Approach 1:
The patent applies local quality by implementing selective synchronization where the standby apparatus synchronizes only with update data from committed transactions rather than all transaction activities. The system identifies and transfers only the necessary update data portions related to committed transactions, allowing the standby apparatus to maintain data consistency for failover purposes while reducing unnecessary computational overhead. This enables the standby apparatus to conserve computational resources for other tasks while still ensuring reliability when needed.
3Reliability
If switchover is performed immediately without waiting for transaction completion, then service continuity is maintained, but the switching destination apparatus receives excessive load
Solution Approach 1:
The patent applies preliminary action by performing load assessment and selective update data migration before the switchover is triggered. The system evaluates the current transaction state and identifies which update data needs to be transferred to the standby apparatus. By completing this preparatory migration in advance, the system enables immediate switchover without overwhelming the destination apparatus, as the necessary data is already in place and only essential load transfer is required.
Data Source
AI summary
A storage unit stores update data corresponding to transactions being executed and indicating updating processes yet to be reflected in a database. A control unit generates a list indicating transactions. When apparatuses executing transactions are switched from an information processing apparatus to another information processing apparatus, the control unit transmits the list to the other information processing apparatus, and migrates the update data to the other information processing apparatus based on the list.