The most complete and correct Zabbix monitoring MySQL configuration method in history

1, configuration--host--Create a host

2. Select Linux Server in other groups or create a new group

3. Host name is MySQL

4. Select click Add in the template, choose the template App MySQL, click Archive

5. Add MySQL Monitor script:

Cd/usr/local/zabbix/share/zabbix/alertscripts

VI check_mysql.sh

#!/bin/bash

# User Name

Mysql_user= ' Zabbix '

# password

Mysql_pwd= ' 123456 '

# Host address/IP

Mysql_host= ' 127.0.0.1 '

# port

Mysql_port= ' 3306 '

# Data connection

Mysql_conn= "/usr/bin/mysqladmin-u${mysql_user}-p${mysql_pwd}-h${mysql_host}-p${mysql_port}"

# parameters are correct

If [$#-ne "1"];then

echo "Arg error!"

Fi

# Get Data

Case $ in

Uptime)

result= ' ${mysql_conn} status|cut-f2-d ":" |cut-f1-d "T" '

Echo $result

;;

Com_update)

result= ' ${mysql_conn} extended-status |grep-w "Com_update" |cut-d "|"-f3 '

Echo $result

;;

Slow_queries)

result= ' ${mysql_conn} status |cut-f5-d ":" |cut-f1-d "O"

Echo $result

;;

Com_select)

result= ' ${mysql_conn} extended-status |grep-w "Com_select" |cut-d "|"-f3 '

Echo $result

;;

Com_rollback)

result= ' ${mysql_conn} extended-status |grep-w "Com_rollback" |cut-d "|"-f3 '

Echo $result

;;

Questions)

result= ' ${mysql_conn} status|cut-f4-d ":" |cut-f1-d "S" '

Echo $result

;;

Com_insert)

result= ' ${mysql_conn} extended-status |grep-w "Com_insert" |cut-d "|"-f3 '

Echo $result

;;

Com_delete)

result= ' ${mysql_conn} extended-status |grep-w "Com_delete" |cut-d "|"-f3 '

Echo $result

;;

Com_commit)

result= ' ${mysql_conn} extended-status |grep-w "Com_commit" |cut-d "|"-f3 '

Echo $result

;;

Bytes_sent)

result= ' ${mysql_conn} extended-status |grep-w "bytes_sent" |cut-d "|"-f3 '

Echo $result

;;

bytes_received)

result= ' ${mysql_conn} extended-status |grep-w "bytes_received" |cut-d "|"-f3 '

Echo $result

;;

Com_begin)

result= ' ${mysql_conn} extended-status |grep-w "Com_begin" |cut-d "|"-f3 '

Echo $result

;;

*)

echo "Usage:$0 (uptime| com_update| slow_queries| Com_select| com_rollback| questions| Com_insert| com_delete| Com_commit| Bytes_sent| bytes_received| Com_begin) "

;;

Esac

6. Modify Zabbix Agent Parameters

Vi/usr/local/zabbix/etc/zabbix_agentd.conf

# get MySQL Version

Userparameter=mysql.version,mysql-v

# Get MySQL performance metrics, this is the script defined above

Userparameter=mysql.status[*],/usr/local/zabbix-2.4.4/scripts/chk_mysql.sh $

# get MySQL Run status

userparameter=mysql.ping,mysqladmin-uzabbix-p123456-p3306-h127.0.0.1 Ping | Grep-c Alive

7. Restart Zabbix Service

Service Zabbix_agentd Restart

This article is from the "13015170" blog, please be sure to keep this source http://13025170.blog.51cto.com/13015170/1962649

The most complete and correct Zabbix monitoring MySQL configuration method in history