Method and device for monitoring database management platform

Abstract

The invention discloses a method and a device for monitoring a database management platform. In an embodiment, a monitoring management terminal is arranged in the database management platform. The method includes, through the monitoring management terminal, monitoring whether a host of a MySQL database is installed to the database management platform or not; if so, then installing a monitoring client terminal to the host to generate a host table aiming at the installed host; reading the host table through the monitoring management terminal, and generating host configuration information of the host installed to the database management platform according to the host table; by the monitoring management terminal, when receiving monitoring parameter, generating service configuration information for the host which is needed to be monitored according to indication of the monitoring parameter on the basis of set monitoring items; and finally, pushing and loading the host configuration information and service configuration information to a monitoring server of the database management platform through the monitoring management terminal.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a monitoring method and device for a database management platform. Background technique [0002] The MySQL database has been serving Internet companies for ten years, and it has good scalability. From a deep embedded application with only 1MB to a large data warehouse with a gigabyte, the MySQL database can handle it freely. MySQL also supports various Linux, UNIX, and Windows platforms. Among many relational database products, the storage engine characteristics of MySQL make it gradually become the data storage medium of choice for various business models. [0003] In the existing monitoring scheme for MySQL database, the monitoring client is manually installed in the MySQL database, and the files and monitoring templates in the monitoring client and monitoring server are manually configured. The complexity of manual operation is high, resulting in relatively high labor costs....

AI Technical Summary

Problems solved by technology

[0004] The present invention provides a monitoring method and device for a database management platform to solve the problems of high labor cost, high error rate of monitoring operation, and high error rate of monitoring operation caused by manual intervention from installation to configuration of monitoring client and monitoring server in existing solutions. The problem of low monitoring efficiency

Images