import MySQLdb

def __run__(params):
    conn = None

    try:
        f = params.get("defaults-file", "/etc/check_mk/mysql.cfg")
        conn = MySQLdb.connect(read_default_file=f)
        cursor = conn.cursor()

        # check if exists  MyIsam tables, because Xtradb Cluster doesn't sync this kind of table
        x = cursor.execute("select table_schema, table_name from information_schema.tables where engine='myisam' and table_schema  not in ('mysql','information_schema','teste','administration_schema','performance_schema');")

        if x == 0:
            return[0,'OK!']

        message = 'CRITICAL: The Cluster does not sync MyISAM tables!, ['
        for schema, table in cursor:
            message += '{0}.{1}, '.format(schema, table)
        return[2, message]

    except Exception, e:
        return [2, 'CRITICAL: {0}'.format(str(e))]
    finally:
        try:
            if conn:
                conn.close()
        except:
            # finally clause, don't bother about errors here
            pass