Use zabbix and mysql1_cemonitor templates to monitor mysql Databases

For more blog posts, please note: Children without umbrellas must work hard (www.xuchanggang.cn) 1. install the dependent package required by mpm: [for the sake of security, the agent also installs the following dependent package] [root @ client141 ~] # Yum-yins

For more blog posts, please note: Children without umbrellas must work hard (www.xuchanggang.cn) 1. install the dependent package required by mpm: [for the sake of security, the agent also installs the following dependent package] [root @ client141 ~] # Yum-yins

Type = mysqld

Mysqlport = 3306

Modules = mpm server process mysql myisam innodb master

PidFile =/var/run/mysqld. pid

Step 2: comment out the zabbix server statement in the module:

[Root @ client100 ~] # Vim/usr/local/mysql_performance_monitor_agent/lib/sendData. pm

# The comment-out statement is as follows:

# $ Rc = & FromDualMySQLagent: checkConnectionToZabbixServer ($ main: gParameter {'zabbixserver'}, $ main: gParameter {'zabbixserverport'}, $ main :: gParameter {'hostname '});

(5) Pay attention to the permissions of related files in the/var/log/zabbix/cache/directory to ensure that

[Root @ client100 ~] # Cd/var/log/zabbix/cache/

[Root @ client100 cache] # ll
-Rw-r -- 1 zabbix 0 Mar 22 07:25 FromDualAgentCache.192.168.1.100.cache

# Note: it is normal that the file is not written, because the program automatically clears the file, but if the file keeps increasing, it indicates that the configuration is incorrect, data not sent

(6) The following error is reported. The processing method is as follows:

12933: 06:52:06. 005-INFO: FromDual Performance Monitor for MySQL (0.9.1) run started.
12933: 06:52:06. 019-ERR: Load of cache file failed. rc = 1301
12933: 06:52:07. 029-ERR: Load of cache file failed. rc = 1301

# This error is reported. The file above is also becoming larger. Generally, the file above is incorrect. We recommend that you delete the file and restart the program, let the program re-create a new file (instead of clearing the file)

(7). When configuring the host group on the zabbix web end, the host group is mysql database (you can set it to another group and the test has been successful)

This article is from the blog "children without umbrellas must be running hard". Please keep this source