WO2020000676A1

WO2020000676A1 - Database automatic alarming method and apparatus, terminal device, and readable storage medium

Info

Publication number: WO2020000676A1
Application number: PCT/CN2018/105555
Authority: WO
Inventors: 孙泽祥; 梁海安
Original assignee: 平安科技（深圳）有限公司
Priority date: 2018-06-27
Filing date: 2018-09-13
Publication date: 2020-01-02
Also published as: CN109086182A; CN109086182B

Abstract

The solution is applicable to the technical field of data processing. Provided are a database automatic alarming method and apparatus, a terminal device, and a computer readable storage medium. The method comprises: obtaining configuration information which is related to a target database and comprises identification information and an alarm target; constructing a configuration management database (CMDB) according to the configuration information, wherein the CMDB corresponds to a configuration item, the identification information is stored in the configuration item, and the alarm target is stored in a configuration property corresponding to the configuration item; obtaining a current parameter, containing characteristic information, of the target database; when the current parameter meets a preset condition, generating alarm information containing the current parameter; searching, in the CMDB, for the configuration item corresponding to the identification information that coincides with the characteristic information in the alarm information by executing a preset script file, obtaining a corresponding alarm target from the searched configuration property of the configuration item, and sending the alarm information to the obtained alarm target. The solution improves configuration efficiency of a database alarming mechanism and the convenience of changing the alarm target.

Description

Method, device, terminal equipment and readable storage medium for automatic alarm of database

This application claims priority from a Chinese patent application filed on June 27, 2018 with the Chinese Patent Office, application number 201810675189.2 and invention name "Database Automatic Alarm Method and Terminal Device", the entire contents of which are incorporated herein by reference in.

Technical field

The present application belongs to the technical field of data processing, and particularly relates to a method, a device, a terminal device, and a computer-readable storage medium for automatic alarming of a database.

Background technique

A database is a warehouse that organizes, stores, and manages data according to the data structure. In actual business scenarios, the database is monitored to ensure the security of the database operation. When a problem occurs in the database, an alert needs to be sent to the designated object to serve as a reminder. For example, after monitoring the performance parameters of the database exceeding the threshold, the performance parameters are sent to the corresponding operation and maintenance personnel.

In the prior art, an alarm process is usually configured inside the monitored database. As business scenarios evolve toward complexity, multiple databases often exist, and different people need to manage different databases. If the alarm mechanism of the database is configured according to the existing technology, the alarm mechanism needs to be configured in each database, the configuration efficiency is low, and after the configuration is completed, if the alarm object of a database needs to be changed, you need to find the The database finds the configuration code inside the database and changes the configuration code, so the configuration of the database alarm mechanism in the prior art is inefficient and inconvenient to change.

technical problem

In view of this, the embodiments of the present application provide a method, an apparatus, a terminal device, and a computer-readable storage medium for automatic database alarm, so as to solve the problem of low configuration efficiency of the database alarm mechanism in the prior art and inconvenience of changing the alarm target.

Technical solutions

A first aspect of the embodiments of the present application provides a method for automatically alarming a database, including:

Acquiring configuration information related to a target database to which an alarm is to be set, the configuration information including identification information of the target database and an alarm target corresponding to the target database;

Build a configuration management database CMDB according to the configuration information, wherein the CMDB corresponds to a configuration item, the identification information is stored in the configuration item, and the alarm target is stored in a configuration attribute corresponding to the configuration item ;

Acquiring current parameters of the target database, where the current parameters include characteristic information of the target database, operations per second, and current traffic, and the characteristic information includes a name of the target database;

When the current parameter meets a preset condition, generating alarm information including the current parameter;

Find a configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information by executing a preset script file, and obtain a corresponding alarm target from the configuration attribute of the found configuration item, And sending the alarm information to the acquired alarm target.

A second aspect of the embodiments of the present application provides a device for automatic database alarm, which may include a unit for implementing the steps of the above method for automatic database alarm.

A third aspect of the embodiments of the present application provides a terminal device including a memory and a processor. The memory stores computer-readable instructions executable on the processor, and the processor executes the computer-readable instructions. The steps of the method for realizing the automatic alarm of the database when the instruction is read.

A fourth aspect of the embodiments of the present application provides a computer-readable storage medium, where the computer-readable storage medium stores computer-readable instructions, and when the computer-readable instructions are executed by a processor, a method for implementing the above-mentioned database automatic alarm A step of.

Beneficial effect

The embodiment of the present application first obtains configuration information including identification information and alarm targets related to the target database to be set for alarms, and builds a configuration management database CMDB according to the configuration information. After the construction is completed, identification information is stored in the configuration items of the CMDB. An alarm target is stored in the configuration property corresponding to the item, and then the current parameters of the target database are obtained and alarm information is generated. The script file is searched to find the configuration item corresponding to the alarm information in the CMDB, and the corresponding configuration item is found from the found configuration item. The alarm target is obtained in the configuration properties and the alarm information is sent to the alarm target. In the embodiment of the present application, the configuration items and configuration properties are centrally configured in the CMDB. Compared with setting the alarm target separately in the target database, it is easier to set and change the alarm when needed It is not necessary to find the configuration file of the target database and change it when it is targeted. Instead, it can be changed directly in the CMDB, which realizes the automatic alarm of the database and improves the configuration efficiency and change efficiency of the database alarm mechanism.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 is a flowchart of a method for automatically alarming a database in Embodiment 1 of the present application;

2 is a flowchart of a method for automatically alarming a database in a second embodiment of the present application;

3 is a flowchart of a method for automatically alarming a database in a third embodiment of the present application;

4 is a flowchart of a method for automatically alarming a database in a fourth embodiment of the present application;

5 is a flowchart of a method for automatically alarming a database in a fifth embodiment of the present application;

6 is a structural block diagram of a database automatic alarm device in Embodiment 6 of the present application;

FIG. 7 is a schematic diagram of a terminal device in Embodiment 7 of the present application.

Embodiments of the invention

In order to have a clearer understanding of the technical features, objects, and effects of the present application, specific implementations of the present application will now be described in detail with reference to the drawings.

Please refer to FIG. 1. FIG. 1 is a flowchart of a method for automatically alarming a database provided by an embodiment of the present application. As shown in Figure 1, the method includes the following steps:

S101: Acquire configuration information related to a target database to which an alarm is to be set, where the configuration information includes identification information of the target database and an alarm target corresponding to the target database.

In the embodiment of the present application, first, configuration information related to the target database is obtained. The configuration information includes identification information of the target database and an alarm target corresponding to the target database. The target database refers to a database to be set for an alarm. The target database may be One or more; identification information refers to the information related to the target database used to identify the target database, such as the name or address of the target database; alert target refers to the object to be alerted, the format can be the target email account number or the target mobile phone number Wait. It is worth mentioning that a storage address can be specified in advance and configuration information can be obtained periodically from the storage address.

S102: Construct a configuration management database CMDB according to the configuration information, wherein the CMDB corresponds to a configuration item, the identification information is stored in the configuration item, and the configuration attribute corresponding to the configuration item stores the Alarm target.

After obtaining the configuration information, a Configuration Management Database (CMDB) is constructed based on the configuration information. CMDB is the core of the Information Technology Infrastructure Library (ITIL). Compared to traditional databases that focus on the physical storage of information, such as Oracle databases, CMDB focuses more on the management of stored information, including integration, Recording and updating are applicable to scenarios where configuration information is frequently changed, so they can be applied to the embodiments of this application. The specific process of storing the configuration information in the CMDB is to store the identification information in the configuration information to the configuration item in the CMDB, and store the alarm target in the configuration information to the configuration attribute corresponding to the above configuration item in the CMDB, in the CMDB The configuration items are used to indicate the resources to be managed by the CMDB, and the configuration attributes are used to describe the configuration items.

Optionally, the configuration information is obtained through a preset information system. In the embodiment of the present application, the CMDB can be connected to a preset information system in advance, and the configuration information can be entered into the information system, and the information system can be set in advance at regular intervals or when the configuration information is updated. The mechanism for sending configuration information to the CMDB to achieve automatic acquisition of configuration information by the CMDB. In addition, the communication between the CMDB and the information system can be achieved through the SaltStack tool.

S103: Acquire current parameters of the target database, where the current parameters include characteristic information of the target database, operations per second, and current traffic, and the characteristic information includes a name of the target database.

After the CMDB is constructed, the target database includes feature information, Operation Per Second (OPS), and current parameters of the current traffic. The current parameters can be obtained by monitoring the target database. Among them, the feature information and identification information The format is the same, that is, if the format of the identification information is a name, the format of the characteristic information is also a name; the number of operations per second refers to the number of additions, deletions, changes, and query operations to the target database per second; the current traffic refers to the target The flow of data input and output by the database per second. Taking the target database as an example of the Oracle database, a structured query language (Structured Query) related to feature information, operations per second, and current traffic can be set separately. Language (SQL) statements to implement monitoring. Of course, according to the actual application scenario, the current parameters may not be limited to the above-mentioned characteristic information, the number of operations per second, and the current traffic, such as the number of database connections (the current number of all threads in the database) and the table space occupation rate. Optionally, the target database is monitored by a preset monitoring system. In the embodiment of the present application, the monitoring operation of the target database may be completed in a monitoring system. The monitoring system may be a system that manages the host where the target database is located, and an SQL statement related to the monitoring operation is added. The monitoring is performed by setting a separate monitoring system. The target database realizes the functional isolation of each system and improves the fault tolerance of monitoring.

S104: When the current parameter meets a preset condition, generating alarm information including the current parameter.

After obtaining the current parameters, it is determined whether the current parameters meet a preset condition, and the preset condition may be a preset threshold of the number of operations per second and a threshold of the current traffic. If the current parameters meet the preset conditions, that is, the number of operations per second and the current traffic in the current parameters are greater than or equal to the corresponding threshold, an alarm message is generated, and the alarm message is usually in text format. It is worth mentioning that, based on the current parameters, the alarm information can also include the time when the alarm information was generated and the related information of the monitoring system monitoring the target database.

S105: Find a configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information by executing a preset script file, and obtain a corresponding alarm from the configuration attribute of the found configuration item. A target, and sending the alarm information to the obtained alarm target.

In the embodiment of the present application, the transmission of alarm information is implemented by executing a preset script file. Specifically, during the execution of the script file, according to the characteristic information of the alarm information, it is found whether there is a configuration item in the CMDB and the identifier of the configuration item. The information is the same as the characteristic information. If it exists, the alarm target is obtained from the configuration attribute corresponding to the configuration item, and the alarm information is automatically sent to the alarm target. Multiple sending methods can be preset in the script file, so when the script file is executed, the corresponding sending method is automatically adopted according to the type of the alarm target. For example, if the target of the alert is the target email account, a corresponding sending method is based on any preset email account and password (which can be the email account and password of the host executing the script file) that can communicate normally. The alarm information is added to the email to be sent to this email account, and the email to be sent is automatically sent to the target email account. In addition, before the code for sending the alarm information in the script file, a judgment mechanism can be set. The judgment mechanism is used to determine whether the alarm target was successfully obtained. If the acquisition is successful, the alarm information is sent during the execution of the script file. If it fails, a failure prompt containing alarm information is output. Preferably, the script file is written in python language. Since the python language is easy to use and extensible, it can be applied in this embodiment.

