Monitor MySQL in Zabbix using the Percona monitor plugin

Source: Internet
Author: User
Tags percona

    1. Download and install Percona source, use Percona Toolkit or Innobackup later


Wget-n--no-check-certificate RPM-IVH percona-release-0.1-4.noarch.rpm

2. Installing the Percona Monitor plugin with Yum

Yum-y Install Percona-zabbix-templates

After the installation, most of the files are placed under the/var/lib/zabbix/percona directory

3. Create a new/conf.d/directory under the Zabbix_agent folder and copy the installation generated Percona monitoring profile to this directory

Mkdir-p/USR/LOCAL/ZABBIX_AGENT/CONF.D/CP/VAR/LIB/ZABBIX/PERCONA/TEMPLATES/USERPARAMETER_PERCONA_MYSQL.CONF/USR /local/zabbix/conf.d/chown-r zabbix.zabbix/usr/local/zabbix_agent/

4. Configure the Percona monitoring script to refer to the specific parameters of the machine, the script uses sock to access the local database

vim/var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php
# ============================================================================ $mysql _user = ' mpm '; $mysql _pass = ' 123456 '; $mysql _port = 3306; $mysql _socket = '/data/mysql/3306/tmp/mysql3306.sock '; $mysql _flags = 0;
vim/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh


Item=$1host=localhostdir= ' dirname $ ' cmd= "/usr/bin/php-q $DIR/ss_get_mysql_stats.php--host $HOST--items gg" cachefile= "/tmp/$HOST-mysql_cacti_stats.txt" If ["$ITEM" = "running-slave"];  Then # Check for running slave res= '/usr/local/mysql/bin/mysql-umpm-p123456-s/data/mysql/3306/tmp/mysql3306.sock -E ' SHOW SLAVE status\g ' | Egrep ' (slave_io_running| slave_sql_running): ' | Awk-f: ' {print $} ' | Tr ' \ n ', ' if [' $RES ' = ' Yes, yes ', ']; Then echo 1 else echo 0 fi


5. Edit the zabbix_agent configuration file to read the Conf of the Percona plugin

Vim/usr/local/zabbix_agent/conf/zabbix_agentd.conf
# # # option:include# You are Include individual files or all files in a directory in the configuration file.# Installing Zabbix would create include directory in/usr/local/etc, unless modified during the compile time.## mandatory:n o# default:# include=# include=/usr/local/etc/zabbix_agentd.userparams.conf# include=/usr/local/etc/zabbix_ agentd.conf.d/include=/usr/local/zabbix_agent/conf.d/


6. Restart Zabbix_agent

/etc/init.d/zabbix_agentd restart


7. Test whether the Pecona monitor script is running properly

/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh GG

If configured correctly, a number will appear


8. Upload the XML template file from the/var/lib/percona/templates directory to the Zabbix_web

We'll be able to look at the surveillance graphics.

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M02/95/4E/wKioL1kT9hbg0wQ1AADVxNy7yd0048.png-wh_500x0-wm_ 3-wmp_4-s_470227156.png "title=" Qq20170511132329.png "alt=" Wkiol1kt9hbg0wq1aadvxny7yd0048.png-wh_50 "/>

Monitor MySQL in Zabbix using the Percona monitor plugin

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.