aboutsummaryrefslogtreecommitdiffstats
path: root/deploy/adapters/ansible/roles/ha/templates/failover.j2
blob: ebfa65f8f520ea5f48f8ff78f4a743c864a49100 (plain)
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
import ConfigParser, os, socket
import logging as LOG
import pxssh
import sys
import re

LOG_FILE="/var/log/mysql_failover"
try:
    os.remove(LOG_FILE)
except:
    pass

LOG.basicConfig(format='%(asctime)s %(message)s', datefmt='%m/%d/%Y %I:%M:%S %p', filename=LOG_FILE,level=LOG.DEBUG)
ha_vip = {{ HA_VIP }}
LOG.info("ha_vip: %s" % ha_vip)

#ha_vip = "10.1.0.50"
galera_path = '/etc/mysql/conf.d/wsrep.cnf'
pattern = re.compile(r"gcomm://(?P<prev_ip>.*)")

def ssh_get_hostname(ip):
    try:
        s = pxssh.pxssh()
        s.login("%s" % ip, "root", "root")
        s.sendline('hostname')   # run a command
        s.prompt()             # match the prompt
        result = s.before.strip()      # print everything before the prompt.
        return result.split(os.linesep)[1]
    except pxssh.ExceptionPxssh as e:
        LOG.error("pxssh failed on login.")
        raise

def failover(mode):
    config = ConfigParser.ConfigParser()
    config.optionxform = str
    config.readfp(open(galera_path))
    wsrep_cluster_address = config.get("mysqld", "wsrep_cluster_address")
    wsrep_cluster_address = pattern.match(wsrep_cluster_address).groupdict()["prev_ip"]

    LOG.info("old wsrep_cluster_address = %s" % wsrep_cluster_address)

    if mode == "master":
        # refresh wsrep_cluster_address to null
        LOG.info("I'm being master, set wsrep_cluster_address to null")
        wsrep_cluster_address = ""

    elif mode == "backup":
        # refresh wsrep_cluster_address to master int ip
        hostname = ssh_get_hostname(ha_vip)
        wsrep_cluster_address = socket.gethostbyname(hostname)
        LOG.info("I'm being slave, set wsrep_cluster_address to master internal ip")

    LOG.info("new wsrep_cluster_address = %s" % wsrep_cluster_address)
    wsrep_cluster_address  = "gcomm://%s" % wsrep_cluster_address
    config.set("mysqld", "wsrep_cluster_address", wsrep_cluster_address)
    with open(galera_path, 'wb') as fp:
        #config.write(sys.stdout)
        config.write(fp)

    os.system("service mysql restart")
    LOG.info("failover success!!!")

if __name__ == "__main__":
    LOG.debug("call me: %s" % sys.argv)
    failover(sys.argv[1])