MySQL Monitoring With Nagios

Capabilities

Nagios provides complete monitoring of MySQL databases – including availability, database and table sizes, and many other key metrics!.

The easy to use built-in MySQL Server Wizard features metrics like:

• Connection Time
• Uptime
• Open Connections
• Thread Cache Hitrate
• Query Cache Hitrate
• MyISAM Key Cache Hitrate
• InnoDB Buffer Pool Hitrate
• Log Waits
• Table Cache Hitrate
• Index Usage
• Slow Queries
• Long Running Processes
• Slave I/O
• Slave SQL
• Slave Lag

Benefits

Implementing effective Mysql monitoring with Nagios offers the following benefits:

• Increased application availability
• Increased database performance
• Fast detection of database outages, failures, and table corruption
• Predictive analysis of storage requirements and index performance

Offloading MySQL to Remote Server

Check out our step-by-step guide for offloading the MySQL services from the central Nagios XI server to an external, remote server.

Offloading MySQL to Remote Server

Solutions

These Nagios solutions provide MySQL monitoring capabilities and benefits:

• Nagios XI
• Nagios Core

Resources

• MySQL Server wizard
• MySQL Query wizard
• MySQL Monitoring plugins

See Also

• Database
  Monitoring