Integrated operation and maintenance management method and device for IT machine room

Abstract

The invention discloses an integrated operation and maintenance management method and device for an IT machine room. The integrated operation and maintenance management method comprises the steps: binding a server in the IT machine room with a database, and obtaining a bound key performance index of the database; obtaining a performance evaluation result of the database according to the key performance indexes; and visually presenting the operation and maintenance management of the IT machine room according to the performance evaluation result. Compared with the prior art, the integrated operation and maintenance management method has the following advantages: (1) compared with manual deployment and installation, the integrated operation and maintenance management method is more scientificand efficient, and fully utilizes hardware resources; (2) compared with the mode that a database system administrator processes the performance problem from leaking stoppage, not only are the capabilities of analyzing the performance problem and solving the performance problem improved, but also the initiative of performance management is recovered, and positive prevention and automatic processing can be realized; (3) one-key deployment is carried out to realize quick online of the service system and shorten the system deployment time; and (4) elastic expansion and contraction: rapid non-inductive expansion and contraction of a machine reaching a bottleneck are realized.

Description

technical field [0001] Embodiments of the present invention relate to the field of computer technology, and in particular to an integrated operation and maintenance management method and device for an IT computer room. Background technique [0002] At present, the installation and configuration of the database is mainly performed by professional database system administrators by manually executing some commands and scripts. At the same time, the management of the database, as a tedious and complicated task, especially depends on the skill proficiency of the database system administrator. At present, the following problems exist in the deployment and management of databases: [0003] (1) The hardware utilization rate of the database for the server is not high, and the performance potential of the database has not been tapped; [0004] (2) There are many steps for database installation, and multiple steps are required from server deployment to database installation and confi...

AI Technical Summary

Problems solved by technology

[0003] (1) The hardware utilization rate of the database for the server is not high, and the performance potential of the database has not been tapped;

[0004] (2) There are many steps for database installation, and multiple steps are required from server deployment to database installation and configuration, and the configuration depends on the skill level of the database system administrator;

[0005] (3) It cannot be elastically scaled, and when the bottleneck is reached, it can only be migrated to a new machine;

[0006] (4) Database management and hardware resources are not integrated, and it is difficult to prevent problems. At present, the mainstream of the industry is to manage the database by logging in to the server. Security cannot be guaranteed, and it is difficult to track operators and operations.

Images