Setting-up second MySQL instance & replication on Linux in 10 steps
This is a quick setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.
pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain
This post discuss the pt-table-checksum & error “Waiting to check replicas for differences: 0% 00:00 remain” with a use-case and solution.
How to Add Remote MySQL Server to Nagios Monitoring
We already have seen two articles for setting up MySQL Monitoring with Nagios and Percona Monitoring Tools for Nagios. Those posts covers configuration of nagios on single instance. Though following…
MySQL Permission denied error 13 and solution
MySQL ERROR 1018 (HY000): Can’t read dir of ‘./sakila/’ (errno: 13 – Permission denied) caused due to moving database to a different partition and using softlink on CentOS and it’s fix for SELinux.
How to monitor MySQL backups
It’s important to monitor the (database) backups after you set-it-up. In this post we will answer a few how to monitor MySQL Database backups solutions – monitoring methods. We should…
Install Percona Monitoring Tools for Nagios – MySQL Plugins
Recently a friend asked about Installing Percona Monitoring Tools for Nagios as he was facing a few issues. I managed to set-it-up on my ubuntu VM. Sharing the the work-log…
7 responses to “Install Percona Monitoring Tools for Nagios – MySQL Plugins”
Hi kedar,
i am getting below error for active threads.
ERROR 1045 (28000): Access denied for user ‘user’@’X.X.X.X’ (using password: NO)
kindly help
Regards,
Balu
“using password: NO” — Are you not providing password? Is that correct?
@Ashish Karpe The url below may help you. You can try:
https://translate.google.com/translate?hl=en&sl=ru&u=https://kamaok.org.ua/%3Fp%3D1470&prev=search
Hi,
Here is sample nrpe.cfg for percona-mysql plugins !
command[check_mysql_service]=/usr/local/nagios/libexec/check_mysqld.pl -H 192.168.1.68 -u root -p xx -a slow_queries -w 44 -c 55
#command[check_mysql_service]=/usr/local/nagios/libexec/check_mysql -H 192.168.168 –extra-opts=client@/etc/nagios/mysql.cnf
command[check_mysql_innodb]=/usr/local/nagios/libexec/pmp-check-mysql-innodb -H 192.168.1.68 -C idle_blocker_duration -w 60 -c 600
command[check_mysql_innodb]=/usr/local/nagios/libexec/pmp-check-mysql-innodb -H 192.168.1.68 -C max_duration -w 86400 -c 172800
command[check_mysql_active_threads]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -H 192.168.1.68 -x Threads_running -w 20 -c 40
command[rdba_mysql_pidfile]=/usr/lib64/nagios/plugins/pmp-check-mysql-pidfile
command[rdba_unix_memory]=/usr/lib64/nagios/plugins/pmp-check-unix-memory -d -w 96 -c 98
command[check_mysql_deadlocks]=/usr/lib64/nagios/plugins/pmp-check-mysql-deadlocks -H 192.168.1.68 -i 5 -w 12 -c 60
command[check_mysql_connections]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -H 192.168.1.68 -x Threads_connected -o / -y max_connections -T pct -w 80 -c 95
command[check_mysql_replication_delay]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-delay -H 192.168.1.68 -w 650 -c 600
#command[check_mysql_replication_delay]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-delay -H $HOSTADDRESS$ -w $ARG1$ -c $ARG2$
#command[rdba_mysql_pidfile]=/usr/lib64/nagios/plugins/pmp-check-mysql-pidfile
#command[pmp-check-mysql-processlist]=/usr/lib64/nagios/plugins/pmp-check-mysql-processlist
#command[check_mysql_counters_percona]=/usr/local/nagios/libexec/check_mysql_counters -H 192.168.1.69 -P 3306 -u root -p xxxx
command[check_mysql_processlist]=/usr/local/nagios/libexec/pmp-check-mysql-processlist -H 192.168.1.68 -w 80 -c 100
#command[check_mysql_processlist]=/usr/local/nagios/libexec/pmp-check-mysql-processlist -H 192.168.1.68 -C max_user_conn -w 80 -c 100
#command[check_mysql_processlist]=/usr/local/nagios/libexec/pmp-check-mysql-processlist -H 192.168.1.68 -C 512 -w 80 -c 100
#command[check_mysql_table_checksum]=/usr/local/nagios/libexec/pmp-check-pt-table-checksum -H 192.168.1.69
command[check_mysql_replication_running]=/usr/local/nagios/libexec/pmp-check-mysql-replication-running -H 192.168.1.68
Can i get sample nrpe.cfg for percona plugins ? plz
Hello,
Thanks,
It’s OK for me.
Hello, thank you for this tuto, I tried to install it but I have error messages.
Besides this command (check_mysql_service) does not exist.
my errors :
MySQL InnoDB Long Transaction
CRITICAL 07-23-2015 11:43:46 0d 1h 25m 25s 3/3 (Service check timed out after 60.09 seconds)