WO2020019405A1

WO2020019405A1 - Database monitoring method, device and apparatus, and computer storage medium

Info

Publication number: WO2020019405A1
Application number: PCT/CN2018/103337
Authority: WO
Inventors: 马晓龙
Original assignee: 平安科技（深圳）有限公司
Priority date: 2018-07-26
Filing date: 2018-08-30
Publication date: 2020-01-30
Also published as: CN109726073A

Abstract

The present application provides a database monitoring method, comprising: receiving connection configuration information about a database to be monitored, and configuring, according to the connection configuration information, a connection object in a preset monitoring template set, so as to acquire a current monitoring template set; in said database, executing monitoring SQL statement of each monitoring sub-item in the current monitoring template set, and determining whether to trigger a database alarm instruction according to a monitoring result of each monitoring sub-item; and if the database alarm instruction is triggered, generating alarm information according to the monitoring result of each monitoring sub-item, and sending, in a preset alarm mode, the alarm information to an alarm contact group. The present application further provides a database monitoring device and apparatus, and a readable storage medium.

Description

Database monitoring method, device, equipment and readable storage medium Ranch

This application claims the priority of a Chinese patent application filed on July 26, 2018 with the Chinese Patent Office, application number 201810835443.0, and the invention name is "Database Monitoring Method, Device, Device, and Readable Storage Medium", the entire contents of which are incorporated by reference. Incorporated in the application.

Technical field

The present application relates to the technical field of database monitoring, and in particular, to a database monitoring method, device, device, and readable storage medium.

Background technique

During the operation of the database, real-time monitoring of the operating status of the database is required, including monitoring of database sessions, database logs, data file fragments, tablespaces, and user access. Real-time database operation abnormalities and resource consumption are discovered. It can quickly remind users when the database is abnormal.

At present, the monitoring method of PostgreSQL (object-relational database) is that operation and maintenance personnel use monitoring tools and configure monitoring policies to monitor the database. For databases used in different application systems, operation and maintenance personnel need to configure different monitoring strategies. Database monitoring is applicable. Sex is low.

Therefore, how to improve the applicability of database monitoring is an urgent problem to be solved.

Summary of the Invention

The main purpose of this application is to provide a database monitoring method, device, device and readable storage medium, which aims to improve the applicability and reliability of database monitoring.

To achieve the above objective, the present application provides a database monitoring method, which includes the following steps:

Receiving connection configuration information of a database to be monitored, and configuring connection objects in a preset monitoring template set according to the connection configuration information to obtain a current monitoring template set;

In the database to be monitored, execute a monitoring SQL statement of each monitoring sub-item in the current monitoring template set, and determine whether to trigger a database alarm instruction according to the monitoring result of each monitoring sub-item;

If a database alarm instruction is triggered, alarm information is generated according to the monitoring results of each monitoring sub-item, and the alarm information is sent to the alarm contact group according to a preset alarm method.

Optionally, according to the connection configuration information, configuring the connection objects in the preset monitoring template set to obtain the current monitoring template set includes:

Obtaining an identification field of each connection object in a preset monitoring template set, and obtaining corresponding configuration parameters of each connection object from the connection configuration information according to the identification field of each connection object;

Configure the connection objects in the preset monitoring template set according to the corresponding configuration parameters of each connection object to obtain the current monitoring template set.

Optionally, the step of determining whether to trigger a database alarm instruction according to the monitoring result of each monitoring sub-item includes:

Determining whether the monitoring result of at least one monitoring sub-item in each monitoring sub-item is in a preset monitoring result group;

If the monitoring result of at least one monitoring sub-item in each monitoring sub-item is in a preset monitoring result group, a database alarm command is triggered; otherwise, a data alarm command is not triggered.

Optionally, the step of generating alarm information according to the monitoring results of each monitoring sub-item includes:

Obtain a preset alarm information template, and fill the monitoring results of each monitoring sub-item into the preset alarm information template to generate alarm information.

Optionally, the step of filling the monitoring result of each monitoring sub-item into the preset alarm information template to generate alarm information includes:

Acquiring position information of each monitoring sub-item in the preset alarm information template;

Determine the filling position of each monitoring sub-item in the preset alarm information template according to the location information of each monitoring sub-item;

Fill the monitoring results of each monitoring sub-item to the corresponding filling position in the preset alarm information template.

Optionally, the database monitoring method further includes:

