Database Defragmentation via Standby Role Switching
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Fragmentation in database storage areas leads to inefficient use of space, as repeated additions, deletions, and updates create fragmentary free areas, causing insufficient space for new records and potential failures in data synchronization across databases with different fragmentation states.
Innovation Solution
An information processing apparatus that determines active and standby databases based on free space information, performs data relocation by suspending synchronization, initializing, and copying data to optimize storage, and switches roles to ensure defragmentation across all databases, thereby reducing fragmentary free areas and maintaining data redundancy.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Manufacturing precision
If data relocation is performed on individual databases at different timing, then the fragmentation of each database can be reduced, but data synchronization failures occur due to insufficient free space in standby databases
Solution Approach 1:
The system performs data relocation on the standby database before it is needed for failover. By proactively defragmenting the standby database and ensuring it has sufficient free space, the system prevents synchronization failures from occurring in the first place, rather than reacting to them after they happen.
Solution Approach 2:
The system monitors the free space status of databases and uses this information to determine when data relocation should be performed. This feedback mechanism allows the system to dynamically adjust its data relocation strategy based on the current fragmentation state and synchronization requirements.
2Manufacturing precision
If data relocation is performed on the active database, then storage efficiency is improved, but data processing performance deteriorates due to the relocation operation
Solution Approach 1:
The system performs data relocation on the standby database in advance, before it becomes the active database. This ensures that when failover occurs, the new active database is already optimized and ready to handle data processing operations without performance degradation from ongoing relocation operations.
Solution Approach 2:
The standby database acts as an intermediary that absorbs the data relocation operation. By performing defragmentation on the standby rather than the active database, the system uses the standby as a buffer to eliminate fragmentation without impacting the performance of the active database that is serving data processing requests.
3Reliability
If databases are kept in synchronized state, then data redundancy is maintained, but storage space is wasted due to duplication across all databases
Solution Approach 1:
The system changes the fragmentation parameter of databases through selective data relocation operations. By adjusting the storage organization (defragmentation) of individual databases based on their role and status, the system optimizes space utilization while maintaining the necessary data redundancy for failover capability.
Data Source
AI summary
Free spaces of a plurality of databases including the same data are monitored. The free spaces depend on fragmentation states of the respective databases. A first database is determined to be an active database, and a second database whose free space is larger than that of the first database is determined to be a standby database. Data relocation processing is performed on the second database, the data relocation processing including suspending data synchronization, initializing the standby database, copying data of the active database to the standby database, and resuming the data synchronization. Controlling is performed so that the data relocation processing is performed on a database other than the second database by changing the active database and the standby database.