Interface Unit for Decoupling Database Commands in High Availability Clusters
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The integration of databases into high availability clusters is inefficient and error-prone due to the need for manual implementation of different plugins for various HA cluster server products, leading to tight coupling and inflexibility, especially when migrating to new database products.
Innovation Solution
An interface unit with two layers that maps HA cluster server-specific commands to database-specific commands, using HA cluster server-independent and database-independent command representations to enable seamless integration across multiple HA cluster servers and database products, ensuring timely responses and decoupling from specific command formats.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If manual implementation of different plugins is performed for various HA cluster server products, then integration capability is achieved, but development effort and error risk increase substantially
Solution Approach 1:
The patent implements a universal plugin framework that can integrate multiple database products (Oracle, MySQL, PostgreSQL, SQL Server) into a single HA cluster server. Instead of creating separate plugins for each HA cluster server product, the framework provides a standardized interface that works across different HA cluster server implementations, reducing development effort while maintaining broad integration capability
Solution Approach 2:
The patent introduces an intermediary layer (the plugin framework) that sits between the database products and HA cluster servers. This framework translates and adapts commands between different database-specific protocols and HA cluster server requirements, enabling integration without requiring separate custom plugins for each HA cluster server product
2Reliability
If plugins are manually implemented for each HA cluster server product, then specific database integration is achieved, but flexibility for migration to new database products is lost
Solution Approach 1:
The plugin framework is designed to be product-agnostic and database-agnostic, providing universal integration capability. When migrating to a new database product, the framework automatically adapts to the new database's protocol through its standardized interface, eliminating the need to rewrite plugins and maintaining both reliability and flexibility
Solution Approach 2:
The framework employs dynamic command translation and adaptation mechanisms that can adjust to different database products in real-time. This dynamic behavior allows the system to maintain reliable integration while being flexible enough to accommodate migrations to new database products without requiring static, hard-coded plugin implementations
3Adaptability or versatility
If multiple specific plugins are implemented, then coverage of different HA cluster servers is improved, but system coupling becomes tight and maintenance becomes difficult
Solution Approach 1:
The patent extracts the integration logic from individual HA cluster server-specific plugins and consolidates it into a single universal plugin framework. This extraction removes the tight coupling between specific HA cluster servers and database products, allowing the framework to maintain broad coverage while reducing system complexity and improving maintainability
Data Source
Figure 1
Figure 2
Figure 3~6
AI summary
1. The invention concerns an interface unit (1) adapted for connecting at least one database (D1, D2, ..., Dn) to at least one of a plurality of high availability cluster servers (HA cluster servers) (S1, S2, ..., Sn), wherein each database (D1, D2, ..., Dn) is adapted to execute a set of database-specific commands (DC1, DC2, ..., DCn) and wherein each HA cluster server (S1, S2, ..., Sn) is adapted to output a set of HA cluster server-specific commands (SC1, SC2, ..., SCn), the interface unit (1) comprising: a. a first interface layer (I1) adapted for receiving each of the set of HA cluster server-specific commands (SC1, SC2, ..., SCn) outputted by the HA cluster servers (S1, S2, ..., Sn); and b. a second interface layer (I2) adapted for sending each of the set of database-specific commands (DC1, DC2, ..., DCn) to the respective databases (D1, D2, ..., Dn); wherein c. the interface unit (1) is further adapted to map each of the HA cluster server-specific commands (SC1, SC2, ..., SCn) to at least one of the database-specific commands (DC1, DC2, ..., DCn).