Database load balancing method and device based on HTTP (Hyper Text Transport Protocol) request and medium
A load balancing and database technology, applied in database management systems, digital data authentication, digital data protection, etc., can solve problems such as intrusive applications
Pending Publication Date: 2021-07-30
SHANGHAI SHENTIE INFORMATION ENG
View PDF9 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
The advantage of this method is that the proxy middleware is bypassed, and it is only the manager of the database load balancing strategy. It does not participate in database operations and will not become a bottleneck for database access. The disadvantage of this method is that it is intrusive to the application, and the application and It takes two requests to connect to the database
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment 1
[0028] A database load balancing method based on HTTP requests, such as figure 1 shown, including the following steps:
[0029] S1. Obtain a connection request in the form of an HTTP request, perform a security check on the connection request, if the security check passes, execute step S2, otherwise, give a prompt that the security check fails;
[0030] S2. Obtain the weight of each database in the database cluster, and acquire the current number of connection requests of the database cluster;
[0031] S3. Based on the weight of each database and the number of current connection requests, allocate a database for the connection request;
[0032] S4. Establish a database connection, execute the SQL statement in the connection request, and return the execution result.
[0033] A database load balancing device based on HTTP requests, including a configuration module, a client and a database cluster, the configuration module is used to perform connection requests and security che...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention relates to a database load balancing method and device based on an HTTP request and a medium, and the method comprises the following steps: obtaining a connection request in an HTTP request form, carrying out safety verification on the connection request, and if the safety verification fails, giving a safety verification failure prompt; obtaining the weight of each database in the database cluster, and obtaining the current connection request frequency of the database cluster; based on the weight of each database and the current connection request frequency, distributing the database for the connection request; and establishing database connection, executing the SQL statement in the connection request, and returning an execution result. Compared with the prior art, the method has the advantages that the connection request is obtained based on the HTTP request, database access load balancing is achieved, the method is friendly to the client, especially for a WEB program and a mobile phone terminal APP, the AUTH timeliness and the strategy of being abandoned after being used are adopted, user password verification and IP verification are combined, and database access safety can be better guaranteed.
Description
technical field [0001] The invention relates to the technical field of load balancing, in particular to an HTTP request-based database load balancing method, device and medium. Background technique [0002] A load balancing cluster is composed of a group of mutually independent computing nodes, which are connected through a conventional network or a dedicated network. The nodes cooperate with each other, share loads, and balance pressure. For the client, the entire cluster can be regarded as an independent server with ultra-high performance. In the technical field of database load balancing, in order to realize the load balancing of the database, there must be a control program to control the connection of the database. This control program cuts off the direct connection between the application program and the database. All application programs access this control program first, and then the control program decides which database to visit. Commonly used control programs in...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/25G06F9/50G06F21/60G06F21/62G06F21/31
CPCG06F16/252G06F9/5083G06F21/604G06F21/6218G06F21/31G06F2221/2137G06F2221/2151
Inventor 杨友兰刘绍杰吴文波
Owner SHANGHAI SHENTIE INFORMATION ENG