Archive for the 'Databases' Category

How to Monitor MySQL Logs with Nagios Log Server

Many times when you run out of disk space on the Nagios XI server or you don’t shut down the VM properly, you end up with crashed tables in the MySQL database. One way to solve this issue is to monitor the mysqld.log for errors, and fix the problems in a timely matter. You can easily achieve this goal by monitoring the MySQL logs via  Nagios Log Server.

In this article, I will show you how to set up MySQL monitoring in Nagios Log Server, how to use simple searches and how to filter the results. Continue reading ‘How to Monitor MySQL Logs with Nagios Log Server’

Monitoring Apache Cassandra Database Nodes with Nagios XI

As cloud services grow in popularity, so do the networks that provide those cloud services.  Few webserver-based distributed databases are as easy to install and configure as Apache Cassandra.  Apache Cassandra is an open source distributed database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Cassandra offers robust support for clusters spanning multiple data centers, with asynchronous master-less replication allowing low latency operations for all clients.

Cassandra relies on the Java platform, and as those of you who have tried to configure Java app monitoring most likely know, the experience can be painful.  There are a handful of plugins on the Nagios Exchange that attempt to simplify the configuration.  As these plugins rely on the Apache Cassandra utility “nodetool”, you either need to install Cassandra on the Nagios server (which is not suggested) or use an agent (like NRPE) to run the plugin script directly from the Cassandra server (which should have the nodetool utility).

The Cluster Node Check is designed to verify whether the number of live nodes is less than a specified number, and if so trigger a warning or critical alert within Nagios.

Continue reading ‘Monitoring Apache Cassandra Database Nodes with Nagios XI’

Monitoring Your MongoDB Database and Server with the New Wizards in Nagios XI 2014

Every once in a while, a new database pushes to the front of the news. These databases generally bring a renewed schema and some neat tricks and features others may not offer. Due to the increasing popularity of MongoDB NoSQL databases, we have designed two new wizards for use with Nagios XI 2014: the MongoDB Database Wizard, and MongoDB Server Wizard. Continue reading ‘Monitoring Your MongoDB Database and Server with the New Wizards in Nagios XI 2014’

New Postgres Monitoring Wizards Released

Due to a number of customer requests, we got busy working on the development of monitoring wizards for Postgres database server. We just released three new wizards for complete monitoring of Postgres. You can find them on Nagios Exchange: