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.
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 ...