###########################################################################
##  Copyright (C) Wizardry and Steamworks 2017 - License: GNU GPLv3      ##
###########################################################################
 
check process mysql with pidfile /var/run/mysqld/mysqld.pid
    group mysql
    depend mysql_bin
    depend mysql_rc
    start program = "/etc/init.d/mysql start"
    stop program = "/etc/init.d/mysql stop"
    if failed host localhost port 3306 protocol mysql with timeout 15 seconds for 3 times within 4 cycles then restart
    if failed unixsocket /var/run/mysqld/mysqld.sock protocol mysql for 3 times within 4 cycles then restart
    # if 5 restarts with 5 cycles then timeout
 
check file mysql_bin with path /usr/sbin/mysqld
    group mysql
    if failed checksum then alert
    if failed permission 755 then alert
    if failed uid root then alert
    if failed gid root then alert
 
check file mysql_rc with path /etc/init.d/mysql
    group mysql
    if failed checksum then alert
    if failed permission 755 then alert
    if failed uid root then alert
    if failed gid root then alert