CN113505047A - System for centralized management monitoring of each distribution center website database - Google Patents
System for centralized management monitoring of each distribution center website database Download PDFInfo
- Publication number
- CN113505047A CN113505047A CN202110773564.9A CN202110773564A CN113505047A CN 113505047 A CN113505047 A CN 113505047A CN 202110773564 A CN202110773564 A CN 202110773564A CN 113505047 A CN113505047 A CN 113505047A
- Authority
- CN
- China
- Prior art keywords
- information
- database
- module
- abnormal
- alarm
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/32—Monitoring with visual or acoustical indication of the functioning of the machine
- G06F11/324—Display of status information
- G06F11/327—Alarm or error message display
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
- G06F11/3006—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system is distributed, e.g. networked systems, clusters, multiprocessor systems
Abstract
The application relates to a system for centralized management and monitoring of a website database of each distribution center. The system is deployed on a monitoring server, the monitoring server can be communicated with database servers of all distribution centers or network points, the system comprises an information acquisition module, an information display module and an alarm module, and the information acquisition module is used for acquiring state information of a database and storing the state information in a warehouse; the information display module is used for acquiring abnormal information from the information stored by the information acquisition module at regular time and displaying the abnormal information; and the alarm module is used for judging the abnormal information again, and sending the alarm information to the corresponding group or responsible person through the related interface if the abnormal information is still determined. According to the arrangement, the state of the database can be monitored in real time, the accuracy and the integrity of the basic information of the database are guaranteed, abnormal conditions can be timely alarmed to the corresponding group and the responsible person, a large amount of operation and maintenance labor cost is saved, the unavailable time of an automatic sorting system of a center or a network point is reduced, and the sorting efficiency is improved.
Description
Technical Field
The application relates to the technical field of software, in particular to a system for centralized management and monitoring of a website database of each distribution center.
Background
For express companies, with the increase of company traffic, more and more sorting schemes of distribution centers and distribution points are gradually changed from manual sorting into automatic sorting depending on machines and programs, one of the factors of normal operation of the programs is whether databases can stably and normally operate, and the stability of the company on the monitoring and operation and maintenance of the local databases of the distribution centers and the distribution points gradually becomes a challenge. How to monitor and manage the local databases of all the distribution centers or network points in a centralized manner so as to monitor and alarm faults of some centers or network point databases in time, which becomes a problem to be solved urgently.
Most of the existing database monitoring technologies related to a distribution center or a local network point acquire the state of a database system regularly through a shell script and acquire and configure alarm items to display alarms through zabbix. The method depends on database management personnel to check whether the faulty database is generated by polling zabbix every day, the database management personnel can only actively poll the faulty database, the risk cannot be predicted and avoided within 7 × 24 hours, and the manual polling efficiency is low and the cost is too high along with the increase of the data volume of the database.
Disclosure of Invention
The application provides a system for centralized management and monitoring of each distribution center website database, which aims to solve the problems of low efficiency, untimely time and high cost of the conventional scheme for managing and monitoring a plurality of distribution center website databases.
The above object of the present application is achieved by the following technical solutions:
the embodiment of the application provides a system for centralized management and monitoring of each distribution center website database, which is deployed on a monitoring server, wherein the monitoring server can communicate with database servers of all distribution centers or websites, and the system comprises: the system comprises an information acquisition module, an information display module and an alarm module;
the information acquisition module is used for acquiring state information of a database and storing the state information in a warehouse, wherein the state information of the database comprises database account number basic information, database master-slave relation and master-slave state information, service survival state information and whether to monitor and acquire warehouse-in information at regular time;
the information display module is used for acquiring abnormal information from the information stored by the information acquisition module at regular time according to a set abnormal condition and displaying the abnormal information to a foreground interface;
and the alarm module is used for further judging according to the abnormal information, confirming whether the abnormal condition is recovered or correct, and if the abnormal condition is still confirmed, sending alarm information to a corresponding group or a responsible person through a relevant interface according to the actual abnormal condition.
Optionally, the abnormal information includes database service abnormality, master-slave copy abnormality, backup abnormality, disk space warning, server abnormality, and network abnormality.
Optionally, the system further comprises a configuration module, and the configuration module is used for providing a configuration interface and a configuration button so that a user can set whether to turn on or off the alarm.
Optionally, the information acquisition module, the information display module and the alarm module are all developed by adopting python language.
Optionally, the related interface includes instant messaging software.
The technical scheme provided by the embodiment of the application can have the following beneficial effects:
in the technical scheme provided by the embodiment of the application, a centralized management monitoring system is deployed on a monitoring server which can communicate with database servers of all distribution centers or network points, so that firstly, state information of a database is acquired and stored in a warehouse through an information acquisition module of the system, then abnormal information is acquired from the information stored by the information acquisition module according to set abnormal conditions through an information display module of the system at regular time and is displayed to a foreground interface, then, further judgment is carried out through an alarm module of the system according to the abnormal information to confirm whether the abnormal condition is recovered or correct, and if the abnormal condition is determined to be still abnormal, alarm information is sent to a corresponding group or a responsible person through a related interface according to the actual abnormal condition. According to the arrangement, the state of the database can be monitored in real time, the accuracy and the integrity of the basic information of the database are guaranteed, abnormal conditions can be timely alarmed to the corresponding group and the responsible person, a large amount of operation and maintenance labor cost is saved, the unavailable time of an automatic sorting system of a center or a network point is reduced, and the sorting efficiency is improved.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the application.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and together with the description, serve to explain the principles of the application.
Fig. 1 is a schematic monitoring flow diagram of a system for centralized management and monitoring of a website database of each distribution center according to an embodiment of the present application.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present application, as detailed in the appended claims.
In the related art, a monitoring acquisition script is deployed on each server of each central network point, so that data acquisition and monitoring are realized by the script. The original technology depends on database management personnel to inspect zabbix every day to check whether a faulty database is generated, the database management personnel can only actively inspect, risks cannot be predicted 7 x 24 hours, the risks are avoided, and the manual inspection efficiency is low and the cost is too high along with the increase of the data volume of the database.
In order to solve the problems, the application provides a system for centralized management and monitoring of the distribution center website database, so that on the basis of ensuring the accuracy and integrity of the basic information of the database, abnormal conditions are timely alarmed to corresponding groups and responsible persons, thereby saving a large amount of operation and maintenance labor cost, reducing the unavailable time of an automatic sorting system of a center or a website, and further improving the sorting efficiency. The following examples are given for the purpose of illustration.
Examples
Referring to fig. 1, fig. 1 is a schematic monitoring flow diagram of a system for centralized management and monitoring of each distribution center website database according to an embodiment of the present application.
As shown in fig. 1, the system is deployed on a monitoring server, the monitoring server can communicate with database servers of all distribution centers or network points, and the system includes: the system comprises an information acquisition module 1, an information display module 2 and an alarm module 3; wherein the content of the first and second substances,
the information acquisition module 1 is used for acquiring state information of a database and storing the state information in a warehouse, wherein the state information of the database comprises database account number basic information, database master-slave relationship and master-slave state information, service survival state information and whether to monitor and acquire warehouse-in information regularly;
the information display module 2 is used for acquiring abnormal information from the information stored in the information acquisition module at regular time according to a set abnormal condition and displaying the abnormal information to a foreground interface;
the alarm module 3 is used for further judging according to the abnormal information, confirming whether the abnormal condition is recovered or correct, and if the abnormal condition is still confirmed, sending alarm information to a corresponding group or a responsible person through a related interface according to the actual abnormal condition.
Specifically, the state information of the database acquired by the information acquisition module 1 is information that needs to be acquired in a conventional monitoring method, and is not specifically described in detail. The abnormal condition set in the information display module 2 may also be determined according to the prior art, for example, in some embodiments, the abnormal information includes database service abnormality, master-slave copy abnormality, backup abnormality, disk space warning, server abnormality, and network abnormality.
In addition, the foreground interface is arranged to display abnormal information, so that managers can conveniently check the abnormal information at any time. After the alarm module 3 acquires the abnormal information, the abnormal information is confirmed again, and the alarm information is sent only when the abnormal information is confirmed, so that the accuracy of the alarm information can be ensured.
Further, in some embodiments, the information collection module 1, the information presentation module 2, and the alarm module 3 in the system may all be developed using python language. The Python language has rich standard libraries, provides source code or machine code suitable for each major system platform, is easy to expand, and can customize an extension program language in software.
In addition, in some embodiments, the system further comprises a configuration module for providing a configuration interface and configuration buttons for a user to set whether to turn the alarm on or off. Based on this, that is to say, the user can configure whether the alarm is needed in the monitoring process according to the actual need. In a specific application, the related interface for sending the warning message may include various instant messaging software, such as a nail and the like, so that the user can receive and view the warning message in time. In addition, the user can also configure the relevant interface through the configuration module.
In the technical scheme provided by the embodiment of the application, a centralized management monitoring system is deployed on a monitoring server which can communicate with database servers of all distribution centers or network points, so that firstly, state information of a database is acquired and stored in a warehouse through an information acquisition module of the system, then abnormal information is acquired from the information stored by the information acquisition module according to set abnormal conditions through an information display module of the system at regular time and is displayed to a foreground interface, then, further judgment is carried out through an alarm module of the system according to the abnormal information to confirm whether the abnormal condition is recovered or correct, and if the abnormal condition is determined to be still abnormal, alarm information is sent to a corresponding group or a responsible person through a related interface according to the actual abnormal condition. According to the arrangement, the state of the database can be monitored in real time, the accuracy and the integrity of the basic information of the database are guaranteed, abnormal conditions can be timely alarmed to the corresponding group and the responsible person, a large amount of operation and maintenance labor cost is saved, the unavailable time of an automatic sorting system of a center or a network point is reduced, and the sorting efficiency is improved.
It is understood that the same or similar parts in the above embodiments may be mutually referred to, and the same or similar parts in other embodiments may be referred to for the content which is not described in detail in some embodiments.
It should be understood that portions of the present application may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.
It will be understood by those skilled in the art that all or part of the steps carried by the method for implementing the above embodiments may be implemented by hardware related to instructions of a program, which may be stored in a computer readable storage medium, and when the program is executed, the program includes one or a combination of the steps of the method embodiments.
In addition, functional units in the embodiments of the present application may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a stand-alone product, may also be stored in a computer readable storage medium.
The storage medium mentioned above may be a read-only memory, a magnetic or optical disk, etc.
In the description herein, reference to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the application. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
Although embodiments of the present application have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present application, and that variations, modifications, substitutions and alterations may be made to the above embodiments by those of ordinary skill in the art within the scope of the present application.
Claims (5)
1. A centralized management monitors the system of each distribution center website database, characterized by, dispose on the monitoring server, the said monitoring server can communicate with database server of all distribution centers or websites, the said system includes: the system comprises an information acquisition module, an information display module and an alarm module;
the information acquisition module is used for acquiring state information of a database and storing the state information in a warehouse, wherein the state information of the database comprises database account number basic information, database master-slave relation and master-slave state information, service survival state information and whether to monitor and acquire warehouse-in information at regular time;
the information display module is used for acquiring abnormal information from the information stored by the information acquisition module at regular time according to a set abnormal condition and displaying the abnormal information to a foreground interface;
and the alarm module is used for further judging according to the abnormal information, confirming whether the abnormal condition is recovered or correct, and if the abnormal condition is still confirmed, sending alarm information to a corresponding group or a responsible person through a relevant interface according to the actual abnormal condition.
2. The system of claim 1, wherein the exception information comprises database service exceptions, master-slave copy exceptions, backup exceptions, disk space alerts, server exceptions, and network exceptions.
3. The system of claim 1, further comprising a configuration module for providing a configuration interface and configuration buttons for a user to set whether to turn the alarm on or off.
4. The system of claim 1, wherein the information collection module, the information presentation module, and the alarm module are all developed using python language.
5. The system of claim 1, wherein the associated interface comprises instant messaging software.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110773564.9A CN113505047A (en) | 2021-07-08 | 2021-07-08 | System for centralized management monitoring of each distribution center website database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110773564.9A CN113505047A (en) | 2021-07-08 | 2021-07-08 | System for centralized management monitoring of each distribution center website database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113505047A true CN113505047A (en) | 2021-10-15 |
Family
ID=78012190
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110773564.9A Pending CN113505047A (en) | 2021-07-08 | 2021-07-08 | System for centralized management monitoring of each distribution center website database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113505047A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040243653A1 (en) * | 2003-05-30 | 2004-12-02 | Chung-I Lee | System and method for generating an alarm when an abnormal database backup status occurs |
| CN102523140A (en) * | 2012-01-12 | 2012-06-27 | 江苏电力信息技术有限公司 | Real-time monitoring device for operation and maintenance of electric power customer service system |
| CN108959038A (en) * | 2018-07-16 | 2018-12-07 | 郑州云海信息技术有限公司 | A kind of method and device of distributed application services monitoring |
| CN109040273A (en) * | 2018-08-16 | 2018-12-18 | 上海思功信息技术有限公司 | A kind of peace lamp system and its control method |
| CN109728979A (en) * | 2019-03-01 | 2019-05-07 | 国网新疆电力有限公司信息通信公司 | Automatic warning system and method suitable for information O&M comprehensive supervision platform |
| CN109947616A (en) * | 2019-02-11 | 2019-06-28 | 北京国电通网络技术有限公司 | A kind of automatically-monitored operational system of the cloud operating system based on OpenStack technology |
| CN112346931A (en) * | 2020-11-04 | 2021-02-09 | 青岛以萨数据技术有限公司 | Raspberry pie-based private network service cluster monitoring alarm system, method and medium |
-
2021
- 2021-07-08 CN CN202110773564.9A patent/CN113505047A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040243653A1 (en) * | 2003-05-30 | 2004-12-02 | Chung-I Lee | System and method for generating an alarm when an abnormal database backup status occurs |
| CN102523140A (en) * | 2012-01-12 | 2012-06-27 | 江苏电力信息技术有限公司 | Real-time monitoring device for operation and maintenance of electric power customer service system |
| CN108959038A (en) * | 2018-07-16 | 2018-12-07 | 郑州云海信息技术有限公司 | A kind of method and device of distributed application services monitoring |
| CN109040273A (en) * | 2018-08-16 | 2018-12-18 | 上海思功信息技术有限公司 | A kind of peace lamp system and its control method |
| CN109947616A (en) * | 2019-02-11 | 2019-06-28 | 北京国电通网络技术有限公司 | A kind of automatically-monitored operational system of the cloud operating system based on OpenStack technology |
| CN109728979A (en) * | 2019-03-01 | 2019-05-07 | 国网新疆电力有限公司信息通信公司 | Automatic warning system and method suitable for information O&M comprehensive supervision platform |
| CN112346931A (en) * | 2020-11-04 | 2021-02-09 | 青岛以萨数据技术有限公司 | Raspberry pie-based private network service cluster monitoring alarm system, method and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR101856543B1 (en) | Failure prediction system based on artificial intelligence | |
| CN102937930B (en) | Application program monitoring system and method | |
| CN112965874B (en) | Configurable monitoring alarm method and system | |
| CN107707415B (en) | SaltStack-based automatic monitoring and warning method for server configuration | |
| CN107193714B (en) | Alarm display method and device | |
| US8630866B2 (en) | System and method to automate service delivery to medical equipment | |
| CN114787875A (en) | System and method for using virtual or augmented reality with data center operations or cloud infrastructure | |
| CN112799909A (en) | Automatic management system and method for server | |
| CN114024834A (en) | Fault positioning method and device, electronic equipment and readable storage medium | |
| CN114356499A (en) | Kubernetes cluster alarm root cause analysis method and device | |
| EP2390739A2 (en) | A method and apparatus for providing industrial plant information | |
| CN108241565A (en) | A kind of system and method for being used to implement application system automation O＆M | |
| CN110471822A (en) | Method, apparatus, computer system and medium for monitoring host computer system | |
| CN111143162A (en) | Method for detecting whether application system based on multilayer architecture normally operates | |
| CN113505047A (en) | System for centralized management monitoring of each distribution center website database | |
| CN111625410B (en) | Information processing method, apparatus, and computer storage medium | |
| CN112966056B (en) | Information processing method, device, equipment, system and readable storage medium | |
| CN115273354A (en) | Bank self-service equipment management method and system and computer equipment | |
| CN114356460A (en) | Medical equipment health real-time acquisition monitoring method and system | |
| CN113835961A (en) | Alarm information monitoring method, device, server and storage medium | |
| CN113808725A (en) | Equipment early warning system and method | |
| CN112350889A (en) | System and method for monitoring running state of block link point | |
| CN111444032A (en) | Computer system fault repairing method, system and equipment | |
| CN112181780A (en) | Detection and alarm method, device and equipment for containerized platform core component | |
| CN111835566A (en) | System fault management method, device and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |