CN103746837A - Database monitoring method, database monitoring device and system - Google Patents
Database monitoring method, database monitoring device and system Download PDFInfo
- Publication number
- CN103746837A CN103746837A CN201310740860.4A CN201310740860A CN103746837A CN 103746837 A CN103746837 A CN 103746837A CN 201310740860 A CN201310740860 A CN 201310740860A CN 103746837 A CN103746837 A CN 103746837A
- Authority
- CN
- China
- Prior art keywords
- cluster
- node
- monitoring device
- database
- monitoring
- 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
Landscapes
- Debugging And Monitoring (AREA)
Abstract
The embodiment of the invention provides a database monitoring method, a database monitoring device and a database monitoring system. When each monitoring node generates abnormal conditions, node warning information is sent to a monitoring cluster, the load of the monitoring cluster is shared, and meanwhile, the validity and the stability of the database monitoring are ensured. According to the scheme, the method comprises the steps that a triggering instruction from the monitoring cluster is received; a first instruction is sent to a load balancing device, wherein the first instruction is used for indicating the load balancing device to detect whether the cluster is available or not, and whether the cluster is available or not refers to whether a software main body of each node in the cluster exists or not; a first response message from the load balancing device is received; if the first response message indicates that the cluster is available, and each node in the cluster is scanned, whether each node in the cluster is available or not is determined, wherein whether each node is available refers to whether the software main body of each node exists or not; if unavailable nodes exist, the node warning information is generated and is sent to the monitoring cluster, wherein the node warning information is used for indicating the unavailable nodes.
Description
Technical field
The present invention relates to Database Systems technical field, relate in particular to method, the database monitoring Apparatus and system of monitor database.
Background technology
Cloud computing is the product that the traditional calculations machine technologies such as grid computing, Distributed Calculation, parallel computation, effectiveness calculating, the network storage, virtual, load balancing and network technical development merge.Due to cloud computing itself, while making the user of different geographical access cloud computing server, can obtain because network speed is different different services.Therefore,, in order accurately, intactly to monitor the performance of cloud computing service, need to dispose monitoring node in a lot of different regions and monitor.
And in prior art, the monitor task of all databases is all completed by unified monitoring cluster, bring too much load not only to monitoring cluster, and, once there are abnormal conditions in monitoring cluster, just cannot guarantee validity and the stability of database interior nodes monitoring, therefore how immediately monitoring database server extremely and how to guarantee to stablize instant adapter service be effectively provided, be problem demanding prompt solution always in the industry.
Summary of the invention
Embodiments of the invention provide a kind of method, database monitoring Apparatus and system of monitor database, when abnormal conditions appear in the each node of monitoring, to monitoring cluster sending node warning message, inform monitoring cluster, the load of not only sharing monitoring cluster has guaranteed validity and the stability of database monitoring simultaneously.
For achieving the above object, embodiments of the invention adopt following technical scheme:
Embodiments of the invention provide a kind of database monitoring system, comprise database monitoring device and monitoring cluster, wherein,
Described database monitoring device, for receiving the triggering command from monitoring cluster; Send the first instruction to load balancing apparatus, whether whether whether described the first instruction be used to indicate described load balancing apparatus and detect cluster and can exist with the software agent that refers to the each node in described cluster with, described cluster; Reception is from the first response message of described load balancing apparatus; If described the first response message indicates described cluster to use, scan the each node in described cluster, determine whether the each node in described cluster can be used, whether whether described each node can exist with the software agent that refers to described each node; If there is disabled node, generate and to described monitoring cluster sending node warning message, described node warning message is used to indicate disabled node;
Described monitoring cluster, be used for sending triggering command to database monitoring device, to make described database monitoring device send the first instruction to load balancing apparatus, whether described the first instruction is used to indicate described load balancing apparatus detection cluster and can uses, whether whether described cluster can exist with the software agent that refers to the each node in described cluster, described database monitoring device receives the first response message from described load balancing apparatus, if described the first response message indicates described cluster to use, described database monitoring device scans the each node in described cluster, determine whether the each node in described cluster can be used, whether whether described each node can exist with the software agent that refers to described each node, if described cluster is unavailable, receive the cluster warning message that described database monitoring device sends, it is unavailable that described cluster warning message is used to indicate described cluster, if there is disabled node, receive the node warning message that described database monitoring device sends, described node warning message is used to indicate disabled node.
If described the first response message indicates described cluster unavailable,
Described database monitoring device, for generation and to described monitoring cluster signalling of bouquet warning message, it is unavailable that described cluster warning message is used to indicate described cluster.
Described database monitoring device, also for calling monitor task table, described monitor task table comprise the node that needs monitoring ID, service access information, monitor task start-up time, whether be repetition monitor task sign, monitor task cycle; According to the each node calling in result access cluster, and then determine whether the each node in described cluster can be used.
, if also for there is disabled node, according to the ID of described monitor task table record respective nodes and service access information in described database monitoring device; According to node warning message described in the ID of described respective nodes and service access Information generation and be sent to described monitoring cluster.
Embodiments of the invention provide a kind of database monitoring device, comprising:
Receiving element, for receiving the triggering command from monitoring cluster; Reception is from the first response message of described load balancing apparatus;
Transmitting element, for sending the first instruction to load balancing apparatus, whether whether whether described the first instruction be used to indicate described load balancing apparatus and detect cluster and can exist with the software agent that refers to the each node in described cluster with, described cluster;
Processing unit, if indicate described cluster to use for described the first response message, scan the each node in described cluster, determine whether the each node in described cluster can be used, whether whether described each node can exist with the software agent that refers to described each node; If there is disabled node, generate and to described monitoring cluster sending node warning message, described node warning message is used to indicate disabled node.
Embodiments of the invention provide a kind of method of monitor database, comprising:
Reception is from the triggering command of monitoring cluster;
Send the first instruction to load balancing apparatus, whether whether whether described the first instruction be used to indicate described load balancing apparatus and detect cluster and can exist with the software agent that refers to the each node in described cluster with, described cluster;
Reception is from the first response message of described load balancing apparatus;
If described the first response message indicates described cluster to use, scan the each node in described cluster, determine whether the each node in described cluster can be used, whether whether described each node can exist with the software agent that refers to described each node;
If there is disabled node, generate and to described monitoring cluster sending node warning message, described node warning message is used to indicate disabled node.
If described the first response message indicates described cluster unavailable, generate and to described monitoring cluster signalling of bouquet warning message, it is unavailable that described cluster warning message is used to indicate described cluster.
Each node in the described cluster of described scanning, determines whether the each node in described cluster can be used, and comprising:
Call monitor task table, described monitor task table comprise the node that needs monitoring ID, service access information, monitor task start-up time, whether be repetition monitor task sign, monitor task cycle;
According to the each node calling in result access cluster, and then determine whether the each node in described cluster can be used.
If described, there is disabled node, generate and comprise to described monitoring cluster sending node warning message:
If there is disabled node, according to the ID of described monitor task table record respective nodes and service access information;
According to node warning message described in the ID of described respective nodes and service access Information generation and be sent to described monitoring cluster.
Embodiments of the invention provide a kind of method, database monitoring Apparatus and system of monitor database, by each cluster in monitor database and each node, know the ruuning situation of current database, when abnormal conditions appear in a certain node, to monitoring cluster sending node warning message, inform monitoring cluster, this scheme has guaranteed validity and the stability of database monitoring simultaneously in the load of sharing monitoring cluster.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, to the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, do not paying under the prerequisite of creative work, can also obtain according to these accompanying drawings other accompanying drawing.
The schematic flow sheet one of the method for a kind of monitor database that Fig. 1 provides for the embodiment of the present invention;
The schematic flow sheet two of the method for a kind of monitor database that Fig. 2 provides for the embodiment of the present invention;
The structural representation of a kind of database monitoring system that Fig. 3 provides for the embodiment of the present invention;
The structural representation of a kind of database monitoring device that Fig. 4 provides for the embodiment of the present invention.
Embodiment
In below describing, in order to illustrate rather than in order limiting, to have proposed the detail such as particular system structure, interface, technology, to thoroughly understand the present invention.But, it will be clear to one skilled in the art that and in other embodiment that there is no these details, also can realize the present invention.In other situation, omit the detailed description to well-known device, circuit and method, in order to avoid unnecessary details hinders description of the invention.
It should be noted that, the those skilled in the art that mention in the embodiment of the present invention, for supposing that he invents (or utility model) affiliated all ordinary skill knowledge of technical field before knowing the applying date or priority date, can know prior aries all in this field, and there is this date of application means and ability of normal experiment before, but he do not have creativity.If technical problem to be solved can impel those skilled in the art to find technological means in other technologies field, he also should have the ability of knowing this application day or priority date related art, ordinary skill knowledge and normal experiment means before from this other technologies field.
Embodiment mono-
Embodiments of the invention provide a kind of method of monitor database, as shown in Figure 1, comprising:
101, database monitoring device receives the triggering command from monitoring cluster.
Embodiments of the invention provide a kind of method of monitor database, database ruuning situation before knowing by each cluster in monitor database and each node, when abnormal conditions appear in a certain node, to monitoring cluster sending node warning message, inform monitoring cluster, this scheme has guaranteed validity and the stability of database monitoring simultaneously in the load of sharing monitoring cluster.
Concrete, it is a kind of passive monitoring method of monitoring cluster that is controlled by that embodiments of the invention provide a kind of method of monitor database, before database monitoring device carries out the real-time monitoring of database, can receive the triggering command from monitoring cluster, this triggering command referred database supervising device is monitored in real time with certain rule.Above-mentioned certain rule can comprise the mode of monitor node, sequentially and repetition period etc.
102, database monitoring device sends the first instruction to load balancing apparatus.
Wherein, whether above-mentioned the first instruction is used to indicate load balancing apparatus detection cluster and can uses, and whether whether this cluster can exist with the software agent that refers to the each node in cluster.Cluster (cluster) can be one group of computer, and they do as a wholely to user, to provide a group network resource, and wherein single computer system is exactly the node (node) of cluster.
Concrete, after database monitoring device receives the triggering command from monitoring cluster, database monitoring device sends the first instruction according to the monitoring order of this triggering command indication to load balancing apparatus, indication changes load balancing apparatus corresponding cluster is monitored, if the software agent of the each node in this cluster exists, can judge that so this cluster is available, accordingly, if in this cluster is not that the software agent of each node exists, there is the non-existent node of at least one software agent, this cluster is unavailable so, now this load balancing apparatus feeds back the first feedback message to database monitoring device.
103, database monitoring device receives the first response message from load balancing apparatus.
Concrete, at database monitoring device, send the first instruction to load balancing apparatus, whether load balancing apparatus detects corresponding cluster and can use, and then feeds back the first response message to database monitoring device, this first response message be used to indicate detected cluster can with or unavailable.
If 104 first response message indication clusters can be used, database monitoring device scans the each node in cluster, determines whether the each node in cluster can be used.
Wherein, whether whether above-mentioned each node can exist with the software agent that refers to each node.
Concrete, after database monitoring device receives the first response message from load balancing apparatus, if the first response message indication cluster can be used, database monitoring device calls monitor task table, monitor task table comprise the node that needs monitoring ID, service access information, monitor task start-up time, whether be repetition monitor task sign, monitor task cycle, and then database monitoring device is according to the each node calling in result access cluster, determines whether the each node in cluster can be used.It should be noted that, this monitor task table is that those skilled in the art are preset before operation this programme, and the option in this monitor task table can be formulated according to concrete monitor task scene.
If 105 exist disabled node, database monitoring device generates and to monitoring cluster sending node warning message.
Wherein, above-mentioned node warning message is used to indicate disabled node.
Concrete, each node in database monitoring device scanning cluster, after determining whether each node in cluster can be used, if there is disabled node, database monitoring device is according to the ID of monitor task table record respective nodes and service access information, and according to the ID of respective nodes and service access Information generation node warning message and be sent to monitoring cluster.
Embodiments of the invention provide a kind of method of monitor database, by receiving the triggering command from monitoring cluster; Send the first instruction to load balancing apparatus, whether whether whether the first instruction be used to indicate load balancing apparatus and detect cluster and can exist with the software agent that refers to the each node in cluster with, cluster; Reception is from the first response message of load balancing apparatus; If the first response message indication cluster can be used, scan the each node in cluster, determine whether the each node in cluster can be used, whether whether each node can exist with the software agent that refers to each node; If there is disabled node, generate and to monitoring cluster sending node warning message, node warning message is used to indicate disabled node.In this scheme, database monitoring device by each cluster in monitor database and each node, know before database ruuning situation, when abnormal conditions appear in a certain node, to monitoring cluster sending node warning message, inform monitoring cluster, this scheme has guaranteed validity and the stability of database monitoring simultaneously in the load of sharing monitoring cluster.
Embodiment bis-
Embodiments of the invention provide a kind of method of monitor database, as shown in Figure 3, comprising:
201, database monitoring device receives the triggering command from monitoring cluster.
Embodiments of the invention provide a kind of method of monitor database, database ruuning situation before knowing by each cluster in monitor database and each node, when abnormal conditions appear in a certain node, to monitoring cluster sending node warning message, inform monitoring cluster, this scheme has guaranteed validity and the stability of database monitoring simultaneously in the load of sharing monitoring cluster.
Concrete, it is a kind of passive monitoring method of monitoring cluster that is controlled by that embodiments of the invention provide a kind of method of monitor database, before database monitoring device carries out the real-time monitoring of database, can receive the triggering command from monitoring cluster, this triggering command referred database supervising device is monitored in real time with certain rule.Above-mentioned certain rule can comprise the mode of monitor node, sequentially and repetition period etc.
202, database monitoring device sends the first instruction to load balancing apparatus.
Wherein, whether above-mentioned the first instruction is used to indicate load balancing apparatus detection cluster and can uses, and whether whether this cluster can exist with the software agent that refers to the each node in cluster.Cluster (cluster) can be one group of computer, and they do as a wholely to user, to provide a group network resource, and wherein single computer system is exactly the node (node) of cluster.
Concrete, after database monitoring device receives the triggering command from monitoring cluster, database monitoring device sends the first instruction according to the monitoring order of this triggering command indication to load balancing apparatus, indication changes load balancing apparatus corresponding cluster is monitored, if the software agent of the each node in this cluster exists, can judge that so this cluster is available, accordingly, if in this cluster is not that the software agent of each node exists, there is the non-existent node of at least one software agent, this cluster is unavailable so, now this load balancing apparatus feeds back the first feedback message to database monitoring device.
203, database monitoring device receives the first response message from load balancing apparatus.
Concrete, at database monitoring device, send the first instruction to load balancing apparatus, whether load balancing apparatus detects corresponding cluster and can use, and then feeds back the first response message to database monitoring device, this first response message be used to indicate detected cluster can with or unavailable.
If 204 first response messages indications clusters are unavailable, database monitoring device generates and to monitoring cluster signalling of bouquet warning message.
Wherein, to be used to indicate cluster unavailable for above-mentioned cluster warning message.
Concrete, if receiving the first response message that load balancing apparatus sends, database monitoring device indicate cluster unavailable, database monitoring device signalling of bouquet warning message, to monitoring cluster, informs that this cluster of monitoring cluster is unavailable so.
If 205 first response message indication clusters can be used, database monitoring device calls monitor task table.
Wherein, above-mentioned monitor task table comprise the node that needs monitoring ID, service access information, monitor task start-up time, whether be repetition monitor task sign, monitor task cycle.It should be noted that, this monitor task table is that those skilled in the art are preset before operation this programme, and the option in this monitor task table can be formulated according to concrete monitor task scene.The monitor task table proposing in order more clearly to understand the embodiment of the present invention, as shown in table 1, we are exemplary provides a kind of possible monitor task table that calls.
Table 1
206, database monitoring device is accessed the each node in cluster according to calling result, and then whether the each node in definite cluster can be used.
Concrete, after database monitoring device receives the first response message from load balancing apparatus, if the first response message indication cluster can be used, database monitoring device calls monitor task table, monitor task table comprise the node that needs monitoring ID, service access information, monitor task start-up time, whether be repetition monitor task sign, monitor task cycle, and then database monitoring device is according to the each node calling in result access cluster, determines whether the each node in cluster can be used.
If 207 exist disabled node, database monitoring device is according to the ID of monitor task table record respective nodes and service access information.
208, database monitoring device is according to the ID of respective nodes and service access Information generation node warning message and be sent to monitoring cluster.
Wherein, above-mentioned node warning message is used to indicate disabled node.
Concrete, each node in database monitoring device scanning cluster, after determining whether each node in cluster can be used, if there is disabled node, database monitoring device is according to the ID of monitor task table record respective nodes and service access information, and according to the ID of respective nodes and service access Information generation node warning message and be sent to monitoring cluster.
Embodiments of the invention provide a kind of method of monitor database, by receiving the triggering command from monitoring cluster; Send the first instruction to load balancing apparatus, whether whether whether the first instruction be used to indicate load balancing apparatus and detect cluster and can exist with the software agent that refers to the each node in cluster with, cluster; Reception is from the first response message of load balancing apparatus; If the first response message indication cluster can be used, scan the each node in cluster, determine whether the each node in cluster can be used, whether whether each node can exist with the software agent that refers to each node; If there is disabled node, generate and to monitoring cluster sending node warning message, node warning message is used to indicate disabled node.In this scheme, database monitoring device by each cluster in monitor database and each node, know before database ruuning situation, when abnormal conditions appear in a certain node, to monitoring cluster sending node warning message, inform monitoring cluster, this scheme has guaranteed validity and the stability of database monitoring simultaneously in the load of sharing monitoring cluster.
Embodiment tri-
Embodiments of the invention provide a kind of database monitoring system, as shown in Figure 3, comprise database monitoring device 01 and monitoring cluster 02, wherein,
Database monitoring device 01, for receiving the triggering command from monitoring cluster; Send the first instruction to load balancing apparatus, whether whether whether the first instruction be used to indicate load balancing apparatus and detect cluster and can exist with the software agent that refers to the each node in cluster with, cluster; Reception is from the first response message of load balancing apparatus; If the first response message indication cluster can be used, scan the each node in cluster, determine whether the each node in cluster can be used, whether whether each node can exist with the software agent that refers to each node; If there is disabled node, generate and to monitoring cluster sending node warning message, node warning message is used to indicate disabled node;
Monitoring cluster 02, be used for sending triggering command to database monitoring device, so that obtain database supervising device, send the first instruction to load balancing apparatus, whether the first instruction is used to indicate load balancing apparatus detection cluster and can uses, whether whether cluster can exist with the software agent that refers to the each node in cluster, database monitoring device receives the first response message from load balancing apparatus, if the first response message indication cluster can be used, database monitoring device scans the each node in cluster, determine whether the each node in cluster can be used, whether whether each node can exist with the software agent that refers to each node, if cluster is unavailable, receive the cluster warning message that database monitoring device sends, it is unavailable that cluster warning message is used to indicate cluster, if there is disabled node, receive the node warning message that database monitoring device sends, node warning message is used to indicate disabled node.
Further, if the first response message indication cluster is unavailable,
Database monitoring device 01, for generation and to monitoring cluster signalling of bouquet warning message, it is unavailable that cluster warning message is used to indicate cluster.
Further, database monitoring device 01, also for calling monitor task table, monitor task table comprise the node that needs monitoring ID, service access information, monitor task start-up time, whether be repetition monitor task sign, monitor task cycle; According to the each node calling in result access cluster, and then whether the each node in definite cluster can be used.
Further,, if also for there is disabled node, according to the ID of monitor task table record respective nodes and service access information in database monitoring device 01; According to the ID of respective nodes and service access Information generation node warning message and be sent to monitoring cluster.
Embodiments of the invention provide a kind of database monitoring system, by receiving the triggering command from monitoring cluster; Send the first instruction to load balancing apparatus, whether whether whether the first instruction be used to indicate load balancing apparatus and detect cluster and can exist with the software agent that refers to the each node in cluster with, cluster; Reception is from the first response message of load balancing apparatus; If the first response message indication cluster can be used, scan the each node in cluster, determine whether the each node in cluster can be used, whether whether each node can exist with the software agent that refers to each node; If there is disabled node, generate and to monitoring cluster sending node warning message, node warning message is used to indicate disabled node.In this scheme, database monitoring device by each cluster in monitor database and each node, know before database ruuning situation, when abnormal conditions appear in a certain node, to monitoring cluster sending node warning message, inform monitoring cluster, this scheme has guaranteed validity and the stability of database monitoring simultaneously in the load of sharing monitoring cluster.
Embodiment tetra-
Embodiments of the invention provide a kind of database monitoring device, as shown in Figure 4, comprising:
Receiving element 11, for receiving the triggering command from monitoring cluster; Reception is from the first response message of load balancing apparatus;
Transmitting element 12, for sending the first instruction to load balancing apparatus, whether whether whether the first instruction be used to indicate load balancing apparatus and detect cluster and can exist with the software agent that refers to the each node in cluster with, cluster;
Processing unit 13, if can use for the first response message indication cluster, scans the each node in cluster, determines whether the each node in cluster can be used, and whether whether each node can exist with the software agent that refers to each node; If there is disabled node, generate and to monitoring cluster sending node warning message, node warning message is used to indicate disabled node.
Embodiments of the invention provide a kind of database monitoring device, by receiving the triggering command from monitoring cluster; Send the first instruction to load balancing apparatus, whether whether whether the first instruction be used to indicate load balancing apparatus and detect cluster and can exist with the software agent that refers to the each node in cluster with, cluster; Reception is from the first response message of load balancing apparatus; If the first response message indication cluster can be used, scan the each node in cluster, determine whether the each node in cluster can be used, whether whether each node can exist with the software agent that refers to each node; If there is disabled node, generate and to monitoring cluster sending node warning message, node warning message is used to indicate disabled node.In this scheme, database monitoring device by each cluster in monitor database and each node, know before database ruuning situation, when abnormal conditions appear in a certain node, to monitoring cluster sending node warning message, inform monitoring cluster, this scheme has guaranteed validity and the stability of database monitoring simultaneously in the load of sharing monitoring cluster.
Those skilled in the art can be well understood to, for convenience and simplicity of description, only with the division of above-mentioned each functional module, be illustrated, in practical application, can above-mentioned functions be distributed and by different functional modules, completed as required, the internal structure that is about to device is divided into different functional modules, to complete all or part of function described above.The system of foregoing description, the specific works process of device and unit, can, with reference to the corresponding process in preceding method embodiment, not repeat them here.
In the several embodiment that provide in the application, should be understood that, disclosed system, apparatus and method, can realize by another way.For example, device embodiment described above is only schematic, for example, the division of described module or unit, be only that a kind of logic function is divided, during actual realization, can have other dividing mode, for example multiple unit or assembly can in conjunction with or can be integrated into another system, or some features can ignore, or do not carry out.Another point, shown or discussed coupling each other or direct-coupling or communication connection can be by some interfaces, indirect coupling or the communication connection of device or unit can be electrically, machinery or other form.
The described unit as separating component explanation can or can not be also physically to separate, and the parts that show as unit can be or can not be also physical locations, can be positioned at a place, or also can be distributed in multiple network element.Can select according to the actual needs some or all of unit wherein to realize the object of the present embodiment scheme.
In addition, the each functional unit in each embodiment of the present invention can be integrated in a processing unit, can be also that the independent physics of unit exists, and also can be integrated in a unit two or more unit.Above-mentioned integrated unit both can adopt the form of hardware to realize, and also can adopt the form of SFU software functional unit to realize.
If described integrated unit is realized and during as production marketing independently or use, can be stored in a computer read/write memory medium using the form of SFU software functional unit.Based on such understanding, the all or part of of the part that technical scheme of the present invention contributes to prior art in essence in other words or this technical scheme can embody with the form of software product, this computer software product is stored in a storage medium, comprise that some instructions (can be personal computers in order to make a computer equipment, server, or the network equipment etc.) or processor (processor) carry out all or part of step of method described in each embodiment of the present invention.And aforesaid storage medium comprises: various media that can be program code stored such as USB flash disk, portable hard drive, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), magnetic disc or CDs.
The above; be only the specific embodiment of the present invention, but protection scope of the present invention is not limited to this, any be familiar with those skilled in the art the present invention disclose technical scope in; can expect easily changing or replacing, within all should being encompassed in protection scope of the present invention.Therefore, protection scope of the present invention should be as the criterion with the protection range of described claim.
Claims (9)
1. a database monitoring system, is characterized in that, comprises database monitoring device and monitoring cluster, wherein,
Described database monitoring device, for receiving the triggering command from monitoring cluster; Send the first instruction to load balancing apparatus, whether whether whether described the first instruction be used to indicate described load balancing apparatus and detect cluster and can exist with the software agent that refers to the each node in described cluster with, described cluster; Reception is from the first response message of described load balancing apparatus; If described the first response message indicates described cluster to use, scan the each node in described cluster, determine whether the each node in described cluster can be used, whether whether described each node can exist with the software agent that refers to described each node; If there is disabled node, generate and to described monitoring cluster sending node warning message, described node warning message is used to indicate disabled node;
Described monitoring cluster, be used for sending triggering command to database monitoring device, to make described database monitoring device send the first instruction to load balancing apparatus, whether described the first instruction is used to indicate described load balancing apparatus detection cluster and can uses, whether whether described cluster can exist with the software agent that refers to the each node in described cluster, described database monitoring device receives the first response message from described load balancing apparatus, if described the first response message indicates described cluster to use, described database monitoring device scans the each node in described cluster, determine whether the each node in described cluster can be used, whether whether described each node can exist with the software agent that refers to described each node, if described cluster is unavailable, receive the cluster warning message that described database monitoring device sends, it is unavailable that described cluster warning message is used to indicate described cluster, if there is disabled node, receive the node warning message that described database monitoring device sends, described node warning message is used to indicate disabled node.
2. system according to claim 1, is characterized in that, if described the first response message indicates described cluster unavailable,
Described database monitoring device, for generation and to described monitoring cluster signalling of bouquet warning message, it is unavailable that described cluster warning message is used to indicate described cluster.
3. system according to claim 1, is characterized in that,
Described database monitoring device, also for calling monitor task table, described monitor task table comprise the node that needs monitoring ID, service access information, monitor task start-up time, whether be repetition monitor task sign, monitor task cycle; According to the each node calling in result access cluster, and then determine whether the each node in described cluster can be used.
4. system according to claim 3, is characterized in that,
, if also for there is disabled node, according to the ID of described monitor task table record respective nodes and service access information in described database monitoring device; According to node warning message described in the ID of described respective nodes and service access Information generation and be sent to described monitoring cluster.
5. a database monitoring device, is characterized in that, is applied to database monitoring system, comprising:
Receiving element, for receiving the triggering command from monitoring cluster; Reception is from the first response message of described load balancing apparatus;
Transmitting element, for sending the first instruction to load balancing apparatus, whether whether whether described the first instruction be used to indicate described load balancing apparatus and detect cluster and can exist with the software agent that refers to the each node in described cluster with, described cluster;
Processing unit, if indicate described cluster to use for described the first response message, scan the each node in described cluster, determine whether the each node in described cluster can be used, whether whether described each node can exist with the software agent that refers to described each node; If there is disabled node, generate and to described monitoring cluster sending node warning message, described node warning message is used to indicate disabled node.
6. a method for monitor database, is characterized in that, is applied to database monitoring system, comprising:
Database monitoring device receives the triggering command from monitoring cluster;
Described database monitoring device sends the first instruction to load balancing apparatus, and whether whether whether described the first instruction be used to indicate described load balancing apparatus and detect cluster and can exist with the software agent that refers to the each node in described cluster with, described cluster;
Described database monitoring device receives the first response message from described load balancing apparatus;
If described the first response message indicates described cluster to use, described database monitoring device scans the each node in described cluster, determine whether the each node in described cluster can be used, whether whether described each node can exist with the software agent that refers to described each node;
If there is disabled node, generate and to described monitoring cluster sending node warning message, described node warning message is used to indicate disabled node.
7. method according to claim 6, is characterized in that,
If described the first response message indicates described cluster unavailable, described database monitoring device generates and to described monitoring cluster signalling of bouquet warning message, it is unavailable that described cluster warning message is used to indicate described cluster.
8. method according to claim 6, is characterized in that, described database monitoring device scans the each node in described cluster, determines whether the each node in described cluster can be used, and comprising:
Described database monitoring device calls monitor task table, described monitor task table comprise the node that needs monitoring ID, service access information, monitor task start-up time, whether be repetition monitor task sign, monitor task cycle;
Described database monitoring device is according to the each node calling in result access cluster, and then whether the each node in definite described cluster can be used.
9. method according to claim 8, is characterized in that, has disabled node if described, generates and comprises to described monitoring cluster sending node warning message:
If there is disabled node, described database monitoring device is according to the ID of described monitor task table record respective nodes and service access information;
Described database monitoring device is according to node warning message described in the ID of described respective nodes and service access Information generation and be sent to described monitoring cluster.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310740860.4A CN103746837A (en) | 2013-12-27 | 2013-12-27 | Database monitoring method, database monitoring device and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310740860.4A CN103746837A (en) | 2013-12-27 | 2013-12-27 | Database monitoring method, database monitoring device and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103746837A true CN103746837A (en) | 2014-04-23 |
Family
ID=50503828
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310740860.4A Pending CN103746837A (en) | 2013-12-27 | 2013-12-27 | Database monitoring method, database monitoring device and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103746837A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104811446A (en) * | 2015-04-18 | 2015-07-29 | 湖南涉外经济学院 | Novel network safety protection system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110213753A1 (en) * | 2010-02-26 | 2011-09-01 | Symantec Corporation | Systems and Methods for Managing Application Availability |
| CN102291275A (en) * | 2011-08-01 | 2011-12-21 | 烟台杰瑞网络商贸有限公司 | Server cluster monitoring technology and method |
| CN102571499A (en) * | 2012-02-14 | 2012-07-11 | 广州亦云信息技术有限公司 | Monitoring method of cloud database server cluster |
| CN102882909A (en) * | 2011-07-15 | 2013-01-16 | 易云捷讯科技（北京）有限公司 | Cloud computing service monitoring system and method thereof |
| CN103020524A (en) * | 2012-12-11 | 2013-04-03 | 北京奇虎科技有限公司 | Computer virus monitoring system |
| CN103236949A (en) * | 2013-04-27 | 2013-08-07 | 北京搜狐新媒体信息技术有限公司 | Monitoring method, device and system for server cluster |
-
2013
- 2013-12-27 CN CN201310740860.4A patent/CN103746837A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110213753A1 (en) * | 2010-02-26 | 2011-09-01 | Symantec Corporation | Systems and Methods for Managing Application Availability |
| CN102882909A (en) * | 2011-07-15 | 2013-01-16 | 易云捷讯科技（北京）有限公司 | Cloud computing service monitoring system and method thereof |
| CN102291275A (en) * | 2011-08-01 | 2011-12-21 | 烟台杰瑞网络商贸有限公司 | Server cluster monitoring technology and method |
| CN102571499A (en) * | 2012-02-14 | 2012-07-11 | 广州亦云信息技术有限公司 | Monitoring method of cloud database server cluster |
| CN103020524A (en) * | 2012-12-11 | 2013-04-03 | 北京奇虎科技有限公司 | Computer virus monitoring system |
| CN103236949A (en) * | 2013-04-27 | 2013-08-07 | 北京搜狐新媒体信息技术有限公司 | Monitoring method, device and system for server cluster |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104811446A (en) * | 2015-04-18 | 2015-07-29 | 湖南涉外经济学院 | Novel network safety protection system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9141491B2 (en) | Highly available server system based on cloud computing | |
| CN103605722A (en) | Method, device and equipment for database monitoring | |
| CN108023967B (en) | Data balancing method and device and management equipment in distributed storage system | |
| CN103036736B (en) | A kind of configuration equipment monitoring system based on data source and method | |
| CN104601492A (en) | Method and device for controlling business flow under NFV framework | |
| CN103763126A (en) | System and method for monitoring database and database monitoring device | |
| CN102346725A (en) | Message notification device and method for changing equipment configuration file | |
| CN104268061A (en) | Storage state monitoring mechanism for virtual machine | |
| CN103986604A (en) | Method and device for locating network fault | |
| CN103559124A (en) | Fast fault detection method and device | |
| CN105243004A (en) | Failure resource detection method and apparatus | |
| CN104410512A (en) | Resource monitoring alarm framework suitable for cloud computation and method thereof | |
| CN105162632A (en) | Automatic processing system for server cluster failures | |
| CN111045811A (en) | Task allocation method and device, electronic equipment and storage medium | |
| CN103441861A (en) | Method and device for generating data records | |
| CN112737800A (en) | Service node fault positioning method, call chain generation method and server | |
| CN108632106A (en) | System for monitoring service equipment | |
| CN105099763A (en) | Method and device for reminding lost connection of equipment | |
| CN104753992A (en) | Method, device and system for data storage and method and device for virtual platform failure recovery | |
| CN102929770B (en) | The monitoring and positioning method that Embedded Linux System User space task is exclusive | |
| CN104834584A (en) | Method and system for monitoring host computer hardware loads | |
| CN103186435A (en) | System error treatment method and server system applying same | |
| CN101060683B (en) | Warning information generation method and device for communication system | |
| CN105025179A (en) | Method and system for monitoring service agents of call center | |
| CN105045727A (en) | Method and equipment for accessing shared memories |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C41 | Transfer of patent application or patent right or utility model | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20160108 Address after: 100081 Beijing, Zhongguancun, South Street, No. 1, building 689, building 1153, No., No. 5 Applicant after: LETV CLOUD COMPUTING CO., LTD. Address before: Room six, building 19, building 68, No. 100089 South Road, Haidian District, Beijing Applicant before: LeTV Information Technology (Beijing) Co., Ltd. |
|
| AD01 | Patent right deemed abandoned |
Effective date of abandoning: 20181102 |
|
| AD01 | Patent right deemed abandoned |