Zabbix monitoring MySQL master-slave replication

Source: Internet
Author: User


Zabbix monitoring MySQL master-slave replication



. Monitor the replication of MySQL


Principle: Get values for slave_io_running and slave_sql_running using Run show slave status on Slave


1. Create a new monitoring user on MySQL

Grant replication Client on * * to ' zabbix ' @ ' localhost ' identified by ' Zabbix ';

Flush privileges;


2. Create a new mysql_slave_status.sh script under/data/zabbix/sbin

MySQL enters the password directly in the terminal, there will be a warning message output,

First add the MySQL user's password in the/ETC/MY.CNF

Vim/etc/my.cnf

[Client]

user = Zabbix

Password = Zabbix


vim/data/zabbix/sbin/mysql_slave_status.sh


#!/bin/bash

Mysql-uzabbix-e "show slave Status\g" |grep-e "slave_io_running| Slave_sql_running "|awk ' {print $} ' |grep-c Yes

....


chmod +x/data/zabbix/sbin/mysql_slave_status.sh



3. Modify the/data/zabbix/conf/zabbix_agentd.conf file



Unsafeuserparameters=1

userparameter=mysql.slave-status,/data/zabbix/sbin/mysql_slave_status.sh


4. Restart the ZABBIX_AGEMTD service



Service Zabbix_agentd Restart


Configuring the Zabbix service side


Test Client Script

Zabbix_get Command Common parameters

-S--host: Specifies the client host name or IP

-P--port: Client port, default 10050

-I--source-address: Specify the source IP, write the IP address of the Zabbix server, and generally leave it blank, if the server has multiple IPs, you specify one.

-K--key: You want to get the key



Zabbix_get-s 221.195.1.101-k "Mysql.slave-status"


If the above return is 2, then it is normal (1.mysql copy normal 2.ZABBIX_AGENTD is configured properly),

On behalf of Slave_io_running and slave_sql_running two states are yes, here 221.195.1.101 is my slave IP address



If the test is okay, sign in to the Web page


1. Create a template first


--Configuration--templates--Create templates


Fill in the template name: Mysql.slave-status

Visualization Name: Mysql.slave-status

Group.....

Describe.....


After saving


Create a monitoring item

Enter the created template Mysql.slave-status

Name: Mysql.slave-status

Type: Zabbix Client Side

Key value: Mysql.slave-status

Type of information: number (no plus or minus)

Data and new time (in seconds): 30 You can change the data according to your own situation with the new time, I changed to 5 seconds

Other values are good by default


Create a Trigger

Name: Mysql.slave-status

Severity: Warning

Problem form: Add--Select Monitoring Item Mysql.slave-status function: Latest T-value <n N:2

After adding the expression is this: {mysql.slave-status:mysql.slave-status.last ()}<2


Restore expression: Add-Select Monitoring Item Mysql.slave-status function: Latest T-value =n N:2


......

The configuration of the Web page is finished,

The configuration of the Zabbix 2.* version and the Zabbix 3.* version are different in some places, but they are quite similar.


-------------------------

Whether the test configuration can trigger an alarm


Stop slave in MySQL environment;


We'll get an email in a few minutes.

Rigger:mysql.slave-status

Trigger Status:problem

Trigger severity:warning

Trigger URL:


Item values:


1. Mysql.slave-status (221.195.1.101:mysql.slave-status): 0

Original Event id:3106

-------------------------------

Start slave in MySQL environment;


Trigger:mysql.slave-status

Trigger Status:ok

Trigger severity:warning

Trigger URL:


Item values:


1. Mysql.slave-status (221.195.1.101:mysql.slave-status): 2

Original Event id:3106


---------------------------------







Zabbix monitoring MySQL master-slave replication

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.