2,187
edits
Difference between revisions of "Percona NRPE Install (MySQL)"
Jump to navigation
Jump to search
Percona NRPE Install (MySQL) (view source)
Revision as of 09:26, 2 December 2016
, 09:26, 2 December 2016→Plugin Setup: Updated
(Added Ubuntu install) |
(→Plugin Setup: Updated) |
||
| Line 22: | Line 22: | ||
== Plugin Setup == | == Plugin Setup == | ||
Change the user/pass used in the example below | |||
# Append checks to NRPE config file (see below - change user/pass as required) | # Append checks to NRPE config file (see below - change user/pass as required) | ||
#* <code> vi /usr/local/nagios/etc/nrpe.cfg </code> | #* <code> vi /usr/local/nagios/etc/nrpe.cfg </code> | ||
| Line 29: | Line 30: | ||
#* <code> mysql -u root -p </code> | #* <code> mysql -u root -p </code> | ||
#* <code> GRANT SELECT, PROCESS, SUPER ON *.* to 'nagios'@'localhost' IDENTIFIED BY 'nagios123'; </code> | #* <code> GRANT SELECT, PROCESS, SUPER ON *.* to 'nagios'@'localhost' IDENTIFIED BY 'nagios123'; </code> | ||
# Create credentials config file for checks to use | |||
#* <code> vi /etc/nagios/mysql.cnf </code> | |||
#* Add the following lines | |||
#* <code> [client] </code> | |||
#* <code> user = nagios </code> | |||
#* <code> password = nagios123 </code> | |||
# Change owner and permissions of credentials config file | |||
#* <code> chown root:nagios /etc/nagios/mysql.cnf </code> | |||
#* <code> chmod 640 /etc/nagios/mysql.cnf </code> | |||
<pre> | <pre> | ||
# MySQL checks | # Example MySQL checks | ||
command[check_mysql_status]=/usr/lib64/nagios/plugins/pmp-check-mysql-status $ARG1$ | |||
command[check_mysql_status]=/usr/lib64/nagios/plugins/pmp-check-mysql-status | command[check_mysql_processlist]=/usr/lib64/nagios/plugins/pmp-check-mysql-processlist | ||
command[check_mysql_processlist]=/usr/lib64/nagios/plugins/pmp-check-mysql-processlist | command[check_mysql_innodb]=/usr/lib64/nagios/plugins/pmp-check-mysql-innodb -C $ARG1$ | ||
command[check_mysql_innodb]=/usr/lib64/nagios/plugins/pmp-check-mysql-innodb | command[check_mysql_status_uptime]=/usr/lib64/nagios/plugins/pmp-check-mysql-status x Uptime -C '<' -w $ARG1$ -c $ARG2$ | ||
command[check_mysql_status_uptime]=/usr/lib64/nagios/plugins/pmp-check-mysql-status | command[check_mysql_status_connx]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -x Threads_connected -o / -y max_connections -T pct -w $ARG1$ -c $ARG2$ | ||
command[check_mysql_status_connx]=/usr/lib64/nagios/plugins/pmp-check-mysql-status | command[check_mysql_status_threadrun]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -x Threads_running -w $ARG1$ -c $ARG2$ | ||
command[check_mysql_status_threadrun]=/usr/lib64/nagios/plugins/pmp-check-mysql-status | command[check_mysql_slave_running]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-running | ||
command[check_mysql_slave_running]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-running | command[check_mysql_slave_delay]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-delay | ||
command[check_mysql_slave_delay]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-delay | |||
</pre> | </pre> | ||