Percona NRPE Install (MySQL)

From vwiki
Revision as of 16:05, 26 September 2016 by Sstrutt (talk | contribs) (Typo fix)
Jump to navigation Jump to search

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
  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 plgin install |keywords=mysql,nrpe,nagios,monitor, percona |description=Instructions on installed the Percona NRPE plugin in order to be able to monitor a MySQL server from Nagios }}