Database Redo Log Migration via Independent Memory
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
During database service migration across physical machines, existing methods interrupt the connection between clients and servers, leading to poor user experience due to service interruptions.
Innovation Solution
A data migration method that migrates the redo log and database data from one device to another independent memory, allowing for online operating system status migration without interrupting the database service, enabling seamless service continuity and improved user experience.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If the database service is switched across physical machines using existing methods, then the database service can be migrated from one physical machine to another, but the connection between client and server must be interrupted, causing service interruption and poor user experience
Solution Approach 1:
The patent applies preliminary action by pre-migrating the redo log to an independent memory before the actual database service migration. This preparation ensures that when the service switch occurs, the target physical machine already has the necessary log data ready, enabling seamless continuation of transactions without interrupting client connections.
Solution Approach 2:
The patent introduces an independent memory as an intermediary component between the source and target physical machines. This intermediary stores the redo log and facilitates the migration process by acting as a buffer, allowing the database service to switch machines without direct data transfer interruptions, thus maintaining service continuity.
2Adaptability or versatility
If the connection between client and server is interrupted during migration, then the database service can be switched to another physical machine, but user experience deteriorates due to perceived service disruption
Solution Approach 1:
The patent ensures continuity of useful action by maintaining active client connections throughout the migration process. The independent memory continuously holds the redo log data, and the database service on the target machine continuously processes requests, creating a seamless experience for users who perceive no interruption in service.
Solution Approach 2:
The independent memory serves as a mediator that decouples the client-server connection from the physical machine migration. By storing the redo log independently, it allows the service to switch underlying hardware while clients remain connected, eliminating perceptible disruptions to user experience.
3Reliability
If the redo log is migrated to an independent memory during online migration, then service continuity is maintained, but the complexity of the migration process increases
Solution Approach 1:
The patent applies segmentation by separating the redo log storage from the physical machines and placing it in an independent memory. This segmentation simplifies the migration process by isolating the critical log data, allowing the database service to be migrated without complex data transfer operations, thus maintaining service continuity while managing complexity.
Solution Approach 2:
The independent memory acts as a mediating component that simplifies the overall system architecture. By introducing this intermediary layer, the patent reduces the complexity of direct machine-to-machine data transfer and enables straightforward online migration while maintaining service continuity.
Data Source
AI summary
In one example method, a second memory stores data in a database, and the second memory is a memory independent of a first device and a second device. When determining that a database service needs to be switched, the first device may migrate a redo log of the database from a first memory of the first device to the second memory. The second device migrates the redo log from the second memory to a third memory of the second device, and the first device and the second device perform operating system status migration online.