[MySQL] zabbix企业应用之low level discovery监控mysql

#!/bin/bash
#Fucation:mysql low-level discovery
#Script_name mysql_low_discovery.sh
mysql() {
      port=($(sudo netstat -tpln | awk -F "[ :]+" '/[m]ysql/ && /0.0.0.0/ {print $5}'))
      printf '{\n'
      printf '\t"data":[\n'
         for key in ${!port[@]}
           do
             if [[ "${#port[@]}" -gt 1 && "${key}" -ne "$((${#port[@]}-1))" ]];then
        socket=`ps aux|grep ${port[${key}]}|grep -v grep|awk -F '=' '{print $10}'|cut -d ' ' -f 1`
              printf '\t {\n'
              printf "\t\t\t"{#MYSQLPORT}":"${port[${key}]}"},\n"
           else [[ "${key}" -eq "((${#port[@]}-1))" ]]
        socket=`ps aux|grep ${port[${key}]}|grep -v grep|awk -F '=' '{print $10}'|cut -d ' ' -f 1`
              printf '\t {\n'
              printf "\t\t\t"{#MYSQLPORT}":"${port[${key}]}"}\n"
             fi
         done
              printf '\t ]\n'
              printf '}\n'
}
$1

echo "zabbix ALL=(root) NOPASSWD:/bin/netstat">>/etc/sudoers

sed -i 's/^Defaults.*.requiretty/#Defaults  requiretty/' /etc/sudoers

UserParameter=zabbix_low_discovery
[*],/bin/bash /usr/local/zabbix/bin/mysql_low_discovery.sh $1
UserParameter=mysql_stats
[*],mysql -h localhost -P $1 -uzabbix -pzabbix -e "show global status"|grep "\<$2\>"|cut  -f2

[root@zabbix1 bin]# /usr/local/zabbix/bin/zabbix_get -s 127.0.0.1 -k zabbix_low_discovery[mysql]
{
  "data":[
   {
      "{#MYSQLPORT}":"3306"}
   ]
}

GRANT PROCESS ON *.* TO 'zabbix'@'localhost' identified BY 'zabbix';
Flush privileges;

ps -ef|grep zabbix|grep -v grep|awk '{print $2}'|xargs kill -9
/usr/local/zabbix/sbin/zabbix_agentd -c /usr/local/zabbix/conf/zabbix_agentd.conf