According to the embodiment shown in FIG. 1, the embodiment of the present application realizes automatic alarming of the database by constructing a CMDB, which improves the configuration efficiency of the database alarm mechanism, and if the target of the alarm is to be changed, the configuration in the CMDB can be directly changed. Improved the convenience of changing alert targets.

Please refer to FIG. 2, which is a flowchart of implementing a database automatic alarm method provided in Embodiment 2 of the present application. Compared with the embodiment corresponding to FIG. 1, this embodiment refines S102 on the basis that the configuration information includes identification information and multiple alarm information groups, and each alarm information group includes an alarm target and an alarm threshold corresponding to the alarm target. S201 ~ S203 are obtained later, as follows:

S201: Construct the CMDB according to the configuration information, wherein the identification information is stored in the configuration item, the configuration item corresponds to a plurality of the configuration attributes, and each of the configuration attributes is stored in One said alarm information group.

In the embodiment of the present application, the obtained configuration information includes identification information of the target database and a plurality of alarm information groups corresponding to the target database, where each alarm information group includes an alarm target and an alarm threshold corresponding to the alarm target. The specific process in the information construction CMDB is to store the identification information in the configuration information to the configuration item in the CMDB, and store multiple alarm information groups in the configuration information to the multiple configuration attributes corresponding to the configuration item in the CMDB. , Where each configuration property stores an alarm information group.

S202: Analyze the alarm information to obtain an alarm value of the alarm information, where the alarm value indicates the severity of the alarm information.

When the configuration information includes identification information and multiple alarm information groups, the preset script file is different from the script file in the first embodiment of the present application. During the execution of the script file in the embodiment of the present application, if the alarm information has been obtained , Find the configuration item corresponding to the identification information in the CMDB that is the same as the characteristic information in the alarm information, and analyze the alarm information to obtain the alarm value of the alarm information. An analysis method for analyzing alarm information is to obtain preset multiple times intervals corresponding to the number of operations per second and multiple traffic intervals corresponding to the current traffic. Each times interval and each traffic interval include interval values. The alarm value is obtained by judging the frequency interval to which the number of operations per second in the alarm information belongs and the flow interval to which the current traffic in the alarm information belongs, and adding the interval value of the number of times interval and the interval value of the flow interval to which the alarm value belongs.

For example, suppose that the preset conditions for determining whether to generate alarm information are 5 operations per second, the current traffic is 3KB, and the number of times corresponding to the number of operations per second includes 5 to 10 operations per second. The number of times, the interval value is 0; the number of operations per second is 11 to 15 times, the interval value is 1; the number of operations per second is 16 times or more, the interval value is 2. The multiple traffic ranges corresponding to the current traffic include the current traffic ranges from 3KB to 5KB, and the interval value is 0; the current traffic ranges from 6KB to 9KB, and the interval value is 1; the current traffic ranges from 10KB and above 10KB, The interval value is 2. Assuming that the number of operations per second in the alarm information is 15 and the current traffic is 8KB, the alarm value is 1 + 1 = 2. The alarm value indicates the severity of the alarm information. The higher the alarm value, the higher the severity.

Optionally, different multiple times intervals and multiple traffic intervals are set according to different feature information of different target databases. Wherein such information Info _feature-1 corresponding to the plurality of frequency interval _{_Interval} Times1-1, Interval Times1-2 and _Interval Times1-3, traffic interval corresponding to the plurality of _{_Interval} Data1-1, Interval Data1-2 and Interval _{Data1- 3} ; The feature information is multiple times intervals corresponding to Info _feature-2 are Interval _Times2-1 , Interval _Times2-2, and Interval _Times2-3 , and the corresponding multiple traffic intervals are Interval _Data2-1 , Interval _Data2-2, and Interval _{Data2 -3} . If the feature information of the obtained alarm information is Info _feature-2 , the corresponding multiple times intervals Interval _Times2-1 , Interval _Times2-2 and Interval _Times2-3 and the corresponding multiple traffic intervals Interval _Data2-1 and Interval are _passed . _Data2-2 and Interval _Data2-3 analyze the alarm information to obtain the alarm value, and realize the difference analysis of the alarm information of different target databases.

S203: Traversing the alarm information group in the multiple configuration attributes corresponding to the found configuration item, traverses all alarm information groups in the alarm information group corresponding to the alarm threshold that is less than or equal to the alarm value. The alarm target is added to the target set, and the alarm information is sent to the alarm target in the target set.

After calculating the alarm value of the alarm information, traverse multiple configuration attributes corresponding to the found configuration item, and compare the alarm threshold of the alarm information group in each configuration attribute with the alarm value. If the alarm threshold is less than or equal to the alarm value , The alarm target in the alarm information group to which the alarm threshold belongs is added to the target set; if the alarm threshold is greater than the alarm value, the alarm value is continuously compared with the alarm threshold of the alarm information group in the next configuration attribute in the CMDB. After the traversal of multiple configuration attributes corresponding to the configuration items is completed, the target set is completed, and the alarm information is sent to all alarm targets in the target set.

It can be known from the embodiment shown in FIG. 2 that in the embodiment of the present application, by storing multiple alarm targets in the CMDB, different alarms of alarm information of different severity levels are realized, and the applicability of the alarm is improved.

Please refer to FIG. 3, which is a flowchart of implementing a method for automatically alarming a database provided in Embodiment 3 of the present application. Compared with the embodiment corresponding to FIG. 2, this embodiment further refines S201 to obtain S301 to S302 on the basis that the configuration information further includes multiple weights corresponding to the current parameters, as follows:

S301: Construct the CMDB according to the configuration information, wherein the identification information is stored in the configuration item, the configuration item corresponds to a plurality of the configuration attributes, and each of the configuration attributes is stored in One alarm information group and the plurality of weights.

In an actual application scenario, multiple contents included in the current parameters, such as the number of operations per second and the importance of the current traffic may be different. Therefore, the configuration information may be preset to include multiple weights corresponding to the current parameters, and When the CMDB is constructed based on the configuration information, the identification information in the configuration information is stored in the configuration items of the CMDB, and multiple alarm information groups in the configuration information are respectively stored in multiple configuration attributes corresponding to the configuration items, where each configuration attribute An alarm information group is stored in the alarm information group, and multiple weights in the configuration information are stored in each configuration attribute corresponding to the configuration item. After the storage is completed, multiple weights are stored in each configuration attribute.

In S302, the configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information is searched, and any one of the configuration items corresponding to the found configuration item is obtained. The plurality of weights in the configuration attribute are obtained by weighting and adding the alarm information based on the plurality of weights to obtain the alarm value.

After storing multiple weights to multiple configuration attributes in the CMDB, and after the alarm information is generated, analyze the alarm information to find the configuration item in the CMDB, the identification information of the configuration item and the characteristic information in the alarm information Match. Obtain multiple weights in any one of the configuration attributes corresponding to the found configuration item, and perform weighted summation of the alarm information based on the multiple weights. Specifically, the alarm may be determined first according to the analysis method in step S202. The interval value of the interval of the number of operations per second in the information and the interval value of the current interval of the current traffic in the alarm information, and then the interval value is weighted according to the weight corresponding to the number of operations per second and the weight corresponding to the current traffic. And, the obtained result is used as the alarm value. For example, the interval of the number of operations per second in the alarm information is Value _Interval-1 , and the interval of the current interval in the alarm information is Value _Interval-2 . The CMDB stores the number of operations per second. The corresponding weight value is Weight _Times and the weight value corresponding to the current traffic is Weight _Data . The calculation method of the value _warn is Value _warn = Value _Interval-1 · Weight _Times + Value _Interval-2 · Weight _Data .

It can be known from the embodiment shown in FIG. 3 that in the embodiment of the present application, multiple weights corresponding to different contents in the current parameters are stored in the CMDB, and the weights are taken out and weighted and summed during the analysis of the alarm information. The importance of different content is distinguished, which improves the accuracy of generating alarm values.

Please refer to FIG. 4, which is a flowchart of implementing a database automatic alarm method provided in Embodiment 4 of the present application. Compared with the embodiment corresponding to FIG. 1, this embodiment refines S103 to obtain S401 to S403, which are detailed as follows:

S401: Set up a zabbix client on the host of the target database.

In the embodiment of the present application, the monitoring of the target database is implemented by zabbix. Among them, zabbix is an open source distributed monitoring system, which is applicable to the scenario where one or more target databases exist. Zabbix mainly includes a zabbix server and a zabbix client. The zabbix server is a core component of zabbix and is responsible for receiving data sent by the zabbix client. The zabbix client is deployed on the monitored host and is used to collect data from the host. In the embodiment of the present application, a zabbix server is established on a host (a host operated by a user) that needs to view current parameters, and a zabbix client is established on the host where the target database is located. The establishment process can be implemented by installing a zabbix installation package.

S402: Create a zabbix monitoring item, and the monitoring target of the zabbix monitoring item is the target database in the zabbix client.

To monitor the target database in the zabbix client, first write a monitoring script. The monitoring script includes a shell statement for detecting the current parameters. After writing, add the monitoring script to the zabbix client configuration file (usually named zabbix_agentd.conf) as a custom key and restart the zabbix client. In Zabbix, keys and monitoring items are usually matched, that is, if you want to obtain the data corresponding to the monitoring item, you must use the key to get. Therefore, after successfully generating a custom key for obtaining the current parameters, a monitoring item containing the key is established on the zabbix server. By running the monitoring item, the zabbix server can obtain the current parameters of the target database. It is worth mentioning that the running time or running interval of the monitoring items can also be set to meet the acquisition requirements of the current parameters, such as running the monitoring item at 8 o'clock every morning or running the monitoring item every half an hour.

S403: Give the Zabbix monitoring item an execution permission once. When the data obtained by executing the Zabbix monitoring item matches the format of the current parameter, give the Zabbix monitoring item an automatic execution execution permission.

In the embodiment of the present application, the execution permission is given to the zabbix monitoring item once, that is, when the zabbix server detects that data is obtained through the zabbix monitoring item, it stops giving the execution permission to the zabbix monitoring item. The format of the data obtained through the zabbix monitoring item is compared with the format of the current parameter. If the format of the data obtained through the zabbix monitoring item is the same as the format of the current parameter, the data obtained by the zabbix monitoring item is deemed to be correct, zabbix The server gives the Zabbix monitoring item the execution permission for automatic execution, and the Zabbix monitoring item runs automatically according to the set running time or running interval.

