Method and device for monitoring database connection storm under large-scale micro-service architecture

Abstract

The embodiment of the invention provides a database connection storm monitoring method and device, and the method comprises the steps: inputting an obtained active database connection number into a preset connection pool configuration algorithm model, and outputting database connection pool parameters; and configuring the database connection pool parameters to each micro-service instance. According to the database connection storm monitoring method and device provided by the embodiment of the invention, the database connection pool parameters are calculated by utilizing the preset connection pool configuration algorithm model according to the obtained active database connection number, and the occurrence probability of the database connection storm is reduced through the database connection pool in each micro-service instance. Moreover, manual participation is not needed, horizontal expansion can be realized, multiple sets of micro-service systems are controlled at the same time, the workload is effectively reduced, and the working efficiency is improved.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of database monitoring, in particular to a method and device for monitoring database connection storms under a large-scale micro-service architecture. Background technique [0002] Microservices are a form of system architecture in which a large complex software application consists of one or more microservices. Each microservice in the system can be deployed independently, and each microservice is loosely coupled, and the same microservice usually deploys multiple instances. Each microservice is only focused on doing one task and doing it well. In all cases, each task represents a small business capability. [0003] With the development of microservices and cloud computing, the horizontal expansion of the system application layer has become easier and easier, but there are still many difficulties in the horizontal expansion of relational databases (for example, ORACLE), so many m...

AI Technical Summary

Problems solved by technology

[0006] However, there is a large error in the database connection pool parameter configuration method in the prior art, and it is still easy to cause a connection storm under extreme conditions; manual management of the database connection pool parameter configuration is heavy and difficult; When the storm occurs, the system cannot monitor in time to eliminate the connection storm

Images