/
check-wsrep-status.py
34 lines (30 loc) · 1.47 KB
/
check-wsrep-status.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
import commands
import sys
import os.path
def main(args_str=None):
openstack_ip_list_str = sys.argv[1]
os_ip_list = openstack_ip_list_str.split(",")
number_openstack_nodes = len(os_ip_list)
status,output = commands.getstatusoutput("cat /etc/contrail/mysql.token")
mysql_token = output
status,output = commands.getstatusoutput('mysql -uroot -p%s -e "show status like \'wsrep_local_state_comment\'"' % mysql_token )
print "wsrep_local_state_comment: %s" % output
if output.find("Synced") == -1:
sys.exit(1)
status,output = commands.getstatusoutput('mysql -uroot -p%s -e "show status like \'wsrep_local_state\'"' % mysql_token)
print "wsrep_local_state: %s" % output
if output.find("4") == -1:
#if output.find(str(number_openstack_nodes)) == -1:
sys.exit(1)
status,output = commands.getstatusoutput('mysql -uroot -p%s -e "show status like \'wsrep_cluster_size\'"' % mysql_token )
print "wsrep_cluster_size: %s" % output
#if output.find("4") == -1:
if output.find(str(number_openstack_nodes)) == -1:
for os_ip in os_ip_list:
if not os.path.exists("/etc/clear_mysql"):
status,output = commands.getstatusoutput('ssh -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null %s "pkill -9 mysql"' % (os_ip))
print "cleaning mysql in %s" % (output)
opens("/etc/clear_mysql", 'a').close()
sys.exit(1)
if __name__ == "__main__":
main(sys.argv[1:])