def _switchover(self):
"""Perform switchover from master to candidate slave
This method switches the role of master to a candidate slave. The
candidate is specified via the --candidate option.
Returns bool - True = no errors, False = errors reported.
"""
# Check new master is not actual master - need valid candidate
candidate = self.options.get("new_master", None)
if (self.topology.master.is_alias(candidate['host'])
and self.master_vals['port'] == candidate['port']):
err_msg = ERROR_SAME_MASTER.format(candidate['host'],
candidate['port'],
self.master_vals['host'],
self.master_vals['port'])
self._report(err_msg, logging.WARN)
self._report(err_msg, logging.CRITICAL)
raise UtilRplError(err_msg)
# Check for --master-info-repository=TABLE if rpl_user is None
if not self._check_master_info_type():
return False
# Check for mixing IP and hostnames
if not self._check_host_references():
print "# WARNING: %s" % _HOST_IP_WARNING
self._report(_HOST_IP_WARNING, logging.WARN, False)
# Check prerequisites
if candidate is None:
msg = "No candidate specified."
self._report(msg, logging.CRITICAL)
raise UtilRplError(msg)
self._report(" ".join([
"# Performing switchover from master at",
"%s:%s" % (self.master_vals['host'], self.master_vals['port']),
"to slave at %s:%s." % (candidate['host'], candidate['port'])
]))
if not self.topology.switchover(candidate):
self._report("# Errors found. Switchover aborted.", logging.ERROR)
return False
return True
def _switchover(self):
"""Perform switchover from master to candidate slave
This method switches the role of master to a candidate slave. The
candidate is specified via the --candidate option.
Returns bool - True = no errors, False = errors reported.
"""
# Check new master is not actual master - need valid candidate
candidate = self.options.get("new_master", None)
if (self.topology.master.is_alias(candidate['host']) and
self.master_vals['port'] == candidate['port']):
err_msg = ERROR_SAME_MASTER.format(candidate['host'],
candidate['port'],
self.master_vals['host'],
self.master_vals['port'])
self._report(err_msg, logging.WARN)
self._report(err_msg, logging.CRITICAL)
raise UtilRplError(err_msg)
# Check for --master-info-repository=TABLE if rpl_user is None
if not self._check_master_info_type():
return False
# Check for mixing IP and hostnames
if not self._check_host_references():
print "# WARNING: %s" % _HOST_IP_WARNING
self._report(_HOST_IP_WARNING, logging.WARN, False)
# Check prerequisites
if candidate is None:
msg = "No candidate specified."
self._report(msg, logging.CRITICAL)
raise UtilRplError(msg)
self._report(" ".join(["# Performing switchover from master at",
"%s:%s" % (self.master_vals['host'],
self.master_vals['port']),
"to slave at %s:%s." %
(candidate['host'], candidate['port'])]))
if not self.topology.switchover(candidate):
self._report("# Errors found. Switchover aborted.", logging.ERROR)
return False
return True
def _switchover(self):
"""Perform switchover from master to candidate slave
This method switches the role of master to a candidate slave. The
candidate is specified via the --candidate option.
Returns bool - True = no errors, False = errors reported.
"""
# Check new master is not actual master - need valid candidate
candidate = self.options.get("new_master", None)
if (self.topology.master.is_alias(candidate['host']) and
self.master_vals['port'] == candidate['port']):
err_msg = ERROR_SAME_MASTER.format(candidate['host'],
candidate['port'],
self.master_vals['host'],
self.master_vals['port'])
self._report(err_msg, logging.WARN)
self._report(err_msg, logging.CRITICAL)
raise UtilRplError(err_msg)
# Check for --master-info-repository=TABLE if rpl_user is None
if not self._check_master_info_type():
return False
# Check for mixing IP and hostnames
if not self._check_host_references():
print("# WARNING: {0}".format(HOST_IP_WARNING))
self._report(HOST_IP_WARNING, logging.WARN, False)
# Check prerequisites
if candidate is None:
msg = "No candidate specified."
self._report(msg, logging.CRITICAL)
raise UtilRplError(msg)
# Can only check errant transactions if GTIDs are enabled.
if self.topology.gtid_enabled():
# Check existence of errant transactions on slaves
errant_tnx = self.topology.find_errant_transactions()
if errant_tnx:
force = self.options.get('force')
print("# ERROR: {0}".format(_ERRANT_TNX_ERROR))
self._report(_ERRANT_TNX_ERROR, logging.ERROR, False)
for host, port, tnx_set in errant_tnx:
errant_msg = (" - For slave '{0}@{1}': "
"{2}".format(host, port, ", ".join(tnx_set)))
print("# {0}".format(errant_msg))
self._report(errant_msg, logging.ERROR, False)
# Raise an exception (to stop) if tolerant mode is OFF
if not force:
raise UtilRplError("{0} Note: If you want to ignore this "
"issue, although not advised, please "
"use the utility with the --force "
"option.".format(_ERRANT_TNX_ERROR))
else:
warn_msg = ("Errant transactions check skipped (GTID not enabled "
"for the whole topology).")
print("# WARNING: {0}".format(warn_msg))
self._report(warn_msg, logging.WARN, False)
self._report(" ".join(["# Performing switchover from master at",
"%s:%s" % (self.master_vals['host'],
self.master_vals['port']),
"to slave at %s:%s." %
(candidate['host'], candidate['port'])]))
if not self.topology.switchover(candidate):
self._report("# Errors found. Switchover aborted.", logging.ERROR)
return False
return True
def _switchover(self):
"""Perform switchover from master to candidate slave
This method switches the role of master to a candidate slave. The
candidate is specified via the --candidate option.
Returns bool - True = no errors, False = errors reported.
"""
# Check new master is not actual master - need valid candidate
candidate = self.options.get("new_master", None)
if (self.topology.master.is_alias(candidate['host']) and
self.master_vals['port'] == candidate['port']):
err_msg = ERROR_SAME_MASTER.format(candidate['host'],
candidate['port'],
self.master_vals['host'],
self.master_vals['port'])
self._report(err_msg, logging.WARN)
self._report(err_msg, logging.CRITICAL)
raise UtilRplError(err_msg)
# Check for --master-info-repository=TABLE if rpl_user is None
if not self._check_master_info_type():
return False
# Check for mixing IP and hostnames
if not self._check_host_references():
print("# WARNING: {0}".format(HOST_IP_WARNING))
self._report(HOST_IP_WARNING, logging.WARN, False)
# Check prerequisites
if candidate is None:
msg = "No candidate specified."
self._report(msg, logging.CRITICAL)
raise UtilRplError(msg)
# Can only check errant transactions if GTIDs are enabled.
if self.topology.gtid_enabled():
# Check existence of errant transactions on slaves
errant_tnx = self.topology.find_errant_transactions()
if errant_tnx:
force = self.options.get('force')
print("# ERROR: {0}".format(_ERRANT_TNX_ERROR))
self._report(_ERRANT_TNX_ERROR, logging.ERROR, False)
for host, port, tnx_set in errant_tnx:
errant_msg = (" - For slave '{0}@{1}': "
"{2}".format(host, port, ", ".join(tnx_set)))
print("# {0}".format(errant_msg))
self._report(errant_msg, logging.ERROR, False)
# Raise an exception (to stop) if tolerant mode is OFF
if not force:
raise UtilRplError("{0} Note: If you want to ignore this "
"issue, although not advised, please "
"use the utility with the --force "
"option.".format(_ERRANT_TNX_ERROR))
else:
warn_msg = ("Errant transactions check skipped (GTID not enabled "
"for the whole topology).")
print("# WARNING: {0}".format(warn_msg))
self._report(warn_msg, logging.WARN, False)
self._report(" ".join(["# Performing switchover from master at",
"%s:%s" % (self.master_vals['host'],
self.master_vals['port']),
"to slave at %s:%s." %
(candidate['host'], candidate['port'])]))
if not self.topology.switchover(candidate):
self._report("# Errors found. Switchover aborted.", logging.ERROR)
return False
return True
try:
master_val, slaves_val, candidates_val = parse_topology_connections(
opt)
except UtilRplError:
_, e, _ = sys.exc_info()
print("ERROR: {0}".format(e.errmsg))
sys.exit(1)
# Check hostname alias
if new_master_val:
if check_hostname_alias(master_val, new_master_val):
master = Server({'conn_info': master_val})
new_master = Server({'conn_info': new_master_val})
parser.error(ERROR_SAME_MASTER.format(
n_master_host=new_master.host,
n_master_port=new_master.port,
master_host=master.host,
master_port=master.port))
if master_val:
for slave_val in slaves_val:
if check_hostname_alias(master_val, slave_val):
master = Server({'conn_info': master_val})
slave = Server({'conn_info': slave_val})
msg = ERROR_MASTER_IN_SLAVES.format(master_host=master.host,
master_port=master.port,
slaves_candidates=SLAVES,
slave_host=slave.host,
slave_port=slave.port)
parser.error(msg)
for cand_val in candidates_val:
try:
master_val, slaves_val, candidates_val = parse_topology_connections(
opt)
except UtilRplError:
_, e, _ = sys.exc_info()
print("ERROR: {0}".format(e.errmsg))
sys.exit(1)
# Check hostname alias
if new_master_val:
if check_hostname_alias(master_val, new_master_val):
master = Server({'conn_info': master_val})
new_master = Server({'conn_info': new_master_val})
parser.error(
ERROR_SAME_MASTER.format(n_master_host=new_master.host,
n_master_port=new_master.port,
master_host=master.host,
master_port=master.port))
if master_val:
for slave_val in slaves_val:
if check_hostname_alias(master_val, slave_val):
master = Server({'conn_info': master_val})
slave = Server({'conn_info': slave_val})
msg = ERROR_MASTER_IN_SLAVES.format(master_host=master.host,
master_port=master.port,
slaves_candidates=SLAVES,
slave_host=slave.host,
slave_port=slave.port)
parser.error(msg)
for cand_val in candidates_val:
if check_hostname_alias(master_val, cand_val):