MySQL/MariaDB template

This template is tested and in production for MySQL 5.1+ and MariaDB 5.2+
There is a separate template for monitoring replication slaves

Required perl modules:
libdbd-mysql-perl libdbi-perl

User parameters:

## For Tribily's MySQL Extended Role
UserParameter=mysql.ping,/usr/bin/mysqladmin -utribily -pr4nd0m ping|grep alive|wc -l
UserParameter=mysql.uptime,/usr/bin/mysqladmin -utribily -pr4nd0m status|cut -f2 -d":"|cut -f1 -d"T"
UserParameter=mysql.threads,/usr/bin/mysqladmin -utribily -pr4nd0m status|cut -f3 -d":"|cut -f1 -d"Q"
UserParameter=mysql.questions,/usr/bin/mysqladmin -utribily -pr4nd0m status|cut -f4 -d":"|cut -f1 -d"S"
UserParameter=mysql.slowqueries,/usr/bin/mysqladmin -utribily -pr4nd0m status|cut -f5 -d":"|cut -f1 -d"O"
UserParameter=mysql.qps,/usr/bin/mysqladmin -utribily -pr4nd0m status|cut -f9 -d":"
UserParameter=mysql.version,mysql -V | cut -f6 -d" " | sed 's/,//'
## For MySQL Replication monitoring
UserParameter=mysqlslave.iorun,/opt/tribily/bin/mysql_repl_status.pl iorun
UserParameter=mysqlslave.sqlrun,/opt/tribily/bin/mysql_repl_status.pl sqlrun
UserParameter=mysqlslave.secbmaster,/opt/tribily/bin/mysql_repl_status.pl secbmaster


Grant the following MySQL permissions:

GRANT USAGE ON test.* to tribily@localhost identified by 'r4nd0m';
GRANT REPLICATION CLIENT ON *.* TO 'tribilyagent'@'localhost' IDENTIFIED BY 'r4nd0m';