Adaptive Database Redo Log Synchronization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Legacy database systems face inefficiencies in redo log synchronization, leading to increased latency due to fixed synchronization modes that do not adapt to changing system conditions, such as varying workloads and configurations over time.
Innovation Solution
The system dynamically switches between post-wait and poll-wait synchronization modes based on measured and predicted waiting times, using performance monitoring to select the mode that minimizes latency, and employs a counter and threshold to limit frequent mode switches.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of time
If post-wait synchronization mode is used, then latency is reduced when few processes are committing, but scalability deteriorates as the number of committing processes increases
Solution Approach 1:
The system dynamically switches between post-wait and poll-wait synchronization modes based on the current number of committing processes. When the number of committing processes is low, post-wait mode is used to minimize latency. When the number of committing processes increases, the system transitions to poll-wait mode to improve scalability. This dynamic adaptation resolves the contradiction by allowing the system to optimize for latency when needed and for scalability when needed.
2Adaptability or versatility
If poll-wait synchronization mode is used, then scalability is improved as the number of committing processes increases, but latency increases when few processes are committing
Solution Approach 1:
The system uses a dynamic mode selection mechanism that monitors the number of committing processes and switches between poll-wait and post-wait modes accordingly. When the system is scalable but has few committing processes, the system switches to post-wait mode to reduce latency. This dynamic adjustment resolves the contradiction by allowing poll-wait to provide scalability when needed while switching to post-wait to minimize latency when the workload is light.
3Device complexity
If synchronization mode is fixed at deployment, then system simplicity is maintained, but adaptability to changing workloads deteriorates over time
Solution Approach 1:
The system implements dynamic mode switching between post-wait and poll-wait synchronization modes based on real-time monitoring of committing process counts and performance metrics. This allows the system to adapt to changing workloads and system conditions automatically, resolving the contradiction between maintaining simplicity and achieving adaptability. The switching logic is built into the system operation, allowing it to respond to changing conditions without requiring complex external configuration or manual intervention.
Data Source
AI summary
A method, system, and computer program product for adaptive high-performance database redo log synchronization. The method commences upon performing a write operation of a redo log entry, the write operation concluding with an indication of completion of the write operation of the redo log entry. Any number of committing processes may be waiting for the indication of completion, and upon indication of completion, then (using a first synchronization mode) the processes or proxy measures the waiting time as experienced by the committing processes (e.g., while waiting for the indication of completion of the write operation of the redo log entry). In some cases a second synchronization mode would introduce less latency than the first synchronization mode, so the system changes to a second synchronization mode. The system can also change mode when a predicted second mode waiting time is smaller than the measured waiting time.