zabbix 配置mysql_【MySQL】zabbix监控MySQL配置

1.在mysql数据库中创建zabbix用户 用来获取数据

GRANT PROCESS,SUPER,REPLICATION CLIENT ON *.* TO zabbix@'%' IDENTIFIED BY 'yourpass';

2.更改zabbix配置文件

find / |grep zabbix_agentd.conf

/usr/local/etc/zabbix_agentd.conf.d

/usr/local/etc/zabbix_agentd.conf #配置文件

/usr/local/src/zabbix-3.2.3/conf/zabbix_agentd.conf

# 添加mysql监控信息

vim /usr/local/etc/zabbix_agentd.conf

UserParameter=mysql.version,mysql -V

UserParameter=mysql.status[*],/usr/local/etc/chk_mysql.sh $1

UserParameter=mysql.ping,netstat -ntpl |grep 3306 |grep mysql |wc |awk '{print $1}'

3.在/usr/local/etc目录下创建检查脚本

vi chk_mysql.sh

#!/bin/sh

# -------------------------------------------------------------------------------

# FileName: check_mysql.sh

# Revision: 1.0

# Date: 2016/04/22

# Author: tim

# Email: [mchdba@sohu.com](mailto:mchdba@sohu.com)

MYSQL_SOCK="/var/lib/mysql/mysql.sock"

MYSQL_USER='zabbix'

export MYSQL_PWD=yourpass

MYSQL_HOST='192.168.6.230'

MYSQL_PORT='3306'

ARGS=1

if [ $# -ne "$ARGS" ];then

echo "Please input one arguement:"

fi

case $1 in

Uptime)

result=`mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -S $MYSQL_SOCK status|cut -f2 -d":"|cut -f1 -d"T"`

echo $result

;;

Com_update)

result=`mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_update"|cut -d"|" -f3`

echo $result

;;

Slow_queries)

result=`mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -S $MYSQL_SOCK status |cut -f5 -d":"|cut -f1 -d"O"`

echo $result

;;

Com_select)

result=`mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_select"|cut -d"|" -f3`

echo $result

;;

Com_rollback)

result=`mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_rollback"|cut -d"|" -f3`

echo $result

;;

Questions)

result=`mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -S $MYSQL_SOCK status|cut -f4 -d":"|cut -f1 -d"S"`

echo $result

;;

Com_insert)

result=`mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_insert"|cut -d"|" -f3`

echo $result

;;

Com_delete)

result=`mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_delete"|cut -d"|" -f3`

echo $result

;;

Com_commit)

result=`mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_commit"|cut -d"|" -f3`

echo $result

;;

Bytes_sent)

result=`mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Bytes_sent" |cut -d"|" -f3`

echo $result

;;

Bytes_received)

result=`mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Bytes_received" |cut -d"|" -f3`

echo $result

;;

Com_begin)

result=`mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_begin"|cut -d"|" -f3`

echo $result

;;

*)

echo "Usage:$0(Uptime|Com_update|Slow_queries|Com_select|Com_rollback|Questions)"

;;

esac

# 更改脚本权限

chmod +x chk_mysql.sh

chown zabbix:zabbix chk_mysql.sh

4.赋予zabbix用户执行netstat的权限

chmod +s /bin/netstat

5.重启zabbix_agentd

service zabbix_agentd stop

service zabbix_agentd start

6.进入zabbix web 后台 添加Template App MySQL模板 之后再service端检查key

zabbix_get -s 192.168.6.230 -k mysql.ping

zabbix_get -s 192.168.6.230 -k mysql.status[Com_insert]