According to the embodiment shown in FIG. 4, the embodiment of the present application uses zabbix technology to obtain the current parameters of the target database. Due to the distributed nature of zabbix, it is applicable to scenarios where multiple target databases exist, which improves the applicability of current parameter acquisition Sex.

Please refer to FIG. 5, which is a flowchart of a method for automatically alarming a database provided in Embodiment 5 of the present application. Compared with the embodiment corresponding to FIG. 1, this embodiment refines S104 to obtain S501 to S502 on the basis of preset conditions including multiple alarm levels, as follows:

S501: Determine the alarm level that the current parameter complies with from the multiple alarm levels.

In the embodiment of the present application, the preset condition includes multiple alarm levels, and the alarm levels indicate the severity of the current parameters, such as safety, minor, severe, and critical. In addition, multiple alarm intervals corresponding to multiple alarm levels are set, and the alarm level is determined by judging the alarm interval to which the current parameter belongs. Among them, different from the frequency interval and the flow interval in step S202, each alarm interval includes each The value range of the number of operations in seconds and the value range of the current traffic. For example, the alarm level is mild, and the corresponding alarm interval is: 2 to 4 operations per second, and the current traffic is 2KB to 4KB; the alarm level is severe, and the corresponding alarm interval is: 5 to 5 operations per second. Six times, the current traffic is 5KB to 6KB. If the number of operations per second in the current parameter is 3 and the current traffic is 3KB, the alarm level that the current parameter meets is minor. It is worth mentioning that if the alarm level corresponding to the current parameter cannot be determined, an alarm prompt is output.

S502: Add the alarm level and the current parameter that the current parameters meet to a preset alarm information template to generate the alarm information.

After determining the alarm level that the current parameters meet, add the alarm level and current parameters to a preset alarm information template to generate alarm information. For example, the alarm information template can be:

Characteristic information: A operations per second: B Current traffic: C

Alarm level: D

The above A, B, C, and D indicate unknown parameters. Adding the alarm level and current parameters to the alarm information template is to replace the alarm levels and current parameters with the corresponding A, B, C, and D in the alarm information template. Generate alarm information.

It can be known from the embodiment shown in FIG. 5 that in the embodiment of the present application, the preset condition includes multiple alarm levels. When the current parameters meet the preset conditions, the process of generating alarm information is specifically determining the current alarm level from multiple alarm levels. The alarm level that the parameters meet, adds the current alarm level and the current parameters to the preset alarm information template, generates alarm information, and improves the recognizability of the alarm information.

Corresponding to the method of automatic database alarming described in the above embodiment, FIG. 6 shows a structural block diagram of a database automatic alarming device provided by an embodiment of the present application. Referring to FIG. 6, the device includes:

The first obtaining unit 61 is configured to obtain configuration information related to a target database to which an alarm is to be set, where the configuration information includes identification information of the target database and an alarm target corresponding to the target database;

A construction unit 62 is configured to construct a configuration management database CMDB according to the configuration information, wherein the CMDB corresponds to a configuration item, the configuration item stores the identification information, and the configuration attribute corresponding to the configuration item stores The alarm target is entered;

A second obtaining unit 63, configured to obtain current parameters of the target database, where the current parameters include characteristic information of the target database, operations per second, and current traffic, and the characteristic information includes a name of the target database;

A generating unit 64, configured to generate alarm information including the current parameter when the current parameter meets a preset condition;

The execution unit 65 is configured to find, by executing a preset script file, a configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information, and from the configuration attributes of the found configuration item, Acquire a corresponding alarm target, and send the alarm information to the acquired alarm target.

Optionally, the configuration information includes the identification information and multiple alarm information groups, and each of the alarm information groups includes the alarm target and an alarm threshold corresponding to the alarm target, and the constructing unit 62 includes :

A first constructing subunit configured to construct the CMDB according to the configuration information, wherein the configuration item stores the identification information, and the configuration item corresponds to a plurality of the configuration attributes, each of which One configuration of the alarm information group is stored in the configuration attribute;

The execution unit 65 includes:

An analysis unit, configured to analyze the alarm information to obtain an alarm value of the alarm information, where the alarm value indicates a severity of the alarm information;

The traversal unit is configured to traverse the alarm information group in the plurality of configuration attributes corresponding to the found configuration item, and the alarm information group corresponding to the alarm threshold value that is less than or equal to the alarm value The alarm target in is added to a target set, and the alarm information is sent to the alarm target in the target set.

Optionally, the configuration information further includes multiple weights corresponding to the current parameters, and the constructing unit 62 includes:

A second construction subunit is configured to construct the CMDB according to the configuration information, wherein the identification information is stored in the configuration item, and the configuration item corresponds to a plurality of the configuration attributes, each of which One configuration of the alarm information group and the plurality of weight values are stored in the configuration attributes;

The analysis unit includes:

A searching unit, configured to search the configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information, and obtain any one corresponding to the found configuration item The plurality of weight values in the configuration attribute are obtained by weighting and adding the alarm information based on the plurality of weight values to obtain the alarm value.

Optionally, the second obtaining unit 63 includes:

A building unit for building a zabbix client on the host of the target database;

A creating unit, configured to create a zabbix monitoring item, and a monitoring target of the zabbix monitoring item is the target database in the zabbix client;

The assigning unit is configured to assign an execution permission to the Zabbix monitoring item once. When the data obtained by executing the Zabbix monitoring item matches the format of the current parameter, the Zabbix monitoring item is given an automatic execution execution permission.

