HEX
Server: Apache
System: Linux vpshost0650.publiccloud.com.br 4.4.79-grsec-1.lc.x86_64 #1 SMP Wed Aug 2 14:18:21 -03 2017 x86_64
User: bandeirantesbomb3 (10068)
PHP: 8.0.7
Disabled: apache_child_terminate,dl,escapeshellarg,escapeshellcmd,exec,link,mail,openlog,passthru,pcntl_alarm,pcntl_exec,pcntl_fork,pcntl_get_last_error,pcntl_getpriority,pcntl_setpriority,pcntl_signal,pcntl_signal_dispatch,pcntl_sigprocmask,pcntl_sigtimedwait,pcntl_sigwaitinfo,pcntl_strerror,pcntl_wait,pcntl_waitpid,pcntl_wexitstatus,pcntl_wifexited,pcntl_wifsignaled,pcntl_wifstopped,pcntl_wstopsig,pcntl_wtermsig,php_check_syntax,php_strip_whitespace,popen,proc_close,proc_open,shell_exec,symlink,system
Upload Files
File: //usr/lib/python2.7/site-packages/lap/check_mysql_cluster_ed.py
import MySQLdb

def __run__(params):

    try:
        if not params.get("default_file"):
            return([2, "Critical:" "connection file not informed"])
        else:
            min_node = params.get("mysql_min_node")

            connection =  MySQLdb.connect(read_default_file=params.get("default_file"))
            cursor = connection.cursor()
            cursor.execute("show status like 'wsrep_cluster_size';")
            result = cursor.fetchone()
            field, value = result

            if not result:
                return([2, "Critical: MySQL query error!"])
            elif int(value) < min_node:
                return([2, "Critical: MySQL cluster whitout minimal nodes"])
            elif int(value) == min_node:
                return([0, "OK"])
            else:
                return([2, "Unknown status"])

    except Exception, err:
        return([2, "Error: %s" % err])