Monitoring database services

In this recipe, we'll learn how Nagios Core can be used to monitor the status of a database server. We'll demonstrate this with the popular MySQL as an example, using the check_mysql plugin, and we'll discuss running an actual test query and specifying a similar check for PostgreSQL in the There's more section of this recipe.

Getting ready

You should have a Nagios Core 3.0 or newer server with at least one host configured already. We'll use the example of delphi.naginet, a host defined in its own file. You should also understand the basics of how hosts and services relate, which is covered in the recipes of Chapter 1, Understanding Hosts, Services, and Contacts.

For a check on a remote host to work from the monitoring ...

Get Nagios Core Administration Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.