Distributed database connection method and device
A connection method and a technology of a connection device, applied in the database field, can solve the problems of reducing the service capability of the application program, the number of threads in the connection pool is too large, and the waste of application program system resources, etc., so as to avoid the problem that the connection cannot be reused and the number of threads is too large Effect
Active Publication Date: 2019-07-19
唯品会(广州)软件有限公司
View PDF5 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0017] The main purpose of the present invention is to solve some deficiencies of traditional connection pools in distributed databases, including the inability to reuse connections between different databases of the same database instance, resulting in waste of resources and excessive number of connection pool threads, wasting application resources. system resources, reducing the serviceability of the application
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 Construction
[0056] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.
[0057]The main solution of the embodiment of the present invention is: receiving the connection request of the application program, determining the database connection group to which the connection request belongs from the preset database groups; and querying whether there is an idle connection in the database connection group; if the If there is an idle connection in the database connection group, use the idle connection of the database connection group to create the connection of the application program; if there is no idle connection in the database connection group, then query the other database connection groups in the database instance to which it belongs Whether there are idle connections. Effectively avoid resource waste caused by unreusable connections between different databases of the same database instance...
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 discloses a distribution type database connecting method, which comprises the following steps: determining a database connecting group, to which a connecting request belongs, from a preset database example group; querying whether idle connection exists in the database connecting group or not; if the idle connection exists in the database connecting group, establishing connection of application program by applying idle connection of the database connecting group; if idle connection does not exist in the database connecting group, querying whether idle connection exists in other database connecting groups which belong to the database example or not, and establishing connection of the application program by applying idle connection in other database connecting groups. The invention further discloses a distribution type database connecting device. According to the distribution type database connecting method and the distribution type database connecting device disclosed by the invention, multiplexing of idle connection of the database is realized, and connection pool threads can be asynchronously cleared up.
Description
technical field [0001] The invention relates to the technical field of databases, in particular to a distributed database connection method and device. Background technique [0002] The database connection is a very critical and limited expensive resource. If the database connection is opened and closed repeatedly, it will seriously waste a large amount of system resources of the database, and at the same time reduce the access efficiency of the database. An efficient management method for database connections can significantly reduce the consumption of system resources by the database, and at the same time improve the performance of the database and the application program that accesses the database. [0003] In database connection, database connection pool is a solution to reduce frequent opening and closing of connections by reusing database connections, thereby improving the performance of database operations. [0004] In the prior art, the steps of data connection incl...
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 Patents(China)
IPC IPC(8): G06F16/27
CPCG06F16/27
Inventor 王军伟宋威张学诚刘璟宇韩国忠何涛余倩
Owner 唯品会(广州)软件有限公司