Optionally, the preset condition includes multiple alarm levels, and the generating unit 64 includes:

A level determining unit, configured to determine, from the multiple alarm levels, the alarm level that the current parameter complies with;

An adding unit is configured to add the alarm level and the current parameter that the current parameters meet to a preset alarm information template to generate the alarm information.

FIG. 7 is a schematic diagram of a terminal device according to an embodiment of the present application. As shown in FIG. 7, the terminal device 7 of this embodiment includes a processor 70 and a memory 71. The memory 71 stores computer-readable instructions 72 that can be run on the processor 70, such as a database for automatic alarm. program. When the processor 70 executes the computer-readable instructions 72, the steps in the method embodiment for implementing the automatic alarm of each database described above, for example, steps S101 to S105 shown in FIG. Alternatively, when the processor 70 executes the computer-readable instructions 72, the functions of the units in the foregoing device embodiments are implemented, for example, the functions of the units 61 to 65 shown in FIG. 6.

Exemplarily, the computer-readable instructions 72 may be divided into one or more modules / units, the one or more modules / units are stored in the memory 71 and executed by the processor 70, To complete this application. The one or more modules / units may be a series of computer-readable instruction segments capable of performing specific functions, and the instruction segments are used to describe the execution process of the computer-readable instructions 72 in the terminal device 7. For example, the computer-readable instructions 72 may be divided into a first acquisition unit, a construction unit, a second acquisition unit, a generation unit, and an execution unit, and the specific functions of each unit are as described above.

The terminal device may include, but is not limited to, a processor 70 and a memory 71. Those skilled in the art can understand that FIG. 7 is only an example of the terminal device 7 and does not constitute a limitation on the terminal device 7. It may include more or fewer components than shown in the figure, or combine some components or different components. For example, the terminal device may further include an input / output device, a network access device, a bus, and the like.

