Zabbix application-Monitor MySQL slave master-slave status

Online service Monitoring has been basically done, and now there is no detection of MySQL master-slave state, here to use Zabbix monitoring, but also to write a master-slave state script, and then set a key, create a template to apply this key to get MySQL master and slave state is normal.

1. Paste my script here, script to give executable permission

#!/bin/bashuser=zabbixagentpasswd=zabbixagentport=$1# Custom Function function  Status {   status= '/data/mysql_root/mysql/bin/mysql -u$user -s /data/mysql_ root/mysql/data$port/mysql.socket -p$passwd -e  "show slave status\g;"  | egrep  ' Slave_io_running| Slave_sql_running '   | awk  ' {print $2} '  | egrep  ' Yes '  | WC  -l '     if [  $status  = 2 ];then         echo 2   else        echo  1   FI} #引用函数status 

2. Custom key

Cat/etc/zabbix/zabbix_agentd.d/check_mysql.conf

Userparameter=sanguo.check.mysql[*],/data/salt/scripts/check_mysql.sh $

Restart Zabbix_agent

3. Creating a template and linking the host

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/80/0A/wKioL1c1ftrjjYHQAADVHldTV0I219.png "title=" QQ picture 20160513145340.png "alt=" Wkiol1c1ftrjjyhqaadvhldtv0i219.png "/>

(1). Create Applications

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/80/0A/wKioL1c1fvKxDayyAABBEfK03cw851.png "title=" QQ picture 20160513145429.png "alt=" Wkiol1c1fvkxdayyaabbefk03cw851.png "/>

(2). Create items   Get the slave state of the 3316 instance, or use Zabbix_get-s ip-k sanguo.check.mysql[3316] on the server to get the value

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/80/0A/wKioL1c1fzCx76toAACd7zJulX8511.png "title=" Fd4f7dd2-9096-4f5e-ba37-b2873fb5a484.png "alt=" Wkiol1c1fzcx76toaacd7zjulx8511.png "/>

(3). Create trigger   trigger an alarm if the last obtained value is not equal to 2

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/80/0D/wKiom1c1fm-CSsmpAABnd-cgmPI224.png "title=" 22af8b5f-07f8-416d-8d0e-0e0587b2bdcc.png "alt=" Wkiom1c1fm-cssmpaabnd-cgmpi224.png "/>

(4). Create trigger action  

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/80/0D/wKiom1c1gBTD1BgqAABBT-CwHTY755.png "style=" float: none; "title=" Bc64c4ef-7b05-481a-9455-5cace43acbe1.png "alt=" Wkiom1c1gbtd1bgqaabbt-cwhty755.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/80/0A/wKioL1c1gPbigyE7AACK1SAw8KA056.png "style=" float: none; "title=" E2d9cef3-a95a-4978-b226-688400eec8cb.png "alt=" Wkiol1c1gpbigye7aack1saw8ka056.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/80/0D/wKiom1c1gBSBdVPzAABIhx0KdBU240.png "style=" float: none; "title=" E3674647-373d-4235-b525-d52483572961.png "alt=" Wkiom1c1gbsbdvpzaabihx0kdbu240.png "/>

Template in Attachment

This article from "Do not abandon!" Do not give up "blog, be sure to keep this source http://thedream.blog.51cto.com/6427769/1773036

Zabbix application-Monitor MySQL slave master-slave status