Obtain the currently available CPU resources and determine whether the execution mode of the database monitoring operation is a single task execution mode or a multi-task execution mode according to the currently available CPU resources;

If the execution mode of the database monitoring operation is a single task execution mode, the monitoring SQL statement of the monitoring sub-item is executed one time at a time;

If the execution mode of the database monitoring operation is a multi-tasking execution mode, the number of synchronously executed tasks is determined according to the currently available CPU resources, and the monitoring SQL statements of the corresponding number of monitoring sub-items are executed according to the number of synchronously executed tasks.

Optionally, the step of determining the number of synchronously executed pages according to the currently available CPU resources includes:

Obtain a pre-stored mapping table of currently available CPU resources and the number of synchronous execution tasks, and query the number of synchronous execution tasks corresponding to the currently available CPU resources from the mapping relationship table.

In addition, in order to achieve the foregoing object, the present application further provides a database monitoring apparatus, where the database monitoring apparatus includes:

A configuration module, configured to receive connection configuration information of a database to be monitored, and configure connection objects in a preset monitoring template set according to the connection configuration information to obtain a current monitoring template set;

An execution module, configured to execute, in the database to be monitored, a monitoring SQL statement of each monitoring sub-item in the current monitoring template set, and determine whether to trigger a database alarm instruction according to a monitoring result of each monitoring sub-item;

The alarm module is configured to generate alarm information according to the monitoring result of each monitoring sub-item if a database alarm instruction is triggered, and send the alarm information to an alarm contact group according to a preset alarm method.

In addition, in order to achieve the above-mentioned object, the present application further provides a database monitoring device. The database monitoring device includes a processor, a memory, and computer-readable instructions stored on the memory and executable by the processor. When the computer-readable instructions are executed by the processor, the steps of the database monitoring method as described above are implemented.

In addition, in order to achieve the foregoing object, the present application further provides a readable storage medium, where the readable storage medium stores computer-readable instructions, and when the computer-readable instructions are executed by a processor, the database as described above is implemented. Steps of the monitoring method.

This application provides a database monitoring method, device, device, and readable storage medium. This application receives connection configuration information of a database to be monitored, and configures connection objects in a preset monitoring template set according to the connection configuration information to obtain the current Monitoring template set; in the database to be monitored, execute the monitoring SQL statement of each monitoring sub-item in the current monitoring template set, and determine whether to trigger the database alarm command according to the monitoring results of each monitoring sub-item; if the database alarm command is triggered, according to each monitoring The monitoring results of the sub-items generate alarm information, and send the alarm information to the alarm contact group according to the preset alarm method. By setting a monitoring template set, the monitoring template set is used for monitoring the PostgreSQL database under each application system, and no operation and maintenance personnel are required. Configure the monitoring strategy. Simply configure the database connection object to realize the monitoring of the PostgreSQL database, effectively reduce the deployment difficulty of monitoring, and improve the applicability of database monitoring.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 is a schematic diagram of a hardware structure of a database monitoring device according to embodiments of the present application; FIG.

2 is a schematic flowchart of a first embodiment of a database monitoring method of the present application;

3 is a schematic flowchart of a second embodiment of a database monitoring method of the present application;

FIG. 4 is a schematic diagram of function modules of the first embodiment of the database monitoring apparatus of the present application.

The implementation, functional features and advantages of the purpose of this application will be further described with reference to the embodiments and the drawings.

detailed description

It should be understood that the specific embodiments described herein are only used to explain the application, and are not used to limit the application.

The database monitoring method according to the embodiment of the present application is mainly applied to a database monitoring device. The database monitoring device may be a PC (personal computer personal). computer), portable computers, mobile terminals and other devices with display and processing functions.

Referring to FIG. 1, FIG. 1 is a schematic diagram of a hardware structure of a database monitoring device involved in a solution according to an embodiment of the present application. In the embodiment of the present application, the database monitoring device may include a processor 1001 (for example, a central processor Central Processing Unit, CPU), communication bus 1002, user interface 1003, network interface 1004, and memory 1005. The communication bus 1002 is used to implement connection and communication between these components. The user interface 1003 may include a display and an input unit such as a keyboard. The network interface 1004 may optionally include a standard wired interface and a wireless interface. (Such as the WI-FI interface); the memory 1005 can be a high-speed RAM memory or a stable memory (non-volatile memory), such as a disk memory, the memory 1005 may optionally be a storage device independent of the foregoing processor 1001. Those skilled in the art can understand that the hardware structure shown in FIG. 1 does not constitute a limitation on the present application, and may include more or fewer components than shown in the figure, or combine some components, or arrange different components.

