Database connection control method and device, computer equipment and readable storage medium

Abstract

The invention relates to the technical field of databases, and provides a database connection control method and device, computer equipment and a readable storage medium, and the method comprises the steps: obtaining service identification information of a target service; according to the service identification information, first configuration information of the target service is obtained, and the first configuration information comprises a first connection number upper limit and a connection number distribution strategy; based on a connection number distribution strategy, determining a second connection number upper limit corresponding to each instance in the target service according to the number of instances in the target service and the first connection number upper limit; the second connection number upper limit corresponding to each instance in the target service is sent to the target service, the second connection number upper limit is used for indicating the connection number of the instance connection database, the flexibility of setting the service and the connection number upper limit of the instance is improved, and therefore disordered expansion of the database connection number is prevented. In addition, the invention also relates to a block chain technology, and the configuration information can be stored in a block chain.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a database connection control method, device, computer equipment and readable storage medium. Background technique [0002] With the development of mobile Internet, more and more users join the mobile Internet wave. With the increase of users, more and more user data are generated, and the data is generally stored in the database. Commonly used relational database management systems include MYSQL, ORACLE, etc. The more database applications, such as more user data queries or user data writes, the more database connections will be consumed. If not controlled, the number of connections will exceed the upper limit of the database, resulting in abnormal services. Although there are database connection pool technologies that can Manage the database connection of the service, but there are still multiple services that connect to the same database, the upper limit of the nu...

AI Technical Summary

Problems solved by technology

The more database applications, such as more user data queries or user data writes, the more database connections will be consumed. If not controlled, the number of connections will exceed the upper limit of the database, resulting in abnormal services. Although there are database connection pool technologies that can Manage the database connection of the service, but there are still multiple services that connect to the same database, the upper limit of the number of individual connections for each service cannot be limited, and when multiple instances of the same service are deployed, the upper limit of the number of connections for a certain instance cannot be individually set technical problem

Images