The processor 70 may be a central processing unit (Central Processing Unit (CPU), or other general-purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (Application Specific Integrated Circuits) Specific Integrated Circuit (ASIC), off-the-shelf Programmable Gate Array (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

The memory 71 may be an internal storage unit of the terminal device 7, such as a hard disk or a memory of the terminal device 7. The memory 71 may also be an external storage device of the terminal device 7, such as a plug-in hard disk, a smart memory card (SMC), and a secure digital (SD) provided on the terminal device 7. Card, flash card, etc. Further, the memory 71 may further include both an internal storage unit of the terminal device 7 and an external storage device. The memory 71 is configured to store the computer-readable instructions and other programs and data required by the terminal device. The memory 71 may also be used to temporarily store data that has been output or is to be output.

In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each of the units may exist separately physically, or two or more units may be integrated into one unit. The above integrated unit may be implemented in the form of hardware or in the form of software functional unit.

If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it may be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application is essentially a part that contributes to the existing technology or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium , Including a number of instructions to enable a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in the embodiments of the present application. The foregoing storage media include: U disks, mobile hard disks, read-only memory (ROM), random access memory (RAM), magnetic disks, or compact discs, and other media that can store program codes .

As mentioned above, the above embodiments are only used to describe the technical solution of the present application, rather than limiting the present invention. Although the present application has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that they can still interpret the foregoing. The technical solutions described in the embodiments are modified, or some technical features are equivalently replaced; and these modifications or replacements do not depart from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

A method for automatically alerting a database, comprising:

Acquiring configuration information related to a target database to which an alarm is to be set, the configuration information including identification information of the target database and an alarm target corresponding to the target database;

Build a configuration management database CMDB according to the configuration information, wherein the CMDB corresponds to a configuration item, the identification information is stored in the configuration item, and the alarm target is stored in a configuration attribute corresponding to the configuration item ;

Acquiring current parameters of the target database, where the current parameters include characteristic information of the target database, operations per second, and current traffic, and the characteristic information includes a name of the target database;

When the current parameter meets a preset condition, generating alarm information including the current parameter;

Find a configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information by executing a preset script file, and obtain a corresponding alarm target from the configuration attribute of the found configuration item, And sending the alarm information to the acquired alarm target.
The method according to claim 1, wherein the configuration information includes the identification information and a plurality of alarm information groups, and each of the alarm information groups includes the alarm target and an alarm corresponding to the alarm target A threshold, and the constructing a configuration management database CMDB according to the configuration information includes:

The CMDB is constructed according to the configuration information, wherein the identification information is stored in the configuration item, the configuration item corresponds to a plurality of the configuration attributes, and each of the configuration attributes stores one Said alarm information group;

The acquiring the corresponding alarm target from the configuration attributes of the found configuration item, and sending the alarm information to the acquired alarm target includes:

Analyzing the alarm information to obtain an alarm value of the alarm information, where the alarm value indicates the severity of the alarm information;

Traversing the alarm information group in the plurality of configuration attributes corresponding to the configuration item found will traverse the alarm in the alarm information group corresponding to the alarm threshold that is less than or equal to the alarm value A target is added to the target set, and the alarm information is sent to the alarm target in the target set.
The method according to claim 2, wherein the configuration information further comprises a plurality of weights corresponding to the current parameters, and the CMDB is constructed according to the configuration information, wherein, in the configuration item, The identification information is stored, and the configuration item corresponds to a plurality of the configuration attributes. Each of the configuration attributes stores one of the alarm information groups, including:

The CMDB is constructed according to the configuration information, wherein the identification information is stored in the configuration item, the configuration item corresponds to a plurality of the configuration attributes, and each of the configuration attributes stores one The alarm information group and the multiple weights;

The analyzing the alarm information to obtain an alarm value of the alarm information includes:

Find the configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information, and obtain any one of the configuration attributes corresponding to the found configuration item The weighted summation of the plurality of weight values based on the plurality of weight values to obtain the alarm value.
The method according to claim 1, wherein the acquiring the current parameters of the target database comprises:

Building a zabbix client on the host of the target database;

Create a zabbix monitoring item, and the monitoring target of the zabbix monitoring item is the target database in the zabbix client;

The Zabbix monitoring item is given an execution permission once, and when the data obtained by executing the Zabbix monitoring item matches the format of the current parameter, the Zabbix monitoring item is given an automatic execution execution permission.
The method according to claim 1, wherein the preset condition includes multiple alarm levels, and when the current parameter meets the preset condition, generating alarm information including the current parameter includes:

Determining, from the plurality of alarm levels, the alarm level to which the current parameter complies;

Adding the alarm level and the current parameter that the current parameters meet to a preset alarm information template to generate the alarm information.
A device for automatically alarming a database, which is characterized by comprising:

A first obtaining unit, configured to obtain configuration information related to a target database to which an alarm is to be set, where the configuration information includes identification information of the target database and an alarm target corresponding to the target database;

A constructing unit is configured to construct a configuration management database CMDB according to the configuration information, wherein the CMDB corresponds to a configuration item, the identification information is stored in the configuration item, and the configuration attribute corresponding to the configuration item is stored in Have the alert target;

A second obtaining unit, configured to obtain current parameters of the target database, where the current parameters include characteristic information of the target database, operations per second, and current traffic, and the characteristic information includes a name of the target database;

A generating unit, configured to generate alarm information including the current parameter when the current parameter meets a preset condition;

The execution unit is configured to find a configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information by executing a preset script file, and obtain the configuration item from the configuration attribute of the found configuration item. The corresponding alarm target sends the alarm information to the acquired alarm target.
The apparatus according to claim 6, wherein the configuration information includes the identification information and a plurality of alarm information groups, and each of the alarm information groups includes the alarm target and an alarm corresponding to the alarm target Threshold, the building unit includes:

A first constructing subunit configured to construct the CMDB according to the configuration information, wherein the configuration item stores the identification information, and the configuration item corresponds to a plurality of the configuration attributes, each of which One configuration of the alarm information group is stored in the configuration attribute;

The execution unit includes:

An analysis unit, configured to analyze the alarm information to obtain an alarm value of the alarm information, where the alarm value indicates a severity of the alarm information;

The traversal unit is configured to traverse the alarm information group in the plurality of configuration attributes corresponding to the found configuration item, and the alarm information group corresponding to the alarm threshold value that is less than or equal to the alarm value The alarm target in is added to a target set, and the alarm information is sent to the alarm target in the target set.
The apparatus according to claim 7, wherein the configuration information further includes a plurality of weights corresponding to the current parameter, and the construction unit includes:

A second construction subunit is configured to construct the CMDB according to the configuration information, wherein the identification information is stored in the configuration item, and the configuration item corresponds to a plurality of the configuration attributes, each of which One configuration of the alarm information group and the plurality of weight values are stored in the configuration attributes;

The analysis unit includes:

A searching unit, configured to search the configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information, and obtain any one corresponding to the found configuration item The plurality of weight values in the configuration attribute are obtained by weighting and adding the alarm information based on the plurality of weight values to obtain the alarm value.
The apparatus according to claim 6, wherein the second obtaining unit comprises:

A building unit for building a zabbix client on the host of the target database;

A creating unit, configured to create a zabbix monitoring item, and a monitoring target of the zabbix monitoring item is the target database in the zabbix client;

The assigning unit is configured to assign an execution permission to the Zabbix monitoring item once. When the data obtained by executing the Zabbix monitoring item matches the format of the current parameter, the Zabbix monitoring item is given an automatic execution execution permission.
The apparatus according to claim 6, wherein the preset condition includes a plurality of alarm levels, and the generating unit includes:

A level determining unit, configured to determine, from the multiple alarm levels, the alarm level that the current parameter complies with;

An adding unit is configured to add the alarm level and the current parameter that the current parameters meet to a preset alarm information template to generate the alarm information.
A terminal device includes a memory and a processor, and the memory stores computer-readable instructions that can be run on the processor. When the processor executes the computer-readable instructions, the following steps are implemented: :

Acquiring configuration information related to a target database to which an alarm is to be set, the configuration information including identification information of the target database and an alarm target corresponding to the target database;

Build a configuration management database CMDB according to the configuration information, wherein the CMDB corresponds to a configuration item, the identification information is stored in the configuration item, and the alarm target is stored in a configuration attribute corresponding to the configuration item ;

Acquiring current parameters of the target database, where the current parameters include characteristic information of the target database, operations per second, and current traffic, and the characteristic information includes a name of the target database;

When the current parameter meets a preset condition, generating alarm information including the current parameter;

Find a configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information by executing a preset script file, and obtain a corresponding alarm target from the configuration attribute of the found configuration item, And sending the alarm information to the acquired alarm target.
The terminal device according to claim 11, wherein the configuration information includes the identification information and a plurality of alarm information groups, and each of the alarm information groups includes the alarm target and a corresponding alarm target. An alarm threshold, and the constructing a configuration management database CMDB according to the configuration information includes:

The CMDB is constructed according to the configuration information, wherein the identification information is stored in the configuration item, the configuration item corresponds to a plurality of the configuration attributes, and each of the configuration attributes stores one Said alarm information group;

The acquiring the corresponding alarm target from the configuration attributes of the found configuration item, and sending the alarm information to the acquired alarm target includes:

Analyzing the alarm information to obtain an alarm value of the alarm information, where the alarm value indicates the severity of the alarm information;

Traversing the alarm information group in the plurality of configuration attributes corresponding to the configuration item found will traverse the alarm in the alarm information group corresponding to the alarm threshold that is less than or equal to the alarm value A target is added to the target set, and the alarm information is sent to the alarm target in the target set.
The terminal device according to claim 12, wherein the configuration information further comprises a plurality of weights corresponding to the current parameter, and the CMDB is constructed according to the configuration information, wherein the configuration item The identification information is stored in the configuration item, and the configuration item corresponds to a plurality of the configuration attributes. Each of the configuration attributes stores one alarm information group, including:

The CMDB is constructed according to the configuration information, wherein the identification information is stored in the configuration item, the configuration item corresponds to a plurality of the configuration attributes, and each of the configuration attributes stores one The alarm information group and the multiple weights;

The analyzing the alarm information to obtain an alarm value of the alarm information includes:

Find the configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information, and obtain any one of the configuration attributes corresponding to the found configuration item The weighted summation of the plurality of weight values based on the plurality of weight values to obtain the alarm value.
The terminal device according to claim 11, wherein the acquiring the current parameters of the target database comprises:

Building a zabbix client on the host of the target database;

Create a zabbix monitoring item, and the monitoring target of the zabbix monitoring item is the target database in the zabbix client;

The Zabbix monitoring item is given an execution permission once, and when the data obtained by executing the Zabbix monitoring item matches the format of the current parameter, the Zabbix monitoring item is given an automatic execution execution permission.
The terminal device according to claim 11, wherein the preset condition includes multiple alarm levels, and when the current parameter meets the preset condition, generating alarm information including the current parameter includes:

Determining, from the plurality of alarm levels, the alarm level to which the current parameter complies;

Adding the alarm level and the current parameter that the current parameters meet to a preset alarm information template to generate the alarm information.
A computer-readable storage medium storing computer-readable instructions, wherein the computer-readable instructions implement the following steps when executed by at least one processor:

Acquiring configuration information related to a target database to which an alarm is to be set, the configuration information including identification information of the target database and an alarm target corresponding to the target database;

Build a configuration management database CMDB according to the configuration information, wherein the CMDB corresponds to a configuration item, the identification information is stored in the configuration item, and the alarm target is stored in a configuration attribute corresponding to the configuration item ;

Acquiring current parameters of the target database, where the current parameters include characteristic information of the target database, operations per second, and current traffic, and the characteristic information includes a name of the target database;

When the current parameter meets a preset condition, generating alarm information including the current parameter;

Find a configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information by executing a preset script file, and obtain a corresponding alarm target from the configuration attribute of the found configuration item, And sending the alarm information to the acquired alarm target.
The computer-readable storage medium according to claim 16, wherein configuration information related to a target database to which an alarm is to be set is obtained, wherein the configuration information includes identification information of the target database and an alarm target corresponding to the target database ;

Build a configuration management database CMDB according to the configuration information, wherein the CMDB corresponds to a configuration item, the identification information is stored in the configuration item, and the alarm target is stored in a configuration attribute corresponding to the configuration item ;

Acquiring current parameters of the target database, where the current parameters include characteristic information of the target database, operations per second, and current traffic, and the characteristic information includes a name of the target database;

When the current parameter meets a preset condition, generating alarm information including the current parameter;

Find a configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information by executing a preset script file, and obtain a corresponding alarm target from the configuration attribute of the found configuration item, And sending the alarm information to the acquired alarm target.
The computer-readable storage medium according to claim 17, wherein the configuration information further comprises a plurality of weights corresponding to the current parameter, and the CMDB is constructed according to the configuration information, wherein, all The configuration item stores the identification information, the configuration item corresponds to a plurality of the configuration attributes, and each of the configuration attributes stores one of the alarm information groups, including:

The CMDB is constructed according to the configuration information, wherein the identification information is stored in the configuration item, the configuration item corresponds to a plurality of the configuration attributes, and each of the configuration attributes stores one The alarm information group and the multiple weights;

The analyzing the alarm information to obtain an alarm value of the alarm information includes:

Find the configuration item corresponding to the identification information in the CMDB that matches the characteristic information in the alarm information, and obtain any one of the configuration attributes corresponding to the found configuration item The weighted summation of the plurality of weight values based on the plurality of weight values to obtain the alarm value.
The computer-readable storage medium according to claim 16, wherein the acquiring the current parameters of the target database comprises:

Building a zabbix client on the host of the target database;

Create a zabbix monitoring item, and the monitoring target of the zabbix monitoring item is the target database in the zabbix client;

The Zabbix monitoring item is given an execution permission once, and when the data obtained by executing the Zabbix monitoring item matches the format of the current parameter, the Zabbix monitoring item is given an automatic execution execution permission.
The computer-readable storage medium of claim 16, wherein the preset condition includes multiple alarm levels, and when the current parameter meets the preset condition, generating alarm information including the current parameter ,include:

Determining, from the plurality of alarm levels, the alarm level to which the current parameter complies;

Adding the alarm level and the current parameter that the current parameters meet to a preset alarm information template to generate the alarm information.