【移動(dòng)應(yīng)用開發(fā)技術(shù)】使用zabbix監(jiān)控mysql詳細(xì)解析

【移動(dòng)應(yīng)用開發(fā)技術(shù)】使用zabbix監(jiān)控mysql詳細(xì)解析

本文主要給大家介紹使用zabbix監(jiān)控mysql詳細(xì)解析，文章內(nèi)容都是筆者用心摘選和編輯的，使用zabbix監(jiān)控mysql詳細(xì)解析具有一定的針對(duì)性，對(duì)大家的參考意義還是比較大的，下面跟筆者一起了解下主題內(nèi)容吧。用zabbix監(jiān)控mysql(源碼安裝)安裝位置在/usr/local/zabbix/監(jiān)控端(server)：在被監(jiān)控端主機(jī)上關(guān)聯(lián)該模板TemplateAppMySQL中文：組態(tài)->主機(jī)->名稱一欄點(diǎn)擊進(jìn)去->模板，點(diǎn)擊鏈接新模板->添加->TemplateAppMySQL->存檔英文：Configuration->Hosts->Name->Templates,Linknewtemplates->Add->TemplateAppMySQL->Save2.被監(jiān)控端（agent）:1)在源碼包../zabbix-2.2.1/conf/zabbix_agentd/拷貝模板cp

zabbix-2.2.1/conf/zabbix_agentd/userparameter_mysql.conf

/usr/local/zabbix/etc/zabbix_agentd.conf.d/2)授予監(jiān)控mysql信息的用戶權(quán)限mysql>

grant

usage

on

*.*

to

zabbix@'localhost'

identified

by

'zabbix';3）修改f[mysqladmin]

host=localhost

user=zabbix

password=zabbix

[mysql]

host=localhost

user=zabbix

password=zabbix4)修改vim

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

UserParameter=mysql.status[*],echo

"show

global

status

where

Variable_name='$1';"

|

HOME=/var/lib/zabbix

mysql

-uzabbix

-pzabbix

-hlocalhost

-N

|

awk

'{print

$$2}'

UserParameter=mysql.size[*],echo

"select

sum($(case

"$3"

in

both|"")

echo

"data_length+index_length";;

data|index)

echo

"$3_length";;

free)

echo

"data_free";;

esac))

from

information_schema.tables$([[

"$1"

=

"all"

||

!

"$1"

]]

||

echo

"

where

table_schema='$1'")$([[

"$2"

=

"all"

||

!

"$2"

]]

||

echo

"and

table_name='$2'");"

|

HOME=/var/lib/zabbix

mysql

-uzabbix

-pzabbix

-hlocalhost

-N

UserParameter=mysql.ping,HOME=/var/lib/zabbix

mysqladmin

-uzabbix

-pzabbix

-hlocalhost

ping

|

grep

-c

alive

UserParameter=mysql.version,mysql

-uzabbix

-pzabbix

-hlocalhost

-V5)#

/etc/init.d/mysqld

restart

#

/etc/init.d/zabbix_agentd

restart6)在server上的查看圖像數(shù)據(jù)

Monitoring->Graphs->MySQLoperationsnagios監(jiān)控主從ls

/usr/local/nagios/etc/objects/commands.cfg

#

vim

/usr/local/nagios/etc/objects/commands.cfg

define

command

{

command_name

check_mysql_slave

command_line

$USER1$/check_mysql

-H

$HOSTADDRESS$

-S

-uzabbix

-pzabbix

}

修改被監(jiān)控端的配置文件

#

vim

zabbix_agent.cfg

define

service{

use

local-service

host_name

zabbix_agent

service_description

MYSQL_SLAVE

check_command

check_mysql_slave

}