With continued reference to FIG. 1, the memory 1005 as a readable storage medium in FIG. 1 may include an operating system, a network communication module, and computer-readable instructions. In FIG. 1, the network communication module is mainly used to connect to a server and perform data communication with the server; and the processor 1001 can call the computer-readable instructions stored in the memory 1005 and execute the database monitoring method provided in the embodiment of the present application.

The embodiment of the present application provides a database monitoring method.

Referring to FIG. 2, FIG. 2 is a schematic flowchart of a first embodiment of a database monitoring method of the present application.

In this embodiment, the database monitoring method is implemented by a database monitoring device. The database monitoring device may be a terminal device such as a PC, a palmtop computer, and a tablet computer. The device shown in FIG. 1 may be selected. The database monitoring method includes the following steps: :

Step S101: Receive connection configuration information of a database to be monitored, and configure connection objects in a preset monitoring template set according to the connection configuration information to obtain a current monitoring template set;

Step S102: In the database to be monitored, execute a monitoring SQL statement of each monitoring item in the current monitoring template set, and determine whether to trigger a database alarm instruction according to the monitoring result of each monitoring item;

In step S103, if a database alarm instruction is triggered, alarm information is generated according to the monitoring results of each monitoring sub-item, and the alarm information is sent to the alarm contact group according to a preset alarm method.

At present, the monitoring method of the PostgreSQL database is that the operation and maintenance personnel use monitoring tools and configure monitoring policies to monitor the database. For the databases used in different application systems, the operation and maintenance personnel need to configure different monitoring strategies. The applicability and reliability of database monitoring are relatively low. Low, affecting the monitoring efficiency of the database. In view of the above problems, a database monitoring method is proposed in this embodiment. The specific steps of the database monitoring method are detailed below:

In this embodiment, when the configuration instruction of the monitoring data set triggered by the operation and maintenance personnel is detected, the device displays a connection object configuration interface, and receives the connection configuration information of the database to be monitored input by the operation and maintenance personnel based on the connection object configuration interface. The connection configuration information includes but is not limited to the system to which the database to be monitored belongs, the system's group, the department or subsidiary of the system, the alarm contact group, the PostgreSQL database host IP, the PostgreSQL database host port, the database name, the database login user, and the database. Login password, the connection object configuration interface displays the object name and parameter description, and the parameter description of the system to which the database to be monitored belongs, the system's group, the department or subsidiary of the system, and the alarm contact group are alarm auxiliary information, and the PostgreSQL database host The parameters of IP, PostgreSQL database host port, database name, database login user, and database login password are for monitoring database configuration information.

The device receives the connection configuration information of the database to be monitored, and configures the connection objects in the preset monitoring template set according to the connection configuration information to obtain the current monitoring template set, that is, the system to which the database to be monitored belongs in the preset monitoring template set, Configure the system group, system department or subsidiary, alarm contact group, PostgreSQL database host IP, PostgreSQL database host port, database name, database login user, and database login password.

The preset monitoring template set includes, but is not limited to, the monitoring SQL statement of the database availability monitoring sub-item, the monitoring SQL statement of the application SQL execution efficiency monitoring sub-item, the monitoring SQL statement of the background job execution monitoring sub-item, and the database connection number monitoring sub-item. The item's monitoring SQL statement and the database lock monitoring child item's monitoring SQL statement. The monitoring SQL statement of the database availability monitoring sub-item is used to monitor whether the database can receive external requests, and the SQL execution efficiency monitoring sub-item is used to determine whether there are applications with execution efficiency lower than the preset efficiency through database snapshot information. SQL and used to obtain the current execution time of the application SQL through the pg_stat_activity view to determine whether there is any application SQL whose current execution time exceeds the specified time; the monitoring SQL statement of the background job execution monitoring sub-item is used to create the function quartzchk in the PostgreSQL database, Then call the function select * from quartzchk queries the background job execution status; the monitoring SQL statement of the database connection number monitoring sub-item is used to monitor whether the current total number of connections in the database accounts for the maximum allowable number of connections in the database exceeds a predetermined threshold; the monitoring SQL statement of the database lock monitoring sub-item is used to monitor Whether a database lock occurs in the database, and when a database lock occurs, perform a related query through the pg_locks and pg_stat_activity views to refine the lock status of each SQL statement.

