Incremental Run-Time Session Balancing in Multi-Node Database Systems
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In multi-node computer systems, managing resource allocation across databases to meet performance and availability goals is complex, particularly in scenarios where database sessions need to be migrated to balance workload, as existing methods can impact performance and resource availability, leading to inefficiencies and potential oscillations.
Innovation Solution
The implementation of incremental run-time session balancing, where database sessions are migrated from underperforming database servers to better-performing ones within the system, using a hierarchy of directors to dynamically adjust resource allocation, with a find migration destination procedure to select optimal destination instances and calculate the number of sessions to migrate, while minimizing disruption and maintaining performance and resource availability.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If database sessions are migrated to balance workload, then resource utilization is improved, but performance and resource availability may be impacted
Solution Approach 1:
The patent implements dynamic session migration by continuously monitoring performance metrics and resource availability, and adjusting session allocation in real-time based on current system conditions. The database director dynamically determines when and where to migrate sessions, making the system adaptive rather than static.
Solution Approach 2:
The system incorporates feedback mechanisms where performance metrics and resource availability data are continuously collected and used to guide session migration decisions. The database director uses this feedback to determine optimal migration timing and destination, ensuring that migrations occur only when they will improve overall system performance without compromising availability.
2Productivity
If session migration is performed aggressively, then workload balancing is improved, but system oscillations may occur
Solution Approach 1:
The patent applies partial action by migrating only the necessary number of sessions rather than all sessions from overloaded databases. The database director calculates the optimal number of sessions to migrate based on current load conditions, preventing over-correction that would lead to oscillations while still achieving effective workload balancing.
Solution Approach 2:
The system prevents oscillations by implementing preliminary checks before migration - monitoring performance metrics and resource availability thresholds to determine when migration should occur. This preliminary anti-action prevents unnecessary migrations that would cause system instability while ensuring migrations happen when truly needed.
Data Source
AI summary
An approach migrates database sessions from a database server on which performance and resource availability requirements are not being met to another database server. Because workload is removed from the database server not meeting these requirements, improved performance there is promoted. Furthermore, the approach switches the users in a way that attempts to keep performance and resource availability levels at the database server receiving the database sessions within goals for performance and resource availability.