Nagios Plugin Mysql DB - "check_mysql"

1. DESCRIPTION

- Plugin Name :-  check_mysql
- Plugin Purpose :- To check health summary of MySQL Server

2. PRE-REQUISITS

- MySQL Client packages i.e. “mysql”

3. PLUGIN DETAILS

- Plugin simply checks for statitics of MySQL Server
- Based on “Excetpions” variable value alert is thrown

4. INPUT

-H, --hostname=ADDRESS
IP address or Hostname of MySQL Database Server (Note:- Hostname is getting resolved from Nagios Server)
-P, --port=INTEGER
Port number (default: 3306) for MySQL Database Server
-d, --database=STRING
Database name to be checked for in MySQL Database Server
-u, --username=STRING
Username to connect to MySQL Database Server
-p, --password=STRING
Password to connect to MySQL Database Server
-S, --check-slave
Check slave’s running status on MySQL Database Server
-w, --warning
WARNING status if slave server is more than INTEGER seconds behind master of MySQL Database Server
-c, --critical
CRITICAL status if slave server is more then INTEGER seconds behind master MySQL Database Server

5. OUTPUT

Possible outputs are as below,
- “ Uptime: 1398528  Threads: 10  Questions: 350332599  Slow queries: 236  Opens: 19348  Flush tables: 1  Open tables: 64  Queries per second avg: 250.501 “
Whenever plugin execution completes it gets the statitics of MySQL node as specified above.

6. EXAMPLE

/usr/lib64/nagios/plugins/check_mysql  -H [ HOSTADDRESS ] -P [ Port ]-d [ Database ] -u [ DBUser ] -p [ DBPass ]

7. Plugin can be found in default installation of Nagios Core or Nagios XI