Server Network Query Routing with Look-Up Table and Load Balancing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing network server management systems are non-scalable, lack redundancy, and fail to utilize server resources effectively, leading to delayed or unprocessed queries and downtime during server failures or load imbalances.
Innovation Solution
Implementing a system where multiple servers each have access to a database, with a look-up table directing query processing and a program logic controller for workload rebalancing, ensuring all servers receive queries and monitor each other's processing, allowing for seamless failover and efficient resource allocation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If the database is divided into segments across three separate servers with no overlap, then each server has a specialized role, but the system lacks redundancy and cannot respond to queries if one server fails
Solution Approach 1:
The patent implements full database copies on each server rather than segmented data. Each server contains a complete copy of the database, enabling any server to process any query. This copying approach provides redundancy and failover capability while maintaining simplified data management.
2Productivity
If servers are added to increase processing capacity, then the network can handle more queries, but the system requires shutting down the entire network for installation and data rearrangement
Solution Approach 1:
The patent performs data rearrangement and server configuration in advance before the network needs expansion. By pre-configuring servers with full database copies and updating the look-up table beforehand, the system allows hot-swapping of servers without network shutdown, eliminating downtime during capacity expansion.
Solution Approach 2:
The patent implements a dynamic server configuration where the look-up table can be updated in real-time to reflect changes in server capacity and data distribution. This dynamic approach allows the system to adapt to changing conditions without requiring complete network shutdowns for reconfiguration.
3Productivity
If one server has available processing capability, then that server could handle more queries, but there is no mechanism for other servers to know and utilize this capacity
Solution Approach 1:
The patent implements a monitoring mechanism where servers continuously report their processing status and capacity to the network. This feedback loop enables the look-up table to be dynamically updated with current server availability and performance data, allowing the system to automatically route queries to servers with available capacity and balance load efficiently.
Data Source
AI summary
Exemplary systems and methods for server management are provided. An exemplary system comprises a plurality of servers, with each server having the ability to access a database or, in some embodiments, be configured to perform a calculation, computation or make a determination of a particular value, values or other information. A communications network delivers queries to each server whereby a look-up table directs query processing by the servers. Further embodiments of the system feature a program logic controller for rebalancing the workload of the network servers. Exemplary methods of processing queries on the system comprise submitting a query to the network, communicating the query to each server in the network and each server looking-up on a look-up table the processing responsibilities of the servers in the network. The query is processed by the server having primary responsibility for processing the query while other the servers monitor query processing. Transmission of a query result to a user typically completes the process.