CN102968365A - Central monitoring method for running statuses of databases in Web manner - Google Patents
Central monitoring method for running statuses of databases in Web manner Download PDFInfo
- Publication number
- CN102968365A CN102968365A CN2012105246210A CN201210524621A CN102968365A CN 102968365 A CN102968365 A CN 102968365A CN 2012105246210 A CN2012105246210 A CN 2012105246210A CN 201210524621 A CN201210524621 A CN 201210524621A CN 102968365 A CN102968365 A CN 102968365A
- Authority
- CN
- China
- Prior art keywords
- database
- monitoring
- agent
- return
- server
- 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
Abstract
The invention discloses a central monitoring method for running statuses of databases in a Web manner, which can be realized just by an Agent based on a dynamic webpage document. Conventionally, the running statuses of databases are monitored generally by monitoring progresses, that is, special programs are installed on different database servers to monitor progress statuses corresponding to the database servers, so that the running condition of the databases is judged. Different from the conventional monitoring manner to progress statuses, the method has the characteristics of low cost, strong universality, high efficiency and good performance.
Description
Technical field
The present invention relates to a kind ofly based on the Web mode a plurality of database running statuses be concentrated the method for monitoring.
Background technology
Along with the lifting of infosystem status in enterprise's daily management, enterprise is also more and more higher to the dependence of operating information system; Simultaneously, the operation of operating information system is also more and more tightr to the degree of dependence of database server, and the stability of database server operation is directly connected to the application of operating information system.Particularly for the higher enterprise of information-based degree of dependence, the healthy and stable operation of operation system is most important to its daily operation control, it is unexpected that the database server fault directly affect the operation of operating information system, affects normally carrying out in order of enterprise's day to day operation.Therefore, in time find the ruuning situation of database, seem particularly important thereby in time fault is responded to process.
Current, the overwhelming majority of database all adopts the ORACLE database, SQL SERVER database; Business application system is accomplished in several ways the access (relational database is as at present the most frequently used data storage and management software, and institute is necessary for the service management infosystem) from various different relational databases.At present, for the monitoring of database running status, what generally adopt is the mode of monitoring the process, namely comes process status corresponding to monitor database server by at database server specific program being installed, and judges thus the ruuning situation of database.There is following shortcoming in the method: 1, need to sign in to the running status that database server just can detect database; 2, be unfavorable for carrying out remote monitoring; 3, can't the history of forming monitoring record, be unfavorable for monitoring result is carried out statistical study etc.
Summary of the invention
Purpose of the present invention just provides that a kind of cost is low, highly versatile, efficient is high, performance is good based on the Web mode a plurality of database running statuses is concentrated the method for monitoring.
Method of the present invention relates to monitoring client, Agent file, Web Application Server and four parts of Database Systems:
Agent file: be a dynamic web page file, be used for carrying out the monitoring request of client.
Monitoring client: monitoring client simulation browser mode, the Agent Web page is carried out request access, obtain the return results (XML form) to Agent, and judge the running status of monitored database with this.
Web Application Server: be used for disposing and carrying out the Agent file, according to the time interval of setting, network connectivty carried out in monitored database service judge, and the database of needs monitoring is carried out registration management.
Database Systems: the database server (ORACLE, SQL SERVER database) that needs monitoring.
Of the present inventionly based on the Web mode a plurality of database running statuses are concentrated the method for monitoring, may further comprise the steps:
1, dispose an Agent in Web Application Server, Agent is .jsp dynamic web page file, is used for realizing and the monitoring of monitored database server network passage and database running status that the database of same type uses identical Agent to realize file;
2, monitoring client is registered the database of needs monitoring, and the information of registration comprises: type of database, database server IP address, data base querying user name and password, detection SQL statement and monitoring time interval;
3, time interval of setting according to monitoring client of Agent by the ping mode judge whether be communicated with database server device network and return results to monitoring client, if be not communicated with then return " the network reason is unusual to application state ", stop this time monitoring, otherwise continue next step;
4, Agent connects monitored database node building database, and database positioning monitored, judges, if can not normally set up and being connected of database, then judge and return " database can't be accessed to application state unusual ", and stop this time monitoring, if normally connect, then obtain the response time of database by SQL statement, and return the response time.
Of the present inventionly based on the Web mode a plurality of database running statuses are concentrated the method for monitoring, have following characteristics:
1, realize simply: need not at any software of database server deploy, only need to can finish by first Agent program in deployment and the Web Application Server the monitoring of any a plurality of databases, Agent realizes that technology is simple and practical;
2, highly versatile: just only need to drive the support that can realize distinct type data-base (such as ORACLE, SQL SERVER etc.) monitoring by different JDBC; Same type database only needs a kind of implementation and irrelevant with the operating system platform of database server and hardware platform; By disposing fast the concentrated monitoring that can realize at any time any a plurality of databases;
3, with better function: more accurate to the judgement of database positioning by network, Web Application Server and database being judged successively and return results, more help managerial personnel's rapid failure diagnosis and recovery;
4, active monitoring: monitoring is initiatively initiated by monitoring client, and the Agent passive response is adjusted as required and safeguarded therefore easilier from management view, and need not revise the Agent program.
Description of drawings
Fig. 1 is structure principle chart of the present invention.
Embodiment
Referring to Fig. 1, database monitoring running state client Client judges the database running status by regularly sending request to monitored WEB application server by different return results.
Detailed process is divided into 4 steps:
Step 1: in Web Application Server, dispose an Agent.
Agent is simple .jsp dynamic web page file, is used for realizing the monitoring with monitored database server network passage and database running status; The database of same type uses identical Agent to realize file.
Step 2: monitoring client carries out the database of needs monitoring, and the information of registration comprises: type of database, database server IP address, data base querying user name and password, detection SQL statement and monitoring time interval.
The time interval that step 3:Agent sets according to monitoring client by the ping mode judge whether be communicated with database server device network and return results to monitoring client; If be not communicated with then return " the network reason is unusual to application state ", stop this time monitoring; Otherwise continuation next step.
Step 4:Agent connects monitored database node building database, and database positioning is monitored, judged.If can not normally set up and being connected of database, then judge and return " database can't be accessed to application state unusual ", and stop this time monitoring; If normally connect, then obtain the response time of database by SQL statement, and return the response time.
Claims (1)
1. based on the Web mode a plurality of database running statuses are concentrated the method for monitoring for one kind, it is characterized in that: it may further comprise the steps:
(1), in Web Application Server, disposes an Agent, Agent is .jsp dynamic web page file, be used for realizing and the monitoring of monitored database server network passage and database running status that the database of same type uses identical Agent to realize file;
(2), monitoring client registers the database of needs monitoring, the information of registration comprises: type of database, database server IP address, data base querying user name and password, detection SQL statement and monitoring time interval;
(3), time interval of setting according to monitoring client of Agent by the ping mode judge whether be communicated with database server device network and return results to monitoring client, if be not communicated with then return " the network reason is unusual to application state ", stop this time monitoring, otherwise continue next step;
(4), Agent connects monitored database node building database, and database positioning monitored, judges, if can not normally set up and being connected of database, then judge and return " database can't be accessed to application state unusual ", and stop this time monitoring, if normally connect, then obtain the response time of database by SQL statement, and return the response time.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012105246210A CN102968365A (en) | 2012-12-10 | 2012-12-10 | Central monitoring method for running statuses of databases in Web manner |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012105246210A CN102968365A (en) | 2012-12-10 | 2012-12-10 | Central monitoring method for running statuses of databases in Web manner |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102968365A true CN102968365A (en) | 2013-03-13 |
Family
ID=47798517
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2012105246210A Pending CN102968365A (en) | 2012-12-10 | 2012-12-10 | Central monitoring method for running statuses of databases in Web manner |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102968365A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103634395A (en) * | 2013-11-29 | 2014-03-12 | 国家电网公司 | Method for realizing information system state monitoring in WEB manner |
| CN105227619A (en) * | 2015-07-06 | 2016-01-06 | 国网天津市电力公司 | A kind of method of the remote monitoring data storehouse running status based on Agent |
| CN105429826A (en) * | 2015-12-25 | 2016-03-23 | 北京奇虎科技有限公司 | Fault detection method and device for database cluster |
| CN107179977A (en) * | 2017-05-10 | 2017-09-19 | 杭州铭师堂教育科技发展有限公司 | Database Full-automatic monitoring system based on mpm models |
| CN109753403A (en) * | 2017-11-06 | 2019-05-14 | 阿里巴巴集团控股有限公司 | Server operation method, apparatus, equipment and system |
| CN109947765A (en) * | 2017-09-28 | 2019-06-28 | 北京国双科技有限公司 | Data source detection method and device |
| CN110019535A (en) * | 2018-09-07 | 2019-07-16 | 网联清算有限公司 | Data base management method, device, storage medium and computer equipment |
| CN112579953A (en) * | 2019-09-30 | 2021-03-30 | 北京国双科技有限公司 | Method and device for detecting webpage loading abnormity, storage medium and electronic equipment |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101493826A (en) * | 2008-12-23 | 2009-07-29 | 中兴通讯股份有限公司 | Database system based on WEB application and data management method thereof |
| US7577701B1 (en) * | 2001-01-22 | 2009-08-18 | Insightete Corporation | System and method for continuous monitoring and measurement of performance of computers on network |
-
2012
- 2012-12-10 CN CN2012105246210A patent/CN102968365A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7577701B1 (en) * | 2001-01-22 | 2009-08-18 | Insightete Corporation | System and method for continuous monitoring and measurement of performance of computers on network |
| CN101493826A (en) * | 2008-12-23 | 2009-07-29 | 中兴通讯股份有限公司 | Database system based on WEB application and data management method thereof |
Non-Patent Citations (1)
| Title |
|---|
| 宋秀荣: "Oracle数据库性能优化及实时监控研究", 《中国优秀硕士学位论文全文数据库》 * |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103634395A (en) * | 2013-11-29 | 2014-03-12 | 国家电网公司 | Method for realizing information system state monitoring in WEB manner |
| CN105227619A (en) * | 2015-07-06 | 2016-01-06 | 国网天津市电力公司 | A kind of method of the remote monitoring data storehouse running status based on Agent |
| CN105429826A (en) * | 2015-12-25 | 2016-03-23 | 北京奇虎科技有限公司 | Fault detection method and device for database cluster |
| CN107179977A (en) * | 2017-05-10 | 2017-09-19 | 杭州铭师堂教育科技发展有限公司 | Database Full-automatic monitoring system based on mpm models |
| CN107179977B (en) * | 2017-05-10 | 2018-07-17 | 杭州铭师堂教育科技发展有限公司 | Database Full-automatic monitoring system based on mpm models |
| CN109947765A (en) * | 2017-09-28 | 2019-06-28 | 北京国双科技有限公司 | Data source detection method and device |
| CN109947765B (en) * | 2017-09-28 | 2021-05-14 | 北京国双科技有限公司 | Data source detection method and device |
| CN109753403A (en) * | 2017-11-06 | 2019-05-14 | 阿里巴巴集团控股有限公司 | Server operation method, apparatus, equipment and system |
| CN109753403B (en) * | 2017-11-06 | 2022-09-23 | 阿里巴巴集团控股有限公司 | Server operation method, device, equipment and system |
| CN110019535A (en) * | 2018-09-07 | 2019-07-16 | 网联清算有限公司 | Data base management method, device, storage medium and computer equipment |
| CN112579953A (en) * | 2019-09-30 | 2021-03-30 | 北京国双科技有限公司 | Method and device for detecting webpage loading abnormity, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102968365A (en) | Central monitoring method for running statuses of databases in Web manner | |
| JP5117495B2 (en) | A system that identifies the inventory of computer assets on the network and performs inventory management | |
| CN102437935B (en) | WEB application monitoring method and equipment | |
| CN108365985A (en) | A kind of cluster management method, device, terminal device and storage medium | |
| US11238069B2 (en) | Transforming a data stream into structured data | |
| US8782472B2 (en) | Troubleshooting system using device snapshots | |
| US10944771B2 (en) | Computing resource identification | |
| WO2020173080A1 (en) | Method and apparatus for querying call chain information | |
| CN108259270A (en) | A kind of data center's system for unified management design method | |
| CN101925878A (en) | Method and system for deploying non-backward compatible server versions in client/server computing environment | |
| CN104718533A (en) | Robust hardware fault management system, method and framework for enterprise devices | |
| CN111245672A (en) | Monitoring method and system for general extensible tracking service full link | |
| CN103118130A (en) | Cluster management method and cluster management system for distributed service | |
| CN108173678B (en) | Client data sending method, client connection abnormity display method and device | |
| CN103970907A (en) | Method for dynamically expanding database cluster | |
| CN107491463B (en) | Optimization method and system for data query | |
| CN115248826A (en) | Method and system for large-scale distributed graph database cluster operation and maintenance management | |
| CN113067717A (en) | Network request log chain tracking method, full link call monitoring system and medium | |
| CN104636244A (en) | Server monitoring method using Java, MySQL and Shell | |
| CN109150599B (en) | Operation and maintenance monitoring system based on cloud architecture | |
| CN112214459A (en) | Resource processing flow log collection system based on event mechanism | |
| CN103634395A (en) | Method for realizing information system state monitoring in WEB manner | |
| EP3306471B1 (en) | Automatic server cluster discovery | |
| Hao et al. | A distributed in-memory database solution for mass data applications | |
| CN114143171B (en) | Alarm root cause positioning method and system based on TR069 protocol |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20130313 |