Database Server Dedicated Administrator Connection for Failure Recovery
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database servers face significant challenges in recovering from failure states, such as being non-responsive, as existing recovery methods are time-consuming and resource-intensive, making it difficult to diagnose and resolve issues without rebooting the machine.
Innovation Solution
A Dedicated Administrator Connection (DAC) is introduced, allowing administrators to connect to the database server even when standard connections fail, enabling them to diagnose and resolve issues without shutting down the server, by reserving resources like memory and threads exclusively for the DAC.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If standard recovery models (full recovery, simple recovery, bulk-logged recovery) are used to restore database state after failure, then data protection and recovery capability are improved, but recovery time and resource consumption increase significantly
Solution Approach 1:
The patent segments the connection functionality by creating a dedicated administrator connection separate from standard user connections. This segmentation allows administrators to access and diagnose database issues without requiring full system recovery, thereby reducing recovery time while maintaining data protection capabilities through selective intervention.
Solution Approach 2:
The dedicated administrator connection acts as an intermediary channel that enables administrators to intervene in database operations during failure states. This intermediary connection allows diagnostic and corrective actions without requiring complete system restart or full recovery procedures, thus reducing recovery time while preserving data integrity.
2Reliability
If the database server is shut down and restarted to resolve non-responsive states, then the server can recover from hung states caused by bugs or bad configuration, but service interruption and downtime increase
Solution Approach 1:
The dedicated administrator connection enables administrators to perform self-service diagnostics and corrective actions directly on the running server. Administrators can identify and resolve issues such as runaway transactions or configuration problems without shutting down the server, thereby maintaining service availability while restoring responsiveness.
Solution Approach 2:
The patent changes the operational parameters of the database server by introducing a special connection mode that operates differently from standard connections. This parameter change allows the server to accept administrative commands even in non-responsive states, enabling issue resolution without service interruption and maintaining productivity.
3Ease of operation
If standard connections are used to access the database server during failure conditions, then normal database operations can be performed, but access fails when the server is in a hung or non-responsive state
Solution Approach 1:
The patent introduces dynamic connection behavior where the dedicated administrator connection adapts to server state conditions. Unlike static standard connections that fail when the server is unresponsive, the dynamic dedicated connection remains accessible during failure states, allowing administrators to connect and diagnose issues regardless of server responsiveness.
Solution Approach 2:
The dedicated administrator connection serves multiple functions: it enables normal database operations when the server is healthy and provides diagnostic access when the server is in a failure state. This multi-functionality ensures connection accessibility across all server states, improving both ease of operation and reliability of access.
4Difficulty of detecting and measuring
If administrators need to diagnose and troubleshoot server issues, then they can identify problems such as runaway transactions, but they require debugger tools or repro requests that complicate the process
Solution Approach 1:
The patent extracts diagnostic capabilities directly into the dedicated administrator connection, separating troubleshooting functionality from complex external debugger tools. Administrators can execute diagnostic commands and view server state information through the simplified connection interface, eliminating the need for separate debugger tools or repro request processes and reducing diagnostic complexity.
Data Source
AI summary
A Dedicated Administrator Connection (DAC) for a database server is provided that allows a user with administrator privileges to connect to the database server when a connection by standard means fails. By allowing an administrator to connect to the server through the DAC, the administrator can resolve the issue despite the failure and bring back the server to a responsive state without requiring the server to be shut down and restarted. Additionally, support engineers, developers, etc. can use the DAC to diagnose a range of problems without the use of a debugger or requesting a repro while monitoring for issues.