UPS Charge-Aware Database Switchover

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing information handling systems, particularly those with mission-critical applications like Microsoft Exchange, face challenges in maintaining database availability and resilience during power outages due to lack of visibility into system power states, leading to resource starvation and system hangs during failover processes.

Innovation Solution

An information handling system with a processor and program instructions that determine if the UPS has adequate charge to switchover database resources to other systems within a database availability group, aborting shutdown sequences and determining the best system for switchover based on load balancing and resource utilization.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If a traditional UPS shutdown sequence is initiated during a power outage, then the server power is protected, but database resources experience resource starvation and system hangs during failover

Engineering Contradiction:
Improvepower protectionVSAvoiddatabase availability
Core Design Contradiction:
ReliabilityVSProductivity

Solution Approach 1:

The system performs preliminary assessment of UPS charge adequacy before initiating shutdown sequence. By evaluating whether the UPS has sufficient charge to complete a graceful switchover of database resources, the system can abort the shutdown sequence and initiate switchover proactively, avoiding resource starvation and system hangs that would occur with traditional shutdown approaches

Inventive Principle:
Principle #10Preliminary action

2Device complexity

If Microsoft Exchange Managed Availability service operates without visibility to power state, then system complexity is reduced, but proactive switchover cannot be initiated

Engineering Contradiction:
Improvesystem complexityVSAvoidservice availability
Core Design Contradiction:
Device complexityVSReliability

Solution Approach 1:

The patent introduces an intermediary component that bridges the UPS power management system and the Microsoft Exchange Managed Availability service. This intermediary provides visibility into the power state (battery charge status) to the Exchange service, enabling it to make informed decisions about proactive switchover while maintaining relatively simple system architecture through standardized integration interfaces

Inventive Principle:
Principle #24Intermediary (Mediator)

3Loss of time

If all Exchange services are moved simultaneously during failover, then failover is completed quickly, but resource starvation and system hangs occur

Engineering Contradiction:
Improvefailover timeVSAvoidsystem stability
Core Design Contradiction:
Loss of timeVSReliability

Solution Approach 1:

The system segments the failover process into assessable units by first evaluating UPS charge adequacy before initiating any service migration. This segmentation allows the system to determine whether conditions are favorable for switchover, preventing simultaneous movement of all Exchange services when power conditions are insufficient, thereby avoiding resource starvation while still enabling efficient failover when conditions are met

Inventive Principle:
Principle #1Segmentation

Data Source

PatentUS11307946B2Systems and methods for intelligent availability in a database availability group
Publication Date: 2022.04.19 DELL PROD LP
  • US11307946B2 patent drawing
  • US11307946B2 patent drawing

AI summary

A method may include in response to a power event of a power system of an information handling system, determining if an uninterruptible power supply of the information handling system has adequate charge to switchover database resources from the information handling system to one or more other information handling systems integral to a database availability group. The method may also include if the uninterruptible power supply of the information handling system has adequate charge to switchover database resources from the information handling system to one or more other information handling systems integral to the database availability group, causing a shutdown of the information handling system initiated by a power manager of the uninterruptible power supply to abort, determining which of the one or more other information handling systems to switchover the database resources to, and causing switchover of the database resources based on such determination.