define nagios::service::mysql(
    $ensure = present,
    $check_hostname = 'localhost',
    $check_socket = 'absent',
    $check_username = 'nagios',
    $check_password = '',
    $check_mode = 'tcp'
){

    case $check_mode {
        # Check MySQL using TCP
        'tcp': {
            nagios::service { 'mysql_tcp':
                ensure => $ensure,
                check_command => "check_mysql_tcp!${check_hostname}!${check_username}!${check_password}",
            }
        }
        # Check MySQL using local socket
        default: {
            nagios::service { 'mysql_socket':
                ensure => $ensure,
                check_command => $check_socket ? {
                    'absent' => "check_mysql!${check_username}!${check_password}!${check_database}",
                    default => "check_mysql_socket!${check_socket}!${check_username}!${check_password}",
                },
            }
        }
    }
}