Example #1
0
    def do_var(self, args):
        ''' '''
        if args is None:
            return

        sql = "select @@{0}".format(args)
        m_rows, m_cols = self.run_on_masters(sql)
        s_rows, s_cols = self.run_on_slaves(sql)
       
        padding = 15
        print "{0}{1}{2}".format("cluster".ljust(padding), "master".rjust(padding), "slave".rjust(padding))
        print self.ruler * padding  * 3
        for cluster_name in clusters:
            m_var = m_rows[cluster_name][0][0]
            s_var = s_rows[cluster_name][0][0]
            info = "{0}{1}{2}".format(cluster_name.ljust(padding), str(m_var).rjust(padding), str(s_var).rjust(padding))
            if m_var != s_var:
                info = Color.warning(info)

            print info