Database Test Server Real-Load Tuning via Virtualization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database testing methods do not allow for real-time evaluation of different configurations without disrupting production server operations, making it difficult to find optimal configurations for improved performance.
Innovation Solution
A database environment with a production server and a test server connected via virtualization, where the test server receives and processes the same incoming service requests as the production server but does not dispatch responses, allowing for real-time testing of various configurations while maintaining production server functionality.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If the database test server is subjected to the same incoming service request traffic as the production server for real-time testing, then the accuracy of configuration evaluation is improved, but the production server operations may be disrupted
Solution Approach 1:
The system segments the server functionality by separating the testing function from the production function. The virtualization connection divides incoming service request traffic into two streams: one for the production server and one for the test server. This allows the test server to be subjected to real traffic for accurate configuration evaluation while the production server continues operations independently, resolving the contradiction between measurement precision and reliability.
Solution Approach 2:
The virtualization connection acts as an intermediary that receives incoming service request traffic and distributes it to both the production server and test server. This intermediary mechanism enables the test server to process real traffic for accurate testing while the production server maintains its operational stability, as the virtualization layer manages the traffic distribution to prevent disruptions.
2Productivity
If the test server processes real service requests for testing, then real-time performance evaluation is improved, but the complexity of the database environment increases
Solution Approach 1:
The virtualization connection provides multi-functionality by serving multiple purposes: it routes traffic to the production server for normal operations, simultaneously routes traffic to the test server for real-time testing, and enables configuration comparison. This universal component allows the test server to process real requests for efficient testing without requiring separate test traffic generation systems, though it does add virtualization infrastructure complexity.
3Adaptability or versatility
If multiple configurations are tested on the test server, then the ability to find optimal configuration is improved, but the time required for testing increases
Solution Approach 1:
The test server continuously processes real service request traffic and evaluates configurations in real-time rather than requiring discrete, sequential testing phases. Multiple configurations can be tested continuously as traffic flows through the system, allowing the system to maintain continuous useful action for configuration evaluation without significant time loss, while still providing adaptability for finding optimal configurations.
Data Source
AI summary
A database environment that includes one or more database production servers, one or more database test servers, and a virtualization connection that provides incoming service request traffic to both the database production server and the database test server. However, the database production server responds to the database service requests, while the database test server does not. The database test server may be tested for a variety of different configurations in an attempt to find a better performing configuration. The testing is in real-time as the database test server is subjected to the same incoming service request traffic as the database production server.