def main():
config = yaml.load(open("/etc/dmkit/dmkit.yaml"))
cm = get_cluster_manager()
for cluster,node in sorted(config["farms"].iteritems()):
for node_name,item in sorted(node["nodes"].iteritems()):
try:
role = item["roles"][0]
name = "%s_%s" %(cluster,role)
cursor = cm.get(name).get_cursor()
# sql = ("select variable_name,"
# "case when variable_name like %s "
# "then concat(variable_value/1024/1024/1024,'G') "
# "else variable_value end variable_value "
# "from information_schema.GLOBAL_VARIABLES "
# "where variable_name in (%s,%s) order by 1 ")
# cursor.execute(sql,('%BUFFER%SIZE%','innodb_buffer_pool_size','version'))
print cluster,node_name,role,
# for var_name,val_value in cursor.fetchall():
# print var_name,':',val_value,';',
sql = ("select sum(POOL_SIZE),sum(FREE_BUFFERS), sum(HIT_RATE)/count(*)/10 "
"from information_schema.INNODB_BUFFER_POOL_STATS")
cursor.execute(sql)
total_size, free_size, hit_rate = cursor.fetchone()
print 'Total_Buffe_Size: %sG; Free_Buffer_size: %sG, Hit_Rate: %s' % (
round(total_size * page_size/1024**3, 2),
round(free_size * page_size/1024**3, 2),
round(hit_rate, 2)
)
print
except Exception,e:
print e
print '****************'
time.sleep(0.1)
def main():
config = yaml.load(open("/etc/dmkit/dmkit.yaml"))
cm = get_cluster_manager()
for cluster,node in sorted(config["farms"].iteritems()):
for node_name,item in sorted(node["nodes"].iteritems()):
try:
role = item["roles"][0]
name = "%s_%s" %(cluster,role)
cursor = cm.get(name).get_cursor()
sql = ("select variable_name, variable_value "
"from information_schema.GLOBAL_VARIABLES "
"where variable_name in (%s) order by 1 "
)
cursor.execute(sql,('version',))
for var_name,val_value in cursor.fetchall():
if role=='b':
print cluster,node_name,role,var_name,':',val_value,';'
# if val_value.startswith('5.5'):
# print cluster,node_name,role,var_name,':',val_value,';'
# sql = "stop slave"
# cursor.execute(sql)
# time.sleep(0.1)
# sql = "CHANGE MASTER TO master_use_gtid = slave_pos"
# cursor.execute(sql)
# time.sleep(0.1)
# sql = "start slave"
# cursor.execute(sql)
# else:
# continue
except Exception,e:
print e
time.sleep(0.1)
def main():
config = yaml.load(open("/etc/dmkit/dmkit.yaml"))
cm = get_cluster_manager()
for cluster,node in sorted(config["farms"].iteritems()):
for node_name,item in sorted(node["nodes"].iteritems()):
try:
role = item["roles"][0]
name = "%s_%s" %(cluster,role)
cursor = cm.get(name).get_cursor()
sql = "select count(*) from information_schema.tables where table_name = %s "
cursor.execute(sql,'metadata_lock_info')
print cluster,node_name,role,
for val_value in cursor.fetchall():
print val_value
print
except Exception,e:
print e
print '****************'
time.sleep(0.1)
def main():
config = yaml.load(open("/etc/dmkit/dmkit.yaml"))
cm = get_cluster_manager()
for cluster,node in sorted(config["farms"].iteritems()):
for node_name,item in sorted(node["nodes"].iteritems()):
try:
role = item["roles"][0]
name = "%s_%s" %(cluster,role)
cursor = cm.get(name).get_cursor()
sql = "select variable_name,variable_value from information_schema.GLOBAL_VARIABLES where variable_name in (%s,%s,%s) order by 1 "
cursor.execute(sql,('extra_port','report_port','port'))
print cluster,node_name,role,
for var_name,val_value in cursor.fetchall():
print str(var_name) + ' : ' + str(val_value) + ' ;',
print
except Exception,e:
print e
print '****************'
time.sleep(0.1)
def main():
config = yaml.load(open("/etc/dmkit/dmkit.yaml"))
cm = get_cluster_manager()
for cluster,node in sorted(config["farms"].iteritems()):
for node_name,item in sorted(node["nodes"].iteritems()):
try:
role = item["roles"][0]
name = "%s_%s" %(cluster,role)
print name
cursor = cm.get(name).get_cursor()
sql = "grant select on *.* to backup@'127.0.0.1' identified by '6MigwNY0Rf'"
cursor.execute(sql)
sql = "flush privileges"
cursor.execute(sql)
# sql1 = "select count(*) as cn from information_schema.metadata_lock_info"
# cursor.execute(sql1)
# rs = cursor.fetchone()
# print name,rs
except Exception,e:
print e
print '****************'
time.sleep(0.1)
def main():
config = yaml.load(open("/etc/dmkit/dmkit.yaml"))
cm = get_cluster_manager()
for cluster,node in sorted(config["farms"].iteritems()):
for node_name,item in sorted(node["nodes"].iteritems()):
try:
role = item["roles"][0]
name = "%s_%s" %(cluster,role)
cursor = cm.get(name).get_cursor()
sql = ("select variable_name,"
"case when variable_name like %s "
"then concat(variable_value/1024/1024/1024,'G') "
"else variable_value end variable_value "
"from information_schema.GLOBAL_VARIABLES "
"where variable_name in (%s,%s) order by 1 ")
cursor.execute(sql,('%BUFFER%SIZE%','innodb_buffer_pool_size','version'))
print cluster,node_name,role,
for var_name,val_value in cursor.fetchall():
print var_name,':',val_value,';',
print
except Exception,e:
print e
print '****************'
time.sleep(0.1)