Specifically, the device obtains an identification field of each connection object in a preset monitoring template set, and obtains corresponding configuration parameters of each connection object from the connection configuration information according to the identification field of each connection object, that is, the configuration parameters in the connection configuration information and The identification fields have a corresponding relationship. The corresponding configuration parameters of each connection object can be obtained through the identification fields of each connection object, and then according to the corresponding configuration parameters of each connection object, the connection objects in the preset monitoring template set are configured to obtain the current The monitoring template set, that is, the specific parameters of each connection object in the preset monitoring template set is configured as corresponding configuration parameters.

In this embodiment, after the connection objects of the database to be monitored in the preset template set are configured, the device executes the monitoring SQL statement of each monitoring sub-item in the current monitoring template set in the database to be monitored, and according to the monitoring results of each monitoring sub-item Determines whether a database alert command is triggered. Specifically, the monitoring SQL statement of the database availability monitoring sub-item is executed to monitor whether the database can receive external requests. If the database cannot receive external requests, the monitoring result is an abnormal database access. If the database is monitored, external data can be received. Request, the monitoring result is that the database access is normal;

Monitor SQL statements of the application SQL execution efficiency monitoring sub-item, monitor database snapshot information, count the application SQL execution in the most recent specified number of days, determine whether there is application SQL with an execution efficiency lower than the preset efficiency, and obtain the application SQL through the pg_stat_activity view The current execution time determines whether there is any application SQL whose current execution time exceeds the specified duration. If there is an application SQL whose execution efficiency is lower than the preset efficiency or an application SQL whose current execution time exceeds the specified time, the monitoring result is that the execution efficiency is lower than the Efficient application SQL or application SQL whose current execution time exceeds a specified time, that is, SQL execution efficiency is abnormal. If the execution efficiency of each application SQL is higher than or equal to a preset efficiency, and the current execution time of each application SQL does not exceed the specified Time, the monitoring result is that the SQL execution efficiency is normal;

Execute the monitoring SQL statements of the background job execution monitoring sub-item, create a function quartzchk in the PostgreSQL database, Then call the function select * from quartzchk queries the background job execution and monitors the results for the background role execution; among them, the function quartzchk is created first, and then the function select * from is called The quartzchk method can be used to query the execution of background jobs, which can avoid the SQL statement error when monitoring the system without background jobs and improve the applicability;

Execute the monitoring SQL statement of the database connection number monitoring sub-item to monitor whether the proportion of the current total number of connections in the database to the maximum allowed number of connections in the database exceeds a preset threshold. If the proportion of the total number of current connections in the database to the maximum allowed number of connections in the database exceeds a preset threshold , The monitoring result is the number of connections for each user, and the database is overloaded. If the proportion of the current total number of connections in the database to the maximum allowed number of connections in the database does not exceed a predetermined threshold, the monitoring result is that the database is not overloaded;

Execute the monitoring SQL statement of the database lock monitoring sub-item to monitor whether there is a lock status SQL statement in the database. If there is a lock status SQL statement in the database, use the pg_locks and pg_stat_activity views to perform related queries to refine the lock status of the SQL statement. The monitoring results include the PID of the process that generated the lock, the lock mode, and the transaction information of the lock. If the database does not have SQL statements in the lock state, no monitoring results are generated. Among them, the lock mode includes AccessShareLock, RowShareLock, RowExclusiveLock, ShareUpdateExclusiveLock, ShareLock, ShareRowExclusiveLock , ExclusiveLock and AccessExclusiveLock.

Specifically, the device determines whether the monitoring result of at least one monitoring sub-item in each monitoring sub-item is located in a preset monitoring result group, and if the monitoring result of at least one monitoring sub-item in each monitoring sub-item is located in a preset monitoring result group , The database alarm instruction is triggered, otherwise the data alarm instruction is not triggered, that is, the monitoring results of each monitoring sub-item are not in the preset monitoring result group, and the data alarm instruction is not triggered. It should be noted that the above-mentioned preset monitoring result group may be set by a person skilled in the art based on actual conditions, which is not specifically limited in this embodiment.

