Transparent Database Switching in Master-Replica High Availability
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current cloud computing platforms require significant manual input and expertise for configuration and management, making it complex for users to take advantage of computing capabilities effectively.
Innovation Solution
The implementation of automated methods and apparatus for managing virtual machine resources, including provisioning, linking, and reclaiming resources, using a system that includes an application director, cloud manager, and virtual appliances with internal proxies for transparent database switching in a master-replica setup.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If manual configuration and management methods are used for cloud computing platforms, then users can control and customize the system, but the complexity of operation and management increases significantly
Solution Approach 1:
The system implements automated self-service capabilities through virtual machine blueprints that automatically provision, configure, and manage database clusters. The blueprint manager autonomously handles resource allocation, database installation, configuration, and commissioning without requiring manual user input, thereby reducing operational complexity while maintaining control.
Solution Approach 2:
The patent applies preliminary action by pre-configuring database clusters using standardized blueprints that define all necessary parameters, resource allocations, and configuration settings in advance. This allows the system to automatically instantiate fully configured database environments without requiring users to perform complex manual configuration steps during deployment.
2Extent of automation
If automated resource management is implemented, then operational complexity is reduced, but the need for sophisticated automation systems increases
Solution Approach 1:
The virtual machine blueprint system serves multiple functions: it acts as a provisioning tool, configuration manager, resource allocator, and commissioning system simultaneously. This multi-functional approach consolidates what would otherwise require multiple separate automation systems into a single unified platform, reducing overall system complexity while maintaining high automation capabilities.
Solution Approach 2:
The blueprint manager acts as an intermediary layer between users and the complex underlying infrastructure. It abstracts sophisticated automation processes into simple blueprint definitions, allowing users to manage automated resource allocation and configuration without directly interacting with complex automation mechanisms.
3Productivity
If database clusters are virtualized and automated, then deployment speed increases, but the reliability requirements for automated failover mechanisms increase
Solution Approach 1:
The system implements beforehand cushioning by pre-configuring replica databases and failover mechanisms as part of the blueprint definition. High-availability configurations, including synchronous replication settings and failover policies, are established in advance during blueprint creation, ensuring that reliability mechanisms are already in place before deployment begins, thus supporting rapid deployment without compromising failover reliability.
Data Source
AI summary
Methods, apparatus, and systems to perform transparent database switching using master-replica high availability setup in relational databases are disclosed. An example system includes a first virtual appliance including a first proxy and a master database, the first proxy to forward service traffic to the master database, the master database to read and/or write data based on the service traffic; a second virtual appliance including a second proxy and a first replica database, the second proxy to determine data stored in the master database, the first replica database to replicate the master database; and a third virtual appliance including a third proxy and a second replica database, the third proxy to, in response to determining the master database of the first virtual appliance is to power down, promote the second replica database to the master database.