Local MySQL

Local MySQL Profile

This profile monitors a MySQL database on a local UNIX system.

Services Configuration

Service - Definitions in Monarch are stored under this name.
Command Line - Service command name with arguments to be passed to the plugin.
Plugin Command Line - Plugin script called by Nagios for this Service.

Extended Info - The Extended Service Info definition, typically used for generating graphs.

Command lines displayed below are intended to be single line commands.

Service	Command Line	Plugin Command Line	Extended Info
local_mysql_engine_nopw	check_mysql_engine_nopw!root	$USER1$/check_mysql -H $HOSTADDRESS$ -u "$ARG1$"	number_graph
local_process_mysqld	check_local_procs_string!10!20!mysqld	$USER1$/check_procs -w "$ARG1$" -c "$ARG2$" -a "$ARG3$"	number_graph
local_process_mysqld_safe	check_local_procs_string!1!2!mysqld_safe	$USER1$/check_procs -w "$ARG1$" -c "$ARG2$" -a "$ARG3$"	number_graph

Profile Package

This package includes the following files:

Profile Definitions

service-profile-local-mysql.xml
perfconfig-local-mysql.xml

Plugins Scripts

check_procs
check_mysql

Performance Graphing Programs

number_graph.cgi

Installation

GroundWork Monitor includes many monitoring profiles for a variety of devices, systems and applications. Profiles already imported on a new GroundWork installation include Service Ping, SNMP Network, and SSH UNIX. The GroundWork Monitor Configuration tool is used to import updated Profiles and Profiles that require additional setup; the Profile XML file and its companion Performance Configuration definition file. Services can also be imported in addition to Service Profiles in the Profile Importer. The import process is documented under GROUNDWORK PROFILES > How to import profiles.

Implementation

This section contains detail settings used by this Profile. These parameters can be altered with the Configuration tool.

Command Parameters

Command parameters are in the Configuration Services section with the following names and default values.

local_mysql_engine_nopw

Check if the MySQL database responds.
$ARG1$ - Database user ID. Must be authorized to access MySQL.

local_process_mysqld

Check for the number of mysqld processes running.
$ARG1$ - A warning alert will be generated if the number of processes exceeds this value. The default is 10.
$ARG2$ - A critical alert will be generated if the number of processes exceeds this value. The default is 20.

local_process_mysqld_safe

Check for the number of mysqld_safe processes running.
$ARG1$ - A warning alert will be generated if the number of processes exceeds this value. The default is 1.
$ARG2$ - A critical alert will be generated if the number of processes exceeds this value. The default is 2.

Performance Graphing Parameters

The following parameters are used to generate performance charts. These parameters are set using the Configuration>Performance tool in GroundWork Monitor.