A preprocessing method of mysql database middleware

A middleware and preprocessing technology, applied in the field of communication, can solve the problem of inapplicable master-slave architecture, achieve the effect of convenient and flexible deployment, improve efficiency, and realize the separation of read and write

Active Publication Date: 2022-03-11
JINAN JOVISION TECH CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This approach is only applicable to the case where the backend servers are all master libraries (both can be written to), and not applicable to the general master-slave architecture

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A preprocessing method of mysql database middleware

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] this invention

[0036] S1: The middleware sorts and trims the prepared statements sent by the application program, then takes the hash value, and forms a prepared statement hash table. The same prepared statement corresponds to a hash value;

[0037] S2: The middleware sends the hash value to the application, and the application needs to send the obtained hash value and the parameters to be bound to the middleware at the same time;

[0038] S3: When the middleware receives the hash value and binding parameters sent by the application, it queries the corresponding prepared statement and operation type through the hash value, and replaces the last binding parameter;

[0039] S4: The middleware returns the hash value to the application again, and the application sends the received hash value and executes the command;

[0040] According to different load balancing strategies, the middleware executes on the corresponding back-end MySQL server sent with the recently reserve...

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

No PUM Login to view more

Abstract

The invention belongs to the communication field, in particular to a MySQL database middleware preprocessing method. The method includes the following steps: the application program connects and uses the middleware; the application program sends a prepared statement to obtain a hash value; the application program sets binding parameters through the hash value; the application program executes the statement through the hash value; the application program obtains the query result. The present invention has more comprehensive support for preprocessing, and the present invention completely realizes all preprocessing functions at the middleware level, and there is almost no difference between the application program and the direct connection to the MySQL database; this method can be implemented more efficiently The load balancing of the client MySQL database supports various load balancing strategies and improves the query efficiency of the system; this method can realize the separation of reading and writing to the greatest extent and reduce the load of the main database; this method takes up very little system resources and is convenient and flexible to deploy in various type of server.

Description

(1) Technical field [0001] The invention belongs to the communication field, in particular to a MySQL database middleware preprocessing method. (2) Background technology [0002] Generally speaking, a middleware is required to communicate between the MySQL cluster and the application. The role of middleware is that for applications, it does not need to care about whether the database is a stand-alone database or a cluster database, and only accesses the database through the middleware, without changing the code, and is not affected by changes in the database cluster architecture; for database clusters , you can freely perform load balancing distribution, flexibly adjust the architecture design, and the downtime of a certain database in the cluster will not affect the normal service. Middleware plays the role of proxy, forwarding, and relay, so that both the application program and the database cluster can be flexibly changed without affecting each other. [0003] The appli...

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
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/242G06F16/2455G06F16/25
CPCG06F16/2433G06F16/2455G06F16/252
Inventor 李云龙安晓博
Owner JINAN JOVISION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap