Replica Database Server Segmentation for Consistency
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current systems replicating a master database to a replica database face inefficiencies in reducing response time, particularly when multiple servers access numbering and difference databases, leading to increased response times as the number of servers increases.
Innovation Solution
The system employs separate numbering and difference databases for each server, allowing asynchronous access and maintaining consistency through sequence numbers and checkpoint mechanisms, enabling the replica database creation server to store data in ascending order without exclusive control, thus reducing response time.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If multiple servers access shared numbering and difference databases, then data consistency can be maintained, but response time increases as the number of servers increases
Solution Approach 1:
The patent divides the shared databases into separate dedicated databases for each server. Each server has its own numbering database and difference database, eliminating contention for shared resources while maintaining data consistency through the sequence number mechanism. This segmentation resolves the contradiction by allowing parallel access without interference.
Solution Approach 2:
The patent introduces sequence numbers as an intermediary mechanism to manage data replication order. The replica database creation server uses these sequence numbers to process changes in the correct order, ensuring consistency without requiring exclusive access control. This intermediary enables asynchronous operations while maintaining reliability.
2Reliability
If exclusive control is used to maintain database consistency, then data integrity is ensured, but response time increases due to access restrictions
Solution Approach 1:
By segmenting the databases into server-specific instances, the patent eliminates the need for exclusive control mechanisms. Each server operates independently on its own databases, achieving data integrity without access restrictions. This resolves the contradiction between reliability and ease of operation.
Solution Approach 2:
Each server independently manages its own numbering and difference databases without requiring control from other servers or centralized coordination. This self-service approach maintains data integrity through the sequence number mechanism while allowing concurrent access, improving operational efficiency.
3Reliability
If data is stored in ascending order of sequence numbers, then replica database consistency is maintained, but processing complexity increases
Solution Approach 1:
The sequence number acts as an intermediary that simplifies the sorting and processing of data. By attaching a simple numerical identifier to each change, the replica database creation server can efficiently sort and apply changes in order without complex dependency tracking. This resolves the contradiction by making the sorting process straightforward while ensuring consistency.
Data Source
AI summary
An information processing device includes a memory, and a processor coupled to the memory and configured to acquire a plurality of data from first databases, where the data are stored in the first databases in a first period, and identifiers are stored in the first databases in association with the data, where the first databases correspond to servers that perform manipulations on a plurality of records containing the data stored in a second database, and the identifiers indicate order of the manipulations, and store the data in a third database in order indicated by the identifiers.