Nagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. We will be installing Nagios, required plugins and configuring it to monitor MySQL Database Server.<\/p>\n
Let’s unleash the power step by step:<\/p>\n
Step-1 : Install required stuff:<\/strong> Step-2 :Create Nagios user account and group<\/strong> Step-3: Downloads:<\/strong> Download nagios Download Nagios Plugins: Follow up articles:<\/b> Step-4: Install Nagios<\/strong><\/p>\n [If you miss step “make install-init” you may get:: error reading information on service nagios: No such file or directory ]<\/p>\n Configure Nagios Web Interface:<\/span> Step-5: Install plugins<\/strong> Step-6: Verify Installation, Starting nagios for the first time<\/strong><\/p>\n Here if you get Error:<\/em> <\/strong> Check \/etc\/httpd\/conf\/httpd.conf for DirectoryIndex. Make sure you do restart apache(httpd) and nagios every time you change the config file. You must have php installed.<\/p>\n Step-7: Download, Extract and install the MySQL Plugin:<\/strong><\/p>\n Step-8: Create database user:<\/strong> Step-9: Provide email address for nagiosadmin:<\/strong> Step-10: Configuring Nagios to Monitor MySQL Server<\/strong><\/p>\n Define check_mysql_health command as follows:<\/p>\n Enter services to be monitored in mysqlmonitoring.cfg:<\/p>\n Here we’ve monitored 3 services: Connection-time, io thread and sql thread (replication) status. You can monitor more parameters described here: http:\/\/labs.consol.de\/nagios\/check_mysql_health\/<\/p>\n Note: Every time you change configuration file, verify before starting nagios using command: Finally start nagios service and you’re done with nagios installation and configuration for monitoring MySQL.<\/p>\n I hope you’ve found this useful.<\/p>\n","protected":false},"excerpt":{"rendered":"Nagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. We will be installing Nagios, required plugins and configuring it to monitor MySQL…\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8,377,6],"tags":[147,224,142,427,146],"class_list":{"0":"post-1348","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-mysql","7":"category-mysql-articles","8":"category-technical","9":"tag-database-monitoring","10":"tag-install-nagio-step-by-step","11":"tag-installation","12":"tag-mysql","13":"tag-nagios"},"aioseo_notices":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/1348","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/comments?post=1348"}],"version-history":[{"count":27,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/1348\/revisions"}],"predecessor-version":[{"id":2388,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/1348\/revisions\/2388"}],"wp:attachment":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/media?parent=1348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/categories?post=1348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/tags?post=1348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nyum install httpd
\nyum install gcc
\nyum install glibc*
\nyum install gd*<\/code><\/p>\n
\nuseradd nagios
\npasswd nagios
\ngroupadd nagcmd
\nusermod -G nagcmd nagios
\nusermod -G nagcmd apache<\/code><\/p>\n
\nCreate directory:
\nmkdir NagiosSetup
\ncd NagiosSetup<\/code><\/p>\n
\nwget -X Get \"http:\/\/sourceforge.net\/projects\/nagios\/files\/nagios-3.x\/nagios-3.2.1\/nagios-3.2.1.tar.gz\/download\"<\/code><\/p>\n
\nwget -X Get \"http:\/\/sourceforge.net\/projects\/nagiosplug\/files\/nagiosplug\/1.4.15\/nagios-plugins-1.4.15.tar.gz\/download\"<\/code><\/p>\n
\n 1<\/strong><\/span>: Installing Percona Monitoring Tools for MySQL Nagios<\/a>.
\n 2<\/strong><\/span>: Adding remote MySQL Host to Nagios Setup<\/a>.<\/small>\n<\/p><\/blockquote>\ntar -xzvf nagios-3.2.1.tar.gz
\ncd nagios-3.2.1
\n.\/configure --with-command-group=nagcmd
\nmake all
\nmake install
\nmake install-config
\nmake install-commandmode
\nmake install-init
\nchkconfig --add nagios<\/code><\/p>\n
\nmake install-webconf
\nhtpasswd -c \/usr\/local\/nagios\/etc\/htpasswd.users nagiosadmin<\/code>
\n[specify password for nagios admin]<\/p>\n
\ntar xvf nagios-plugins-1.4.11.tar.gz
\ncd nagios-plugins-1.4.11
\n.\/configure --with-nagios-user=nagios --with-nagios-group=nagios
\nmake
\nmake install<\/code><\/p>\nservice nagios start<\/code>
\nBrowse: http:\/\/localhost\/nagios<\/p>\n
\n“You don’t have permission to access \/nagios\/ on this server.”<\/span><\/p>\n
\nIf it’s not having index.php add it as follows:<\/p>\nvi \/etc\/httpd\/conf\/httpd.conf
\nDirectoryIndex index.php index.html index.html.var<\/code><\/p>\nMonitoring MySQL:<\/h2>\n
wget http:\/\/labs.consol.de\/wp-content\/uploads\/2010\/10\/check_mysql_health-2.1.3.tar.gz<\/code><\/p>\ntar -zxvf check_mysql_health-2.1.3.tar.gz
\ncd check_mysql_health-2.1.3
\n.\/configure --prefix=\/usr\/local\/nagios --with-nagios-user=nagios --with-nagios-group=nagios --with-perl=\/usr\/bin\/perl
\nmake
\nmake install<\/code><\/p>\n
\ngrant usage, replication client on *.* to 'nagios'@'localhost' identified by 'nagios';<\/code><\/p>\n
\n[Change contacts.cfg file accordingly.]
\nvi \/usr\/local\/nagios\/etc\/objects\/contacts.cfg<\/code>
\n
\ndefine contact{
\ncontact_name nagiosadmin ; Short name of user
\nuse generic-contact ; Inherit default values from generic-contact template (defined above)
\nalias Kedar ; Full name of user
\nemail kedar@nitty-witty.com ; <<***** CHANGE THIS TO YOUR EMAIL ADDRESS ******
\n}<\/code><\/p>\nvi \/usr\/local\/nagios\/etc\/nagios.cfg <\/code>
\nadd following line:
\ncfg_file=\/usr\/local\/nagios\/etc\/objects\/mysqlmonitoring.cfg<\/code><\/p>\nvi \/usr\/local\/nagios\/etc\/objects\/commands.cfg<\/code><\/p>\ndefine command{
\ncommand_name check_mysql_health
\ncommand_line $USER1$\/check_mysql_health -H $ARG4$ --username $ARG1$ --password $ARG2$ --port $ARG5$ --mode $ARG3$
\n}<\/code><\/p>\nvi \/usr\/local\/nagios\/etc\/objects\/mysqlmonitoring.cfg<\/code>
\nAdd:<\/p>\ndefine service{
\nuse local-service
\nhost_name localhost
\nservice_description MySQL connection-time
\ncheck_command check_mysql_health!nagios!nagios!connection-time!127.0.0.1!3306!
\n}<\/code>
\n
\ndefine service{
\nuse local-service
\nhost_name localhost
\nservice_description MySQL slave-io-running
\ncheck_command check_mysql_health!nagios!nagios!slave-io-running!127.0.0.1!3306!
\n}<\/code>
\n
\ndefine service{
\nuse local-service
\nhost_name localhost
\nservice_description MySQL slave-sql-running
\ncheck_command check_mysql_health!nagios!nagios!slave-sql-running!127.0.0.1!3306!
\n}<\/code><\/p>\n
\n\/usr\/local\/nagios\/bin\/nagios -v \/usr\/local\/nagios\/etc\/nagios.cfg<\/code><\/p>\n Download PDF<\/a><\/h3>\n