#Python monitor mysql install#

#Python monitor mysql install#

You can download version 5.5 of MySQL from the official website and install it with the script I wrote $ service httpd restartДЄdd boot start: $chkconfigВ -addВ httpd # ServerName gives the name and port that the server uses to identify itself. $ cp/usr/local/apache/bin/apachectl/etc/init.d/httpd $ cp/usr/local/webserver/apache/bin/apachectl/etc/init.d/httpd Httpd: Could not reliably determine the server's fully qualified domain name, using localhost.localdomain for ServerName Each subsystem is responsible for the collection and display of specific information. The system is mainly composed of dashboards, status monitoring, process monitoring, replication monitoring, slow query analysis, performance charts, tool components, alarm events, system resources and other subsystems. When the database deviates from the set normal operation threshold (such as connection abnormality, replication abnormality, replication delay), it can send an alarm email notification to the DBA for processingДЄrchive historical data and show the recent status of the database through graphs so that DBA and developers can analyze and diagnose problems encountered It can constantly monitor the status, number of connections, QTS, TPS, database traffic, replication, performance, etc. The most important thing is that the MySQL server does not need to install any Agent, just configure the relevant database information in the monitoring WEB interface The system implements multi-process data collection and alarm by Python, and PHP implements WEB display and management. MySQLMTOP is a MySQL enterprise monitoring system developed by Python+PHP. The establishment of MySQL monitoring system MySQL MTOP MySQLdb for python (Python connection to MySQl interface) Apache 2.2 and above (WEB server running server)Д¤.Python2 (version 2.7 is recommended, other versions have not been tested, and perform data collection and alarm tasks)ДҐ. MySQL 5.0 and above (used to store data collected by the monitoring system)Дў. The required core packages are as follows:ДЎ. MySQL MTOP is developed by PHP and Python, so the monitoring machine needs to install PHP operating environment and Python environment.