In this embodiment, if a database alarm instruction is triggered, alarm information is generated according to the monitoring results of each monitoring sub-item, and the alarm information is sent to the alarm contact group according to a preset alarm method. Specifically, a preset alarm information template is obtained, and the monitoring result of each monitoring sub-item is filled into the preset alarm information template to generate alarm information, that is, the information of each monitoring sub-item in the preset alarm information template is obtained. Location information, and according to the location information of each monitoring sub-item, determine the filling position of each monitoring sub-item in the preset alarm information template, and fill the monitoring result of each monitoring sub-item with the corresponding affiliation in the preset alarm information template Fill in the position to generate alarm information. Among them, the alarm information includes, but is not limited to, the system to which the system belongs, the group to which the system belongs, the department or subsidiary of the system, the alarm contact group, and abnormal information, and the abnormal information includes, but is not limited to, database disconnection, inefficient application SQL, background SQL statements for job execution and lock status. The alarm methods include, but are not limited to, email alerts, SMS alerts, and phone alerts.

In this embodiment, the application receives the connection configuration information of the database to be monitored, and configures the connection objects in the preset monitoring template set according to the connection configuration information to obtain the current monitoring template set. In the database to be monitored, the current monitoring is performed. The template focuses on the monitoring SQL statements of each monitoring sub-item, and determines whether to trigger a database alarm command based on the monitoring results of each monitoring sub-item. If a database alarm command is triggered, an alarm message is generated based on the monitoring results of each monitoring sub-item, and according to the preset The alarm method sends alarm information to the alarm contact group. By setting a monitoring template set, the monitoring template set is used for monitoring the PostgreSQL database under each application system. There is no need for operation and maintenance personnel to configure the monitoring strategy. You only need to configure the database connection object. The monitoring of the PostgreSQL database can be realized, the deployment difficulty of the monitoring is effectively reduced, and the applicability of the database monitoring is improved.

Further, referring to FIG. 3, based on the above-mentioned first embodiment, a second embodiment of the database monitoring method of the present application is proposed. The difference from the foregoing embodiment is that the database monitoring method further includes:

Step 104: Obtain the currently available CPU resources, and determine whether the execution mode of the database monitoring operation is a single-task execution mode or a multi-task execution mode according to the currently available CPU resources.

In this embodiment, the device obtains the currently available CPU resources, and determines whether the execution method of the database monitoring operation is a single-task execution mode or a multi-task execution mode according to the currently available CPU resources, and specifically determines whether the currently available CPU resources exceed a preset CPU Resources, if the currently available CPU resources exceed the preset CPU resources, you can determine that the database monitoring operation is performed in a multi-tasking execution mode, and if the currently available CPU resources do not exceed the preset CPU resources, you can determine that the database monitoring operation is performed as Single task execution.

Step 105: If the execution mode of the database monitoring operation is a multi-task execution mode, determine the number of synchronous execution tasks according to the currently available CPU resources, and execute the monitoring SQL statements of the corresponding number of monitoring sub-items according to the number of synchronous execution tasks.

In this embodiment, if the execution mode of the database monitoring operation is a multi-tasking execution mode, the number of synchronous execution tasks is determined according to the currently available CPU resources, that is, a pre-stored mapping table of the currently available CPU resources and the number of synchronous execution pages is obtained, and In the mapping relationship table, query the number of synchronous execution tasks corresponding to the currently available CPU resources, and execute the monitoring SQL statements of the corresponding number of monitoring sub-items according to the number of synchronous execution tasks, that is, the device performs the preset execution order in the database to be monitored Execute the monitoring SQL statements of the monitoring sub-items corresponding to the number of synchronously executed tasks. If the database monitoring operation is performed in a single task, the monitoring SQL statements of the monitoring sub-items are executed one at a time, that is, the device executes the monitoring sub-items of the current monitoring template set in the database to be monitored in the preset execution order. Monitor SQL statements. It should be noted that the foregoing preset execution order may be set by a person skilled in the art based on actual conditions, and this embodiment does not specifically limit this.

The preset CPU resources can be set according to the total CPU resources, or set by the user according to specific needs. When the CPU resources do not exceed the preset CPU resources, the number of synchronous pages that can be executed simultaneously can be determined according to the mapping relationship between the available CPU resources and the number of synchronized pages. For example, in the mapping relationship, when the available CPU resources are less than A, the corresponding The number of simultaneous pages that are executed simultaneously is 2; when the available CPU resources are greater than or equal to A and less than B, the number of simultaneous pages that can be executed simultaneously is 3; when the available CPU resources are greater than or equal to B and less than C, the corresponding can be executed simultaneously The number of synchronized pages is 4, where A <B <C.

