CN103763126A - System and method for monitoring database and database monitoring device - Google Patents
System and method for monitoring database and database monitoring device Download PDFInfo
- Publication number
- CN103763126A CN103763126A CN201310741558.0A CN201310741558A CN103763126A CN 103763126 A CN103763126 A CN 103763126A CN 201310741558 A CN201310741558 A CN 201310741558A CN 103763126 A CN103763126 A CN 103763126A
- Authority
- CN
- China
- Prior art keywords
- node
- monitoring device
- characteristic information
- database monitoring
- database
- 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
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention provides a system and method for monitoring a database and a database monitoring device, and relates to the technical field of database systems. When the fact that abnormal conditions happen to nodes is monitored, node alarming information is sent to the monitoring system to inform the monitoring system, loads of the monitoring system are shared, and meanwhile monitoring initiative performance and stability of the database are ensured. According to the scheme, the database monitoring device conducts scanning to obtain feature information of a first node, and the feature information comprises a myisam engine table, a specified partition, use rate of partitions, a wsrep-ready label, an error label, a warning label, a process closing label, and at least one of the connecting number of first nodes. If the feature information meets the preset condition, the database monitoring device generates node alarming information, and the node alarming information is used for indicating that the first nodes cannot be used. The database monitoring device sends the node alarming information to the monitoring system.
Description
Technical field
The present invention relates to Database Systems technical field, relate in particular to system, method and the database monitoring device 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 supervisory control system, not only to supervisory control system, bring too much load, and, once there are abnormal conditions in supervisory control system, 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 system, method and database monitoring device of monitor database, when abnormal conditions appear in the each node of monitoring, initiatively to supervisory control system sending node warning message, inform supervisory control system, the load of not only sharing supervisory control system has guaranteed initiative 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 scanning the characteristic information that obtains first node, described characteristic information comprises myisam engine table, at least one in the utilization rate of specified partition, each subregion, the linking number that wsrep-ready identifies, error identifies, warning identifies, process is closed sign, described first node; If it is pre-conditioned that described characteristic information meets, generate node warning message, it is unavailable that described node warning message is used to indicate described first node; Send described node warning message to supervisory control system;
Described monitoring cluster, if for there is disabled node, receives the node warning message that described database monitoring device sends, and described node warning message is used to indicate disabled node.
Embodiments of the invention provide a kind of method of monitor database, are applied to database monitoring system, comprising:
The characteristic information of first node is obtained in the scanning of database monitoring device, described characteristic information comprises myisam engine table, at least one in the utilization rate of specified partition, each subregion, the linking number that wsrep-ready identifies, error identifies, warning identifies, process is closed sign, described first node;
If it is pre-conditioned that described characteristic information meets, described database monitoring device generates node warning message, and it is unavailable that described node warning message is used to indicate described first node;
Described database monitoring device sends described node warning message to supervisory control system.
Described database monitoring device scanning comprises after obtaining the characteristic information of first node:
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 determined described first node according to the ID of described node;
Described database monitoring device, according to the task items of described first node correspondence in described monitor task table, conducts interviews and obtains described characteristic information described first node.
Described database monitoring device determines that described characteristic information meets pre-conditioned method, comprising:
If showing, described characteristic information in described first node, there is described myisam engine table, in described first node, there is not specified partition, the utilization rate of each subregion of described first node is greater than the first threshold value, in described first node, there is not wsrep-ready sign, in described first node, there is error sign, in described first node, there is warning sign, in described first node, exist process to close sign and the linking number of described first node and be greater than one or more in the second threshold value, described database monitoring device determines that described characteristic information meets pre-conditioned.
If it is pre-conditioned that described characteristic information meets, described database monitoring device generates node warning message, comprising:
If it is pre-conditioned that described characteristic information meets, described database monitoring device records the ID of described first node and meets pre-conditioned characteristic information;
According to the ID of described first node and meet pre-conditioned characteristic information and generate described node warning message and be sent to described supervisory control system.
If including, the characteristic information of described first node whether there is myisam engine table,
Described database monitoring device sends the first instruction to load balancing apparatus, and described the first instruction is used to indicate described load balancing apparatus and detects whether there is myisam engine table;
If receive from the feedback information indication of described load balancing apparatus and have described myisam engine table, described database monitoring device generates node warning message.
Embodiments of the invention provide a kind of database monitoring device, are applied to database monitoring system, comprising:
Scanning element, for the scanning of database monitoring device, obtain the characteristic information of first node, described characteristic information comprises myisam engine table, at least one in the utilization rate of specified partition, each subregion, the linking number that wsrep-ready identifies, error identifies, warning identifies, process is closed sign, described first node;
Processing unit, if meet pre-conditionedly for described characteristic information, described database monitoring device generates node warning message, it is unavailable that described node warning message is used to indicate described first node;
Transmit-Receive Unit, sends described node warning message to supervisory control system for described database monitoring device.
Described processing unit, calls monitor task table for described database monitoring device, 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 determined described first node according to the ID of described node; Described database monitoring device, according to the task items of described first node correspondence in described monitor task table, conducts interviews and obtains described characteristic information described first node.
Described processing unit, if meet pre-conditionedly for described characteristic information, described database monitoring device records the ID of described first node and meets pre-conditioned characteristic information; According to the ID of described first node and meet pre-conditioned characteristic information and generate described node warning message and be sent to described supervisory control system.
If including, the characteristic information of described first node whether there is myisam engine table,
Described Transmit-Receive Unit, also sends the first instruction to load balancing apparatus for described database monitoring device, and described the first instruction is used to indicate described load balancing apparatus and detects whether there is myisam engine table; If receive from the feedback information indication of described load balancing apparatus and have described myisam engine table, described database monitoring device generates node warning message.
Embodiments of the invention provide a kind of system, method and database monitoring device of monitor database, by each node in monitor database, know the ruuning situation of current database, when abnormal conditions appear in a certain node, initiatively to supervisory control system sending node warning message, inform supervisory control system, this scheme has guaranteed initiative and the stability of database monitoring simultaneously in the load of sharing supervisory control system.
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 the monitor database that Fig. 1 provides for the embodiment of the present invention;
The schematic flow sheet two of the method for the monitor database that Fig. 2 provides for the embodiment of the present invention;
The structural representation of the database monitoring device that Fig. 3 provides for the embodiment of the present invention;
The structural representation of the database monitoring system 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, the characteristic information of first node is obtained in the scanning of database monitoring device.
Wherein, above-mentioned characteristic information comprises whether there is myisam engine table, whether exist specified partition, each subregion utilization rate, whether there is wsrep-ready sign, whether have error sign, whether have warning sign, whether exist process to close at least one in sign, linking number.
Wherein, Myisam is default storage engine.Its ISAM code based on older, but have a lot of useful expansions, each Myisam is stored as three files on disk, and the name of first file starts with the name of table, and extension name is pointed out file type.Second file is the definition of .frm file storage list.The 3rd expansion that file is data file .MYD (MYData) by name.Myisam supports three kinds of different storage formats, and wherein two (being set form and dynamic format) selected automatically according to the type of the row of use just, and the 3rd is compressed format, can only create with myisampack instrument.
Partitions of database refers to logical node, on a machine, can contain multiple nodes, and each logical node has a set of process and serves for it.And node group is the group of logical node, namely database subregion, the table space of database is based upon on node group, therefore the container of this table space just can be built on different logical nodes, these logical nodes can be on a physical machine, also can be not on a physical machine, and the purpose of partitions of database is, convenient design and the management that data are distributed, for example, if wish, some being completed to data that set the goal is evenly distributed on multiple nodes, and these data are included in multiple table spaces, page-size is also inconsistent, but have, a bit they are consistent, be exactly on data distribute, all wish to be distributed on certain several node, therefore utilize partitions of database just can realize above-mentioned target.
Concrete, database monitoring device calls monitor task table, this 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 determined first node according to the ID of node; Final data storehouse supervising device, according to the task items of first node correspondence in monitor task table, conducts interviews and obtains characteristic information first node.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
If it is pre-conditioned that 102 characteristic informations meet, database monitoring device generates node warning message.
Wherein, to be used to indicate first node unavailable for above-mentioned node warning message.
Embodiments of the invention provide a kind of method of monitor database, by each node in monitor database, know the ruuning situation of current database, when abnormal conditions appear in a certain node, initiatively to supervisory control system sending node warning message, inform supervisory control system, this scheme has guaranteed initiative and the stability of database monitoring simultaneously in the load of sharing supervisory control system.
Concrete, characteristic information meets pre-conditioned concrete determination methods and comprises:
If scanning result shows the linking number that has myisam engine table, does not exist the utilization rate of each subregion of specified partition, first node to be greater than the first threshold value, does not have wsrep-ready sign, has error sign, has warning sign, exists process to close sign and first node and be greater than one or more in the second threshold value, judging characteristic information meets pre-conditioned.
103, database monitoring device sending node warning message is to supervisory control system.
Concrete, after database monitoring device generates node warning message, pre-conditioned if characteristic information meets, database monitoring device records the ID of first node and meets pre-conditioned characteristic information; Database monitoring device is according to the ID of first node and meet pre-conditioned characteristic information and generate node warning message and be sent to supervisory control system.
In addition, database monitoring device sending node warning message to the mode of supervisory control system can be undertaken by various ways such as phone, mail and notes, and database monitoring device can preset corresponding node warning message and warning degree height between relation.For example, if exist process to close sign, database monitoring device to supervisory control system, and informs that this alarm level of supervisory control system is high-grade with mail form sending node warning message.
Embodiments of the invention provide a kind of method of monitor database, by scanning, obtain the characteristic information of first node, characteristic information comprises whether there is myisam engine table, whether exist specified partition, each subregion utilization rate, whether there is wsrep-ready sign, whether have error sign, whether have warning sign, whether exist process to close at least one in sign, linking number; If characteristic information meets pre-conditioned, generate node warning message, it is unavailable that node warning message is used to indicate first node; Sending node warning message is to supervisory control system.In this scheme, database monitoring device is known the ruuning situation of current database by each node in monitor database, when abnormal conditions appear in a certain node, initiatively to supervisory control system sending node warning message, inform supervisory control system, this scheme has guaranteed initiative and the stability of database monitoring simultaneously in the load of sharing supervisory control system.
Embodiment bis-
Embodiments of the invention provide a kind of method of monitor database, as shown in Figure 2, comprising:
201, database monitoring device calls monitor task table and then definite first node.
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.
Concrete, database monitoring device calls monitor task table, this 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 determined first node according to the ID of node; Final data storehouse supervising device, according to the task items of first node correspondence in monitor task table, conducts interviews and obtains characteristic information first node.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 2, we are exemplary provides a kind of possible monitor task table that calls.
Table 2
202, database monitoring device, according to the task items of first node correspondence in monitor task table, conducts interviews and obtains characteristic information first node.
Wherein, above-mentioned characteristic information comprises whether there is myisam engine table, whether exist specified partition, each subregion utilization rate, whether there is wsrep-ready sign, whether have error sign, whether have warning sign, whether exist process to close at least one in sign, linking number.
Wherein, Myisam is default storage engine.Its ISAM code based on older, but have a lot of useful expansions, each Myisam is stored as three files on disk, and the name of first file starts with the name of table, and extension name is pointed out file type.Second file is the definition of .frm file storage list.The 3rd expansion that file is data file .MYD (MYData) by name.Myisam supports three kinds of different storage formats, and wherein two (being set form and dynamic format) selected automatically according to the type of the row of use just, and the 3rd is compressed format, can only create with myisampack instrument.
Partitions of database refers to logical node, on a machine, can contain multiple nodes, and each logical node has a set of process and serves for it.And node group is the group of logical node, namely database subregion, the table space of database is based upon on node group, therefore the container of this table space just can be built on different logical nodes, these logical nodes can be on a physical machine, also can be not on a physical machine, and the purpose of partitions of database is, convenient design and the management that data are distributed, for example, if wish, some being completed to data that set the goal is evenly distributed on multiple nodes, and these data are included in multiple table spaces, page-size is also inconsistent, but have, a bit they are consistent, be exactly on data distribute, all wish to be distributed on certain several node, therefore utilize partitions of database just can realize above-mentioned target.
If it is pre-conditioned that 203 characteristic informations meet, database monitoring device generates node warning message, and it is unavailable that node warning message is used to indicate first node.
Wherein, to be used to indicate first node unavailable for above-mentioned node warning message.
Embodiments of the invention provide a kind of method of monitor database, by each node in monitor database, know the ruuning situation of current database, when abnormal conditions appear in a certain node, initiatively to supervisory control system sending node warning message, inform supervisory control system, this scheme has guaranteed initiative and the stability of database monitoring simultaneously in the load of sharing supervisory control system.
Concrete, characteristic information meets pre-conditioned concrete determination methods and comprises:
If scanning result shows the linking number that has myisam engine table, does not exist the utilization rate of each subregion of specified partition, first node to be greater than the first threshold value, does not have wsrep-ready sign, has error sign, has warning sign, exists process to close sign and first node and be greater than one or more in the second threshold value, judging characteristic information meets pre-conditioned.
If it is pre-conditioned that 204 characteristic informations meet, database monitoring device records the ID of first node and meets pre-conditioned characteristic information.
Exemplary, if the utilization rate of the first subregion of node 1 is greater than the first threshold value 60%, the characteristic information of database monitoring device decision node 1 meets pre-conditioned so, now database monitoring device records the utilization rate 60% of the ID of node 1 and the first subregion of node 1 according to task items corresponding in monitor task table, so that database monitoring device generates node warning message and is sent to supervisory control system, inform that the utilization rate of the first subregion of supervisory control system node 1 overloads.
205, database monitoring device is according to the ID of first node and meet pre-conditioned characteristic information and generate node warning message and be sent to supervisory control system.
Concrete, after database monitoring device generates node warning message, pre-conditioned if characteristic information meets, database monitoring device records the ID of first node and meets pre-conditioned characteristic information; Database monitoring device is according to the ID of first node and meet pre-conditioned characteristic information and generate node warning message and be sent to supervisory control system.
Further, if the characteristic information of first node includes, whether have myisam engine table, database monitoring device sends the first instruction to load balancing apparatus, and the first instruction is used to indicate load balancing apparatus and detects whether there is myisam engine table; If receive from the feedback information indication of load balancing apparatus and have myisam engine table, database monitoring device generates node warning message and is sent to detection system.
Embodiments of the invention provide a kind of method of monitor database, by scanning, obtain the characteristic information of first node, characteristic information comprises whether there is myisam engine table, whether exist specified partition, each subregion utilization rate, whether there is wsrep-ready sign, whether have error sign, whether have warning sign, whether exist process to close at least one in sign, linking number; If characteristic information meets pre-conditioned, generate node warning message, it is unavailable that node warning message is used to indicate first node; Sending node warning message is to supervisory control system.In this scheme, database monitoring device is known the ruuning situation of current database by each node in monitor database, when abnormal conditions appear in a certain node, initiatively to supervisory control system sending node warning message, inform supervisory control system, this scheme has guaranteed initiative and the stability of database monitoring simultaneously in the load of sharing supervisory control system.
Embodiment tri-
Embodiments of the invention provide a kind of database monitoring device, are applied to database monitoring system, as shown in Figure 3, comprising:
Scanning element 01, for the scanning of database monitoring device, obtain the characteristic information of first node, described characteristic information comprises myisam engine table, at least one in the utilization rate of specified partition, each subregion, the linking number that wsrep-ready identifies, error identifies, warning identifies, process is closed sign, described first node;
Processing unit 02, if meet pre-conditionedly for described characteristic information, described database monitoring device generates node warning message, it is unavailable that described node warning message is used to indicate described first node;
Transmit-Receive Unit 03, sends described node warning message to supervisory control system for described database monitoring device.
Further, described processing unit 02, call monitor task table for described database monitoring device, 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 determined described first node according to the ID of described node; Described database monitoring device, according to the task items of described first node correspondence in described monitor task table, conducts interviews and obtains described characteristic information described first node.
Further, described processing unit 02, if meet pre-conditionedly for described characteristic information, described database monitoring device records the ID of described first node and meets pre-conditioned characteristic information; According to the ID of described first node and meet pre-conditioned characteristic information and generate described node warning message and be sent to described supervisory control system.
Further, if including, the characteristic information of described first node whether there is myisam engine table,
Described Transmit-Receive Unit 03, also sends the first instruction to load balancing apparatus for described database monitoring device, and described the first instruction is used to indicate described load balancing apparatus and detects whether there is myisam engine table; If receive from the feedback information indication of described load balancing apparatus and have described myisam engine table, described database monitoring device generates node warning message.
Embodiments of the invention provide a kind of database monitoring device, by scanning, obtain the characteristic information of first node, characteristic information comprises whether there is myisam engine table, whether exist specified partition, each subregion utilization rate, whether there is wsrep-ready sign, whether have error sign, whether have warning sign, whether exist process to close at least one in sign, linking number; If characteristic information meets pre-conditioned, generate node warning message, it is unavailable that node warning message is used to indicate first node; Sending node warning message is to supervisory control system.In this scheme, database monitoring device is known the ruuning situation of current database by each node in monitor database, when abnormal conditions appear in a certain node, initiatively to supervisory control system sending node warning message, inform supervisory control system, this scheme has guaranteed initiative and the stability of database monitoring simultaneously in the load of sharing supervisory control system.
Embodiment tetra-
Embodiments of the invention provide a kind of database monitoring system, as shown in Figure 4, comprise database monitoring device 11 and monitoring cluster 12, wherein,
Described database monitoring device 11, for scanning the characteristic information that obtains first node, described characteristic information comprises myisam engine table, at least one in the utilization rate of specified partition, each subregion, the linking number that wsrep-ready identifies, error identifies, warning identifies, process is closed sign, described first node; If it is pre-conditioned that described characteristic information meets, generate node warning message, it is unavailable that described node warning message is used to indicate described first node; Send described node warning message to supervisory control system;
Described monitoring cluster 12, if for there is disabled node, receives the node warning message that described database monitoring device sends, and described node warning message is used to indicate disabled node.
Embodiments of the invention provide a kind of database monitoring system, by scanning, obtain the characteristic information of first node, characteristic information comprises whether there is myisam engine table, whether exist specified partition, each subregion utilization rate, whether there is wsrep-ready sign, whether have error sign, whether have warning sign, whether exist process to close at least one in sign, linking number; If characteristic information meets pre-conditioned, generate node warning message, it is unavailable that node warning message is used to indicate first node; Sending node warning message is to supervisory control system.In this scheme, database monitoring device is known the ruuning situation of current database by each node in monitor database, when abnormal conditions appear in a certain node, initiatively to supervisory control system sending node warning message, inform supervisory control system, this scheme has guaranteed initiative and the stability of database monitoring simultaneously in the load of sharing supervisory control system.
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 (10)
1. a database monitoring system, is characterized in that, comprises database monitoring device and monitoring cluster, wherein,
Described database monitoring device, for scanning the characteristic information that obtains first node, described characteristic information comprises myisam engine table, at least one in the utilization rate of specified partition, each subregion, the linking number that wsrep-ready identifies, error identifies, warning identifies, process is closed sign, described first node; If it is pre-conditioned that described characteristic information meets, generate node warning message, it is unavailable that described node warning message is used to indicate described first node; Send described node warning message to supervisory control system;
Described monitoring cluster, if for there is disabled node, receives the node warning message that described database monitoring device sends, and described node warning message is used to indicate disabled node.
2. a method for monitor database, is characterized in that, is applied to database monitoring system, comprising:
The characteristic information of first node is obtained in the scanning of database monitoring device, described characteristic information comprises myisam engine table, at least one in the utilization rate of specified partition, each subregion, the linking number that wsrep-ready identifies, error identifies, warning identifies, process is closed sign, described first node;
If it is pre-conditioned that described characteristic information meets, described database monitoring device generates node warning message, and it is unavailable that described node warning message is used to indicate described first node;
Described database monitoring device sends described node warning message to supervisory control system.
3. method according to claim 2, is characterized in that, described database monitoring device scanning comprises after obtaining the characteristic information of first node:
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 determined described first node according to the ID of described node;
Described database monitoring device, according to the task items of described first node correspondence in described monitor task table, conducts interviews and obtains described characteristic information described first node.
4. method according to claim 2, is characterized in that, described database monitoring device determines that described characteristic information meets pre-conditioned method, comprising:
If showing, described characteristic information in described first node, there is described myisam engine table, in described first node, there is not specified partition, the utilization rate of each subregion of described first node is greater than the first threshold value, in described first node, there is not wsrep-ready sign, in described first node, there is error sign, in described first node, there is warning sign, in described first node, exist process to close sign and the linking number of described first node and be greater than one or more in the second threshold value, described database monitoring device determines that described characteristic information meets pre-conditioned.
5. according to the method described in any one in claim 2 to 4, it is characterized in that, pre-conditioned if described characteristic information meets, described database monitoring device generates node warning message, comprising:
If it is pre-conditioned that described characteristic information meets, described database monitoring device records the ID of described first node and meets pre-conditioned characteristic information;
According to the ID of described first node and meet pre-conditioned characteristic information and generate described node warning message and be sent to described supervisory control system.
6. according to the method described in any one in claim 2 to 4, it is characterized in that if the characteristic information of described first node includes, whether have myisam engine table,
Described database monitoring device sends the first instruction to load balancing apparatus, and described the first instruction is used to indicate described load balancing apparatus and detects whether there is myisam engine table;
If receive from the feedback information indication of described load balancing apparatus and have described myisam engine table, described database monitoring device generates node warning message.
7. a database monitoring device, is characterized in that, is applied to database monitoring system, comprising:
Scanning element, for the scanning of database monitoring device, obtain the characteristic information of first node, described characteristic information comprises myisam engine table, at least one in the utilization rate of specified partition, each subregion, the linking number that wsrep-ready identifies, error identifies, warning identifies, process is closed sign, described first node;
Processing unit, if meet pre-conditionedly for described characteristic information, described database monitoring device generates node warning message, it is unavailable that described node warning message is used to indicate described first node;
Transmit-Receive Unit, sends described node warning message to supervisory control system for described database monitoring device.
8. device according to claim 7, is characterized in that,
Described processing unit, calls monitor task table for described database monitoring device, 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 determined described first node according to the ID of described node; Described database monitoring device, according to the task items of described first node correspondence in described monitor task table, conducts interviews and obtains described characteristic information described first node.
9. according to the device described in claim 7 or 8, it is characterized in that,
Described processing unit, if meet pre-conditionedly for described characteristic information, described database monitoring device records the ID of described first node and meets pre-conditioned characteristic information; According to the ID of described first node and meet pre-conditioned characteristic information and generate described node warning message and be sent to described supervisory control system.
10. according to the device described in claim 7 or 8, it is characterized in that if the characteristic information of described first node includes, whether have myisam engine table,
Described Transmit-Receive Unit, also sends the first instruction to load balancing apparatus for described database monitoring device, and described the first instruction is used to indicate described load balancing apparatus and detects whether there is myisam engine table; If receive from the feedback information indication of described load balancing apparatus and have described myisam engine table, described database monitoring device generates node warning message.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310741558.0A CN103763126A (en) | 2013-12-27 | 2013-12-27 | System and method for monitoring database and database monitoring device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310741558.0A CN103763126A (en) | 2013-12-27 | 2013-12-27 | System and method for monitoring database and database monitoring device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103763126A true CN103763126A (en) | 2014-04-30 |
Family
ID=50530289
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310741558.0A Pending CN103763126A (en) | 2013-12-27 | 2013-12-27 | System and method for monitoring database and database monitoring device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103763126A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103986599A (en) * | 2014-05-14 | 2014-08-13 | 上海上讯信息技术股份有限公司 | Operation and maintenance alarm system and method for network equipment |
| CN105893226A (en) * | 2015-11-13 | 2016-08-24 | 乐视云计算有限公司 | Service monitoring system |
| CN107943471A (en) * | 2017-11-29 | 2018-04-20 | 郑州云海信息技术有限公司 | Carry out the method in monitoring data storehouse in a kind of Linux dual systems using program |
| CN108509639A (en) * | 2018-04-11 | 2018-09-07 | 武汉斗鱼网络科技有限公司 | Table approaches to IM, device and readable storage medium storing program for executing |
| CN109254896A (en) * | 2018-08-31 | 2019-01-22 | 北京奇虎科技有限公司 | Acquisition methods, device, terminal device and the storage medium of engine monitoring data |
| CN109359158A (en) * | 2018-08-22 | 2019-02-19 | 中国联合网络通信集团有限公司 | Method of data synchronization, device and storage medium |
| CN113485887A (en) * | 2021-06-29 | 2021-10-08 | 上海众言网络科技有限公司 | Database monitoring method and device, electronic equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120079596A1 (en) * | 2010-08-26 | 2012-03-29 | Verisign, Inc. | Method and system for automatic detection and analysis of malware |
| CN102882909A (en) * | 2011-07-15 | 2013-01-16 | 易云捷讯科技（北京）有限公司 | Cloud computing service monitoring system and method thereof |
| CN102938710A (en) * | 2012-11-14 | 2013-02-20 | 北京奇虎科技有限公司 | Monitoring system and method for large-scale servers |
| CN103414579A (en) * | 2013-07-24 | 2013-11-27 | 广东电子工业研究院有限公司 | Cross-platform monitoring system applicable to cloud computing and monitoring method thereof |
| CN103475544A (en) * | 2013-09-18 | 2013-12-25 | 浪潮电子信息产业股份有限公司 | Service monitoring method based on cloud resource monitoring platform |
-
2013
- 2013-12-27 CN CN201310741558.0A patent/CN103763126A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120079596A1 (en) * | 2010-08-26 | 2012-03-29 | Verisign, Inc. | Method and system for automatic detection and analysis of malware |
| CN102882909A (en) * | 2011-07-15 | 2013-01-16 | 易云捷讯科技（北京）有限公司 | Cloud computing service monitoring system and method thereof |
| CN102938710A (en) * | 2012-11-14 | 2013-02-20 | 北京奇虎科技有限公司 | Monitoring system and method for large-scale servers |
| CN103414579A (en) * | 2013-07-24 | 2013-11-27 | 广东电子工业研究院有限公司 | Cross-platform monitoring system applicable to cloud computing and monitoring method thereof |
| CN103475544A (en) * | 2013-09-18 | 2013-12-25 | 浪潮电子信息产业股份有限公司 | Service monitoring method based on cloud resource monitoring platform |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103986599A (en) * | 2014-05-14 | 2014-08-13 | 上海上讯信息技术股份有限公司 | Operation and maintenance alarm system and method for network equipment |
| CN105893226A (en) * | 2015-11-13 | 2016-08-24 | 乐视云计算有限公司 | Service monitoring system |
| CN107943471A (en) * | 2017-11-29 | 2018-04-20 | 郑州云海信息技术有限公司 | Carry out the method in monitoring data storehouse in a kind of Linux dual systems using program |
| CN108509639A (en) * | 2018-04-11 | 2018-09-07 | 武汉斗鱼网络科技有限公司 | Table approaches to IM, device and readable storage medium storing program for executing |
| CN108509639B (en) * | 2018-04-11 | 2021-04-23 | 武汉斗鱼网络科技有限公司 | Table information management method, device and readable storage medium |
| CN109359158A (en) * | 2018-08-22 | 2019-02-19 | 中国联合网络通信集团有限公司 | Method of data synchronization, device and storage medium |
| CN109254896A (en) * | 2018-08-31 | 2019-01-22 | 北京奇虎科技有限公司 | Acquisition methods, device, terminal device and the storage medium of engine monitoring data |
| CN113485887A (en) * | 2021-06-29 | 2021-10-08 | 上海众言网络科技有限公司 | Database monitoring method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103763126A (en) | System and method for monitoring database and database monitoring device | |
| WO2023142054A1 (en) | Container microservice-oriented performance monitoring and alarm method and alarm system | |
| CN103605722A (en) | Method, device and equipment for database monitoring | |
| EP3306476B1 (en) | Method and apparatus for hot cpu removal and hot cpu adding during operation | |
| CN105808407A (en) | Equipment management method, equipment and equipment management controller | |
| CN103210379A (en) | Server system, management method and device | |
| CN105871581A (en) | Method and device for processing of alarm information in cloud calculation | |
| CN103399781A (en) | Cloud server and virtual machine management method thereof | |
| CN109447287A (en) | Multiple-energy-source operational system method for building up and terminal device | |
| JPWO2013018288A1 (en) | Computer and resource search method | |
| CN111240876A (en) | Fault positioning method and device for microservice, storage medium and terminal | |
| CN112348213A (en) | Operation and maintenance troubleshooting implementation method, device, medium and equipment | |
| CN114637650A (en) | Elastic expansion method based on Kubernetes cluster | |
| CN109918354B (en) | HDFS-based disk positioning method, device, equipment and medium | |
| CN104753992A (en) | Method, device and system for data storage and method and device for virtual platform failure recovery | |
| CN103824017A (en) | Method and platform for monitoring rogue programs | |
| CN117435335A (en) | Computing power dispatching method, computing power dispatching device, computer equipment and storage medium | |
| CN109062515A (en) | A kind of disk management method, system and associated component | |
| CN106293890A (en) | A kind of method and device for business processing based on complexity | |
| CN115150253B (en) | Fault root cause determining method and device and electronic equipment | |
| CN107122254A (en) | A kind of computer repairs control method and system, restorative procedure and system | |
| CN115643163A (en) | Fault equipment positioning method, device, equipment and storage medium | |
| CN115687026A (en) | Multi-node server fault early warning method, device, equipment and medium | |
| CN106156069B (en) | Log system and log recording method | |
| CN103746837A (en) | Database monitoring method, database monitoring device and system |
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: 20190104 |
|
| AD01 | Patent right deemed abandoned |