ZABBIX 之 MYSQL監控

標籤：

1 ,安裝phpyum install php php-mysql 2，指定mysql.sock檔案vim /etc/php.inimysql_default_socket=/data/mysql/3306/var/run/mysql.sockmysqli_default_socket=/data/mysql/3306/var/run/mysql.sock 3, 安裝percona pluginwget https://www.percona.com/downloads/percona-monitoring-plugins/1.1.5/percona-zabbix-templates-1.1.5-1.noarch.rpmrpm -ivh percona-zabbix-templates-1.1.5-1.noarch.rpmcopy模版到server 匯入，連結模版 3,  修改php指令碼vim ss_get_mysql_stats.php$mysql_user = ‘root‘;$mysql_pass = ‘root‘;$mysql_port = 3306; 4, 修改shell指令碼vim get_mysql_stats_wrapper.shHOST=******RES=`echo ‘SHOW SLAVE STATUS\G‘ |mysql --defaults-file=/etc/.my.cnf | egrep ‘(Slave_IO_Running|Slave_SQL_Running):‘ | awk -F: ‘{print $2}‘ | tr ‘\n‘ ‘,‘` vim /etc/.my.cnf[mysql]user=zabbixpassword=zabbixhost=localhostsocket= /data/mysql/3306/var/run/mysql.sock [mysqladmin]user=zabbixpassword=zabbix 7，配置mysql帳號zabbix/passwordselect mysql許可權 8，重啟zabbix 9, 測試php -q ss_get_mysql_stats.php --host localhost --items gg./get_mysql_stats_wrapper.sh  gg chown zabbix:zabbix  /tmp/*-mysql_stats.txt 

ZABBIX 之 MYSQL監控