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 08:57, 15 March 2019
, 08:57, 15 March 2019→Percona Repository: Updated
(Added Ubuntu install) |
(→Percona Repository: Updated) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 5: | Line 5: | ||
If you don't have it available already, you'll need to add the Percona repository (if it is you should have the following file - <code>/etc/apt/sources.list.d/percona-release.list</code> | If you don't have it available already, you'll need to add the Percona repository (if it is you should have the following file - <code>/etc/apt/sources.list.d/percona-release.list</code> | ||
# Download appropriate pagckage | # Download appropriate pagckage | ||
#* <code> wget https://repo.percona.com/apt/percona- | #* <code> wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb </code> | ||
# Install package | # Install package | ||
#* <code> dpkg -i percona- | #* <code> dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb </code> | ||
# Enable the repository | |||
#* <code>percona-release setup ps80</code> | |||
# Update cache | # Update cache | ||
#* <code> apt-get update </code> | #* <code> apt-get update </code> | ||
| Line 22: | Line 24: | ||
== 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 32: | ||
#* <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> | ||