Transparent Session Migration for Database Workload Redistribution
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing multi-node database systems face challenges in dynamically rebalancing workload between nodes, as connection-time balancing only shifts load at session creation and cannot redistribute existing session workloads, leading to inefficiencies in performance and maintenance operations.
Innovation Solution
Implementing transparent session migration techniques that allow clients to be switched from a session on one server to another without modifying application instructions, using client-side interface components to handle session migration and enable workload redistribution between nodes, even after session creation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If connection-time balancing is used to distribute workload, then sessions are balanced at creation time, but existing session workloads cannot be redistributed
Solution Approach 1:
The patent implements dynamic session migration that allows sessions to be moved between database instances at runtime, transforming the static connection-time balancing into a dynamic system that can adapt workload distribution continuously. The workload manager monitors session states and migrates sessions based on current system conditions, enabling the system to respond to changing workload patterns and maintain optimal performance.
Solution Approach 2:
The patent performs preliminary actions by establishing session state capture and migration protocols before actual migration is needed. The system prepares migration-capable sessions by implementing state serialization mechanisms and pre-configuring failover capabilities, allowing rapid session redistribution when workload imbalances occur without requiring application code modifications.
2Reliability
If session state is captured and transferred during migration, then complete session continuity is maintained, but migration complexity and overhead increase
Solution Approach 1:
The patent extracts session state from the running session and stores it in a separate, standardized format that can be independently managed and transferred. By separating session state from the execution context, the system enables straightforward migration without requiring complex coordination between source and destination instances. The extracted state can be captured, stored, and restored using simple serialization and deserialization operations.
Solution Approach 2:
The patent creates copies of session state that can be transferred between database instances without affecting the original session until migration is complete. The system maintains session state as copyable data structures that can be duplicated and restored at the destination instance, ensuring session continuity while simplifying the migration process through straightforward data copying rather than complex state transfer protocols.
3Speed
If sessions are migrated without capturing state, then migration speed increases, but session state loss occurs
Solution Approach 1:
The patent implements self-service session migration where the session state is automatically captured, serialized, and transferred as part of the migration process without requiring external intervention. The workload manager autonomously handles state capture and restoration, enabling fast migration by using efficient, pre-configured state serialization mechanisms that minimize overhead while ensuring complete state preservation.
Data Source
AI summary
Techniques allow a client to be migrated from a session that has been established for a client on a server to another session on another server in a way that is a transparent to the application for which the initial session was established. The sessions are migrated under conditions in which a copy of session state of the session to migrate from the source node does not have to be captured and restored to a destination session.