In this embodiment, the present application determines the monitoring SQL statements of the monitoring sub-items that are executed synchronously based on the currently available CPU resources of the device. The device can simultaneously execute the monitoring SQL statements of multiple monitoring sub-items, effectively improving the database monitoring efficiency.

In addition, an embodiment of the present application further provides a database monitoring device.

Referring to FIG. 4, FIG. 4 is a schematic diagram of functional modules of a first embodiment of a database monitoring apparatus of the present application.

The database monitoring device of the present application is a virtual device, which is stored in the memory 1005 of the database monitoring device shown in FIG. 1 and is used to implement all the functions of the computer-readable instructions; receiving the connection configuration information of the database to be monitored, and according to the connection configuration information To configure the connection objects in the preset monitoring template set to obtain the current monitoring template set; in the database to be monitored, execute a monitoring SQL statement of each monitoring sub-item in the current monitoring template set, and according to each monitoring sub-item The monitoring result determines whether a database alarm instruction is triggered; if the database alarm instruction is triggered, alarm information is generated according to the monitoring results of each monitoring sub-item, and the alarm information is sent to the alarm contact group according to a preset alarm method.

Specifically, in this embodiment, the database monitoring apparatus includes:

A configuration module 101 is configured to receive connection configuration information of a database to be monitored, and configure connection objects in a preset monitoring template set according to the connection configuration information to obtain a current monitoring template set;

The execution module 102 is configured to execute, in the database to be monitored, a monitoring SQL statement of each monitoring sub-item in the current monitoring template set, and determine whether to trigger a database alarm instruction according to a monitoring result of each monitoring sub-item;

The alarm module 103 is configured to generate alarm information according to the monitoring result of each monitoring sub-item if a database alarm instruction is triggered, and send the alarm information to an alarm contact group according to a preset alarm method.

Further, the configuration module 101 is further configured to:

Further, the execution module 102 is further configured to:

Further, the alarm module 103 is further configured to:

Further, the database monitoring device further includes:

A determining module for obtaining the currently available CPU resources and determining whether the execution mode of the database monitoring operation is a single-task execution mode or a multi-task execution mode according to the currently available CPU resources;

The execution module 102 is further configured to execute a monitoring SQL statement of a monitoring sub-item each time if the execution mode of the database monitoring operation is a single task execution mode;

The execution module 102 is further configured to: if the database monitoring operation is performed in a multi-tasking mode, determine the number of tasks to be executed synchronously according to the currently available CPU resources, and execute a corresponding number of monitoring sub-items according to the number of tasks executed synchronously Monitor SQL statements.

Further, the execution module 102 is further configured to:

The function implementation of each module in the above-mentioned database monitoring apparatus corresponds to each step in the above-mentioned embodiment of the database monitoring method, and the functions and implementation processes thereof are not repeated here one by one.

In addition, an embodiment of the present application further provides a readable storage medium, and the readable storage medium may be a non-volatile readable storage medium.

Computer-readable instructions are stored on the readable storage medium of this application, and when the computer-readable instructions are executed by a processor, the steps of the database monitoring method as described above are implemented.

For the method implemented when the computer-readable instructions are executed, reference may be made to various embodiments of the database monitoring method of the present application, and details are not described herein again.

It should be noted that, in this article, the terms "including", "including" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or system including a series of elements includes not only those elements, It also includes other elements not explicitly listed, or elements inherent to such a process, method, article, or system. Without more restrictions, an element limited by the sentence "including a ..." does not exclude the existence of other identical elements in the process, method, article, or system that includes the element.

The above-mentioned serial numbers of the embodiments of the present application are merely for description, and do not represent the superiority or inferiority of the embodiments.

Through the description of the above embodiments, those skilled in the art can clearly understand that the methods in the above embodiments can be implemented by means of software plus a necessary universal hardware platform, and of course, also by hardware, but in many cases the former is better. Implementation. Based on such an understanding, the technical solution of this application that is essentially or contributes to the existing technology can be embodied in the form of a software product. The computer software product is stored in a storage medium (such as ROM / RAM) as described above. , Magnetic disk, optical disc), including a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to execute the methods described in the embodiments of the present application.

