MySQL database middleware preprocessing method

Abstract

The invention belongs to the field of communication, and particularly relates to an MySQL database middleware preprocessing method. The method comprises the following steps that an application programis connected with and uses 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 a sentence through the hash value; the application program obtains a query result. By means of the MySQL database middleware preprocessing method, support on preprocessing is morecomprehensive, all the preprocessing functions are entirely achieved in the aspect of the middleware, and there is almost no difference between connection of the application program with the middleware and the connection of the application program with an MySQL database for use. Load balancing of the rear-end MySQL database can be more efficiently achieved, all load balancing strategies are supported, and the system query efficiency is improved. Separation of reading and writing can be achieved to the greatest extent, and the load of a primary library is lowered. The method occupies few systemresources, and is conveniently and flexibly deployed on all types of servers.

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...

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

Images