Database Server Agent Messaging for Tenant-Isolated Control
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database management systems face inefficiencies in resource consumption, security, and tenant isolation due to numerous connections and disparate code sets, leading to potential data leakage and registration errors.
Innovation Solution
A database management system utilizing a control plane with a messaging cluster for secure, isolated communication through a single connection, global tenant management, automated registration, and dynamic event aggregation to optimize resource use and enhance security and efficiency.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If multiple connections are established between control plane and database servers for different operations, then communication flexibility and operation types are improved, but resource consumption and system complexity increase
Solution Approach 1:
The patent implements a universal communication channel between control plane and database servers that can handle multiple operation types (create, read, update, delete, backup, restore) through a single connection. This multi-functional channel eliminates the need for separate dedicated connections for each operation type, thereby reducing system complexity while maintaining full operational flexibility.
2Reliability
If multiple connections are maintained for different database operations, then operation reliability is improved, but resource consumption increases
Solution Approach 1:
The patent merges multiple operation-specific connections into a single unified communication channel between control plane and database servers. This consolidation reduces the total number of active connections and associated resource consumption (file descriptors, memory, CPU overhead) while maintaining operational reliability through proper message routing and protocol handling within the unified channel.
3Reliability
If tenant isolation is enforced through separate communication channels, then security is improved, but device complexity increases
Solution Approach 1:
The patent implements logical segmentation of the unified communication channel through message routing mechanisms that identify and route messages to appropriate tenants or operations based on message headers or content. This logical segmentation provides tenant isolation and security without requiring physically separate communication channels, thereby maintaining security while avoiding the complexity of multiple dedicated channels.
Data Source
AI summary
Aspects of the present disclosure are directed to a system comprising a memory having computer-readable instructions stored thereon, and a processor of a database server, the processor executing the computer-readable instructions to generate a request to a control plane for an operation to be performed on the database server, wherein the control plane is configured to communicate with a plurality of database servers having a plurality of agents running thereon, and wherein each of the plurality of agents has a dedicated communication connection with the control plane, publish the request on the dedicated communication connection associated with the agent to send the request to the control plane, receive, on the dedicated communication connection, a response from the control plane, the response comprising a response to the request from a service of the control plane, and execute the operation on the database server based on the response.