SSH MySQL

SSH MYSQL Profile

This profile monitors a MySQL database on a remote UNIX system by using the SSH protocol for remote access. Please reference SSH Monitoring on UNIX Hosts document under GroundWork Reference>Administrator>GroundWork Monitor Profiles when using this profile. Please reference SSH document under GroundWork Profiles>SSH Profiles when using this profile.

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
ssh_mysql_engine	check_by_ssh_mysql_engine! root!d3v3l0p3r	$USER1$/check_by_ssh -H $HOSTADDRESS$ -t 60 -l "$USER17$" -C "$USER22$/check_mysql -H $HOSTADDRESS$ -u $ARG1$ -p $ARG2$"	percent_graph
ssh_process_mysqld	check_by_ssh_process_args!15!30! mysqld	$USER1$/check_by_ssh -H $HOSTADDRESS$ -t 60 -l "$USER17$" -C "$USER22$/check_procs -w $ARG1$ -c $ARG2$ -a $ARG3$"	percent_graph
ssh_process_mysqld_safe	check_by_ssh_process_args!1!1! mysqld_safe	$USER1$/check_by_ssh -H $HOSTADDRESS$ -t 60 -l "$USER17$" -C "$USER22$/check_procs -w $ARG1$ -c $ARG2$ -a $ARG3$"	percent_graph

Profile Package

This package includes the following files:

Profile Definitions

service-profile-ssh-mysql.xml
perfconfig-ssh-mysql.xml

Plugins Scripts on the GroundWork Server

check_by_ssh

Plugins Scripts on the Remote Monitored Server

check_procs
check_mysql

Performance Graphing Programs

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

ssh_mysql_engine

Graphs the average number of queries per second against all databases.
The Nagios service description must contain the string "ssh_mysql_engine".

ssh_process_mysqld

Graphs the number of mysqld processes.
The Nagios service description must contain the string "ssh_process".

ssh_process_mysqld_safe

Graphs the number of mysqld_safe processes.
The Nagios® service description must contain the string "ssh_process".

Performance Graphing Parameters

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