Flexible Database Failover via Geographic Server Separation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional failover systems in distributed database environments lack flexibility and transparency due to geographic restrictions on the placement of primary and backup database servers, limiting high availability and disaster recovery capabilities.
Innovation Solution
Implementing a cluster of database servers that allows for asynchronous and synchronous replication across geographically diverse locations, enabling seamless failover and rolling upgrades without geographic restrictions, using a High Availability Disaster Recovery (HADR) system that includes a primary, standby, and companion database server configuration.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If conventional failover systems are used with geographic restrictions, then system reliability is maintained through controlled failover, but adaptability deteriorates due to limited server placement options
Solution Approach 1:
The patent extracts the geographic restriction constraint from the failover system, allowing database servers to be placed at any location without requiring physical proximity. This is achieved through network-based communication protocols that enable remote replication and failover capabilities, thereby improving adaptability while maintaining reliability through controlled failover mechanisms.
Solution Approach 2:
The system implements universal failover capabilities that work across any geographic location and server configuration. The failover mechanism is designed to be location-agnostic, supporting multiple server placements and network topologies, which enhances adaptability while preserving system reliability through standardized failover procedures.
2Device complexity
If the number of backup database servers is limited, then device complexity is reduced, but adaptability deteriorates due to inability to scale for growing requirements
Solution Approach 1:
The patent implements dynamic server configuration that allows the number of backup database servers to be flexibly adjusted based on organizational needs. The system supports adding or removing backup servers without requiring system redesign, enabling scalability while managing complexity through automated configuration and management protocols.
Solution Approach 2:
The system segments the database infrastructure into modular components (primary server, standby servers, backup servers) that can be independently configured and scaled. This modular architecture allows organizations to start with a minimal configuration and gradually add more backup servers as needed, improving adaptability while keeping initial complexity low.
3Speed
If geographic restrictions are imposed on database server placement, then network latency is reduced for failover operations, but adaptability deteriorates due to limited location options
Solution Approach 1:
The patent implements local quality optimization by allowing geographic proximity to be considered on a per-failover-scenario basis rather than imposing universal restrictions. The system can select standby servers based on real-time network conditions, workload requirements, and geographic considerations, thereby achieving fast failover when needed while maintaining location flexibility through intelligent server selection.
Data Source
AI summary
Seamless failover in a database replication environment which has a primary database server and a plurality of standby database servers, is described. An example method includes orderly terminating transactions on the primary database server, where the transactions are originated from client applications. The transaction logs of the primary database server are drained and the transaction logs are replicated from the primary database server to the plurality of standby database servers. One of the standby database servers is designated as a new primary database server processing user transactions.