Monit is a free open source utility for managing and monitoring, processes, files, directories and filesystems on a UNIX system. Monit conducts automatic maintenance and repair and can execute meaningful causal actions in error situations. (unofficial mirror)
I have configured the mysql process monitoring with the below configurations. but i am not sure how to get those parameters using this tool. Please help me on this.
Also we are using the other databases like redis,mongo,elasticsearch. we have to capture those database data as well.
Configuration:
check process mysql with pidfile /usr/local/mysql-5.7.19-linux-glibc2.12-x86_64/data/host.net.pid
group database
start program = "/usr/local/mysql/bin/mysqld_safe"
stop program = "/usr/local/mysql/bin/mysqladmin shutdown"
if failed host my_ip port 3306 protocol mysql username "root" password "test" then restart
depends on mysql_bin
depends on mysql_rc
check file mysql_bin with path /usr/local/mysql/bin/mysqld
group database
if failed checksum then unmonitor
if failed permission 755 then unmonitor
if failed uid root then unmonitor
if failed gid root then unmonitor
check file mysql_rc with path /etc/init.d/mysql
group database
if failed checksum then unmonitor
if failed permission 755 then unmonitor
if failed uid root then unmonitor
if failed gid root then unmonitor
I want to monitor my mysql database performance with this tool. I have to capture the below mysql data.
mysql_connections mysql_locks mysql_task mysql_slow_query.............etc.
I have configured the mysql process monitoring with the below configurations. but i am not sure how to get those parameters using this tool. Please help me on this.
Also we are using the other databases like redis,mongo,elasticsearch. we have to capture those database data as well.
Configuration:
check process mysql with pidfile /usr/local/mysql-5.7.19-linux-glibc2.12-x86_64/data/host.net.pid group database start program = "/usr/local/mysql/bin/mysqld_safe" stop program = "/usr/local/mysql/bin/mysqladmin shutdown" if failed host my_ip port 3306 protocol mysql username "root" password "test" then restart depends on mysql_bin depends on mysql_rc
check file mysql_bin with path /usr/local/mysql/bin/mysqld group database if failed checksum then unmonitor if failed permission 755 then unmonitor if failed uid root then unmonitor if failed gid root then unmonitor
check file mysql_rc with path /etc/init.d/mysql group database if failed checksum then unmonitor if failed permission 755 then unmonitor if failed uid root then unmonitor if failed gid root then unmonitor
Thanks in advance