Percona NRPE Install (MySQL)

Instructions on installed the Percona NRPE plugin in order to be able to monitor a MySQL server from Nagios. See the following page form more info - https://www.percona.com/doc/percona-monitoring-plugins/1.0/nagios/index.html

1. Add the Percona repository
   • yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
2. Install the Percona NRPE Nagios plugins
   • yum install percona-nagios-plugins percona-toolkit
3. Append checks to NRPE config file (see below - change user/pass as required)
   • vi /usr/local/nagios/etc/nrpe.cfg
4. Check NRPE is set to allow parameters
   • dont_blame_nrpe=1
5. Create MySQL user
   • mysql -u root -p
   • GRANT SELECT, PROCESS, SUPER ON *.* to 'nagios'@'localhost' IDENTIFIED BY 'nagios123';

# MySQL checks
command[check_mysql]=/usr/lib64/nagios/plugins/check_mysql -u nagios -p nagios123
command[check_mysql_status]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -l nagios -p nagios123 $ARG1$
command[check_mysql_processlist]=/usr/lib64/nagios/plugins/pmp-check-mysql-processlist -l nagios -p nagios123
command[check_mysql_innodb]=/usr/lib64/nagios/plugins/pmp-check-mysql-innodb -l nagios -p nagios123 -C $ARG1$
command[check_mysql_status_uptime]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -l nagios -p nagios123 -x Uptime -C '<' -w $ARG1$ -c $ARG2$
command[check_mysql_status_connx]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -l nagios -p nagios123 -x Threads_connected -o / -y max_connections -T pct -w $ARG1$ -c $ARG2$
command[check_mysql_status_threadrun]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -l nagios -p nagios123 -x Threads_running -w $ARG1$ -c $ARG2$
command[check_mysql_slave_running]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-running -l nagios -p nagios123
command[check_mysql_slave_delay]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-delay -l nagios -p nagios123

NRPE Compiled Without Argument Support

Sometime Nagios has been compiled and installed so that it will never accept arguments (regardless of dont_blame_nrpe config).

cd /root/nrpe/nrpe-2.13/
./configure --enable-command-args
/etc/init.d/nrpe stop
make
make install
/etc/init.d/nrpe start

{{#seo: |title=Percona MySQL NRPE plugin install |keywords=mysql,nrpe,nagios,monitor,percona, plugin |description=Instructions on installing the Percona NRPE plugin in order to be able to monitor a MySQL server from Nagios }}