The above are only preferred embodiments of the present application, and thus do not limit the patent scope of the present application. Any equivalent structure or equivalent process transformation made by using the description and drawings of the present application, or directly or indirectly used in other related technical fields Are included in the scope of patent protection of this application.

Claims

A database monitoring method, characterized in that the database monitoring method includes the following steps:

Receiving connection configuration information of a database to be monitored, and configuring connection objects in a preset monitoring template set according to the connection configuration information to obtain a current monitoring template set;

In the database to be monitored, execute a monitoring SQL statement of each monitoring sub-item in the current monitoring template set, and determine whether to trigger a database alarm instruction according to the monitoring result of each monitoring sub-item;

If a database alarm instruction is triggered, alarm information is generated according to the monitoring results of each monitoring sub-item, and the alarm information is sent to the alarm contact group according to a preset alarm method.
The database monitoring method according to claim 1, wherein the step of configuring the connection objects in the preset monitoring template set to obtain the current monitoring template set according to the connection configuration information comprises:

Obtaining an identification field of each connection object in a preset monitoring template set, and obtaining corresponding configuration parameters of each connection object from the connection configuration information according to the identification field of each connection object;

Configure the connection objects in the preset monitoring template set according to the corresponding configuration parameters of each connection object to obtain the current monitoring template set.
The database monitoring method according to claim 1, wherein the step of determining whether to trigger a database alarm instruction according to the monitoring results of each monitoring sub-item comprises:

Determining whether the monitoring result of at least one monitoring sub-item in each monitoring sub-item is in a preset monitoring result group;

If the monitoring result of at least one monitoring sub-item in each monitoring sub-item is in a preset monitoring result group, a database alarm command is triggered; otherwise, a data alarm command is not triggered.
The database monitoring method according to claim 1, wherein the step of generating alarm information according to a monitoring result of each monitoring sub-item comprises:

Obtain a preset alarm information template, and fill the monitoring results of each monitoring sub-item into the preset alarm information template to generate alarm information.
The database monitoring method according to claim 4, wherein the step of filling the monitoring result of each monitoring sub-item into the preset alarm information template to generate the alarm information comprises:

Acquiring position information of each monitoring sub-item in the preset alarm information template;

Determine the filling position of each monitoring sub-item in the preset alarm information template according to the location information of each monitoring sub-item;

Fill the monitoring results of each monitoring sub-item to the corresponding filling position in the preset alarm information template.
The database monitoring method according to claim 1, wherein the database monitoring method further comprises:

Obtain the currently available CPU resources, and determine whether the execution mode of the database monitoring operation is a multi-tasking execution mode based on the currently available CPU resources;

If the execution mode of the database monitoring operation is a multi-tasking execution mode, the number of synchronously executed tasks is determined according to the currently available CPU resources, and the monitoring SQL statements of the corresponding number of monitoring sub-items are executed according to the number of synchronously executed tasks.
The database monitoring method according to claim 6, wherein the step of determining the number of synchronously executed pages according to the currently available CPU resources comprises:

Obtain a pre-stored mapping table of currently available CPU resources and the number of synchronous execution tasks, and query the number of synchronous execution tasks corresponding to the currently available CPU resources from the mapping relationship table.
A database monitoring device, characterized in that the database monitoring device includes:

A configuration module, configured to receive connection configuration information of a database to be monitored, and configure connection objects in a preset monitoring template set according to the connection configuration information to obtain a current monitoring template set;

An execution module, configured to execute, in the database to be monitored, a monitoring SQL statement of each monitoring sub-item in the current monitoring template set, and determine whether to trigger a database alarm instruction according to a monitoring result of each monitoring sub-item;

The alarm module is configured to generate alarm information according to the monitoring result of each monitoring sub-item if a database alarm instruction is triggered, and send the alarm information to an alarm contact group according to a preset alarm method.
The database monitoring device according to claim 8, wherein the configuration module is further configured to:

Obtaining an identification field of each connection object in a preset monitoring template set, and obtaining corresponding configuration parameters of each connection object from the connection configuration information according to the identification field of each connection object;

Configure the connection objects in the preset monitoring template set according to the corresponding configuration parameters of each connection object to obtain the current monitoring template set.
The database monitoring device according to claim 8, wherein the execution module is further configured to:

Determining whether the monitoring result of at least one monitoring sub-item in each monitoring sub-item is in a preset monitoring result group;

If the monitoring result of at least one monitoring sub-item in each monitoring sub-item is in a preset monitoring result group, a database alarm command is triggered; otherwise, a data alarm command is not triggered.
The database monitoring device according to claim 8, wherein the alarm module is further configured to:

Obtain a preset alarm information template, and fill the monitoring results of each monitoring sub-item into the preset alarm information template to generate alarm information.
The database monitoring device according to claim 11, wherein the alarm module is further configured to:

Acquiring position information of each monitoring sub-item in the preset alarm information template;

Determine the filling position of each monitoring sub-item in the preset alarm information template according to the location information of each monitoring sub-item;

Fill the monitoring results of each monitoring sub-item to the corresponding filling position in the preset alarm information template.
A database monitoring device, characterized in that the database monitoring device includes a processor, a memory, and computer-readable instructions stored on the memory and executable by the processor, wherein the computer-readable instructions are When the processor executes, the following steps are implemented:

Receiving connection configuration information of a database to be monitored, and configuring connection objects in a preset monitoring template set according to the connection configuration information to obtain a current monitoring template set;

In the database to be monitored, execute a monitoring SQL statement of each monitoring sub-item in the current monitoring template set, and determine whether to trigger a database alarm instruction according to the monitoring result of each monitoring sub-item;

If a database alarm instruction is triggered, alarm information is generated according to the monitoring results of each monitoring sub-item, and the alarm information is sent to the alarm contact group according to a preset alarm method.
The database monitoring device according to claim 13, wherein when the computer-readable instructions are executed by the processor, the following steps are further implemented:

Obtaining an identification field of each connection object in a preset monitoring template set, and obtaining corresponding configuration parameters of each connection object from the connection configuration information according to the identification field of each connection object;

Configure the connection objects in the preset monitoring template set according to the corresponding configuration parameters of each connection object to obtain the current monitoring template set.
The database monitoring device according to claim 13, wherein when the computer-readable instructions are executed by the processor, the following steps are further implemented:

Determining whether the monitoring result of at least one monitoring sub-item in each monitoring sub-item is in a preset monitoring result group;

If the monitoring result of at least one monitoring sub-item in each monitoring sub-item is in a preset monitoring result group, a database alarm command is triggered; otherwise, a data alarm command is not triggered.
The database monitoring device according to claim 13, wherein when the computer-readable instructions are executed by the processor, the following steps are further implemented:

Obtain a preset alarm information template, and fill the monitoring results of each monitoring sub-item into the preset alarm information template to generate alarm information.
A readable storage medium is characterized in that computer-readable instructions are stored on the readable storage medium, and when the computer-readable instructions are executed by a processor, the following steps are implemented:

Receiving connection configuration information of a database to be monitored, and configuring connection objects in a preset monitoring template set according to the connection configuration information to obtain a current monitoring template set;

In the database to be monitored, execute a monitoring SQL statement of each monitoring sub-item in the current monitoring template set, and determine whether to trigger a database alarm instruction according to the monitoring result of each monitoring sub-item;

If a database alarm instruction is triggered, alarm information is generated according to the monitoring results of each monitoring sub-item, and the alarm information is sent to the alarm contact group according to a preset alarm method.
The readable storage medium of claim 17, wherein when the computer-readable instructions are executed by the processor, the following steps are further implemented:

Obtaining an identification field of each connection object in a preset monitoring template set, and obtaining corresponding configuration parameters of each connection object from the connection configuration information according to the identification field of each connection object;

Configure the connection objects in the preset monitoring template set according to the corresponding configuration parameters of each connection object to obtain the current monitoring template set.
The readable storage medium of claim 17, wherein when the computer-readable instructions are executed by the processor, the following steps are further implemented:

Determining whether the monitoring result of at least one monitoring sub-item in each monitoring sub-item is in a preset monitoring result group;

If the monitoring result of at least one monitoring sub-item in each monitoring sub-item is in a preset monitoring result group, a database alarm command is triggered; otherwise, a data alarm command is not triggered.
The readable storage medium of claim 17, wherein when the computer-readable instructions are executed by the processor, the following steps are further implemented:

Obtain a preset alarm information template, and fill the monitoring results of each monitoring sub-item into the preset alarm information template to generate alarm information.