def auto_failover(self, interval):
"""Automatic failover
Wrapper class for running automatic failover. See
run_automatic_failover for details on implementation.
This method ensures the registration/deregistration occurs
regardless of exception or errors.
interval[in] time in seconds to wait to check status of servers
Returns bool - True = success, raises exception on error
"""
failover_mode = self.options.get("failover_mode", "auto")
force = self.options.get("force", False)
# Initialize a console
console = FailoverConsole(self.topology.master,
self.topology.get_health,
self.topology.get_gtid_data,
self.topology.get_server_uuids,
self.options)
# Check privileges
self._report("# Checking privileges.")
errors = self.topology.check_privileges(failover_mode != 'fail')
if len(errors):
for error in errors:
msg = ("User {0} on {1}@{2} does not have sufficient "
"privileges to execute the {3} command "
"(required: {4}).").format(error[0], error[1], error[2],
'failover', error[3])
print("# ERROR: {0}".format(msg))
self._report(msg, logging.CRITICAL, False)
raise UtilRplError("Not enough privileges to execute command.")
# Unregister existing instances from slaves
self._report("Unregistering existing instances from slaves.",
logging.INFO, False)
console.unregister_slaves(self.topology)
# Register instance
self._report("Registering instance on master.", logging.INFO, False)
old_mode = failover_mode
failover_mode = console.register_instance(force)
if failover_mode != old_mode:
self._report("Multiple instances of failover console found for "
"master %s:%s." % (self.topology.master.host,
self.topology.master.port),
logging.WARN)
print "If this is an error, restart the console with --force. "
print "Failover mode changed to 'FAIL' for this instance. "
print "Console will start in 10 seconds.",
sys.stdout.flush()
i = 0
while i < 9:
time.sleep(1)
sys.stdout.write('.')
sys.stdout.flush()
i += 1
print "starting Console."
time.sleep(1)
try:
res = self.run_auto_failover(console, failover_mode)
except:
raise
finally:
try:
# Unregister instance
self._report("Unregistering instance on master.", logging.INFO,
False)
console.register_instance(True, False)
self._report("Failover console stopped.", logging.INFO, False)
except:
pass
return res
def auto_failover(self, interval):
"""Automatic failover
Wrapper class for running automatic failover. See
run_automatic_failover for details on implementation.
This method ensures the registration/deregistration occurs
regardless of exception or errors.
interval[in] time in seconds to wait to check status of servers
Returns bool - True = success, raises exception on error
"""
failover_mode = self.options.get("failover_mode", "auto")
force = self.options.get("force", False)
# Initialize a console
console = FailoverConsole(self.topology.master,
self.topology.get_health,
self.topology.get_gtid_data,
self.topology.get_server_uuids, self.options)
# Unregister existing instances from slaves
self._report("Unregistering existing instances from slaves.",
logging.INFO, False)
console.unregister_slaves(self.topology)
# Register instance
self._report("Registering instance on master.", logging.INFO, False)
old_mode = failover_mode
failover_mode = console.register_instance(force)
if failover_mode != old_mode:
self._report(
"Multiple instances of failover console found for "
"master %s:%s." %
(self.topology.master.host, self.topology.master.port),
logging.WARN)
print "If this is an error, restart the console with --force. "
print "Failover mode changed to 'FAIL' for this instance. "
print "Console will start in 10 seconds.",
sys.stdout.flush()
i = 0
while i < 9:
time.sleep(1)
sys.stdout.write('.')
sys.stdout.flush()
i += 1
print "starting Console."
time.sleep(1)
try:
res = self.run_auto_failover(console, interval, failover_mode)
except:
raise
finally:
try:
# Unregister instance
self._report("Unregistering instance on master.", logging.INFO,
False)
console.register_instance(True, False)
self._report("Failover console stopped.", logging.INFO, False)
except:
pass
return res
def auto_failover(self, interval):
"""Automatic failover
Wrapper class for running automatic failover. See
run_automatic_failover for details on implementation.
This method ensures the registration/deregistration occurs
regardless of exception or errors.
interval[in] time in seconds to wait to check status of servers
Returns bool - True = success, raises exception on error
"""
failover_mode = self.options.get("failover_mode", "auto")
force = self.options.get("force", False)
# Initialize a console
console = FailoverConsole(self.topology.master,
self.topology.get_health,
self.topology.get_gtid_data,
self.topology.get_server_uuids,
self.options)
# Check privileges
self._report("# Checking privileges.")
errors = self.topology.check_privileges(failover_mode != 'fail')
if len(errors):
for error in errors:
msg = ("User {0} on {1}@{2} does not have sufficient "
"privileges to execute the {3} command "
"(required: {4}).").format(error[0], error[1], error[2],
'failover', error[3])
print("# ERROR: {0}".format(msg))
self._report(msg, logging.CRITICAL, False)
raise UtilRplError("Not enough privileges to execute command.")
# Unregister existing instances from slaves
self._report("Unregistering existing instances from slaves.",
logging.INFO, False)
console.unregister_slaves(self.topology)
# Register instance
self._report("Registering instance on master.", logging.INFO, False)
old_mode = failover_mode
failover_mode = console.register_instance(force)
if failover_mode != old_mode:
self._report("Multiple instances of failover console found for "
"master %s:%s." % (self.topology.master.host,
self.topology.master.port),
logging.WARN)
print "If this is an error, restart the console with --force. "
print "Failover mode changed to 'FAIL' for this instance. "
print "Console will start in 10 seconds.",
sys.stdout.flush()
i = 0
while i < 9:
time.sleep(1)
sys.stdout.write('.')
sys.stdout.flush()
i += 1
print "starting Console."
time.sleep(1)
try:
res = self.run_auto_failover(console, failover_mode)
except:
raise
finally:
try:
# Unregister instance
self._report("Unregistering instance on master.", logging.INFO,
False)
console.register_instance(True, False)
self._report("Failover console stopped.", logging.INFO, False)
except:
pass
return res
def auto_failover(self, interval):
"""Automatic failover
Wrapper class for running automatic failover. See
run_automatic_failover for details on implementation.
This method ensures the registration/deregistration occurs
regardless of exception or errors.
interval[in] time in seconds to wait to check status of servers
Returns bool - True = success, raises exception on error
"""
failover_mode = self.options.get("failover_mode", "auto")
force = self.options.get("force", False)
# Initialize a console
console = FailoverConsole(self.topology.master,
self.topology.get_health,
self.topology.get_gtid_data,
self.topology.get_server_uuids,
self.options)
# Unregister existing instances from slaves
self._report("Unregistering existing instances from slaves.",
logging.INFO, False)
console.unregister_slaves(self.topology)
# Register instance
self._report("Registering instance on master.", logging.INFO, False)
old_mode = failover_mode
failover_mode = console.register_instance(force)
if failover_mode != old_mode:
self._report("Multiple instances of failover console found for "
"master %s:%s." % (self.topology.master.host,
self.topology.master.port),
logging.WARN)
print "If this is an error, restart the console with --force. "
print "Failover mode changed to 'FAIL' for this instance. "
print "Console will start in 10 seconds.",
sys.stdout.flush()
i = 0
while i < 9:
time.sleep(1)
sys.stdout.write('.')
sys.stdout.flush()
i += 1
print "starting Console."
time.sleep(1)
try:
res = self.run_auto_failover(console, interval, failover_mode)
except:
raise
finally:
try:
# Unregister instance
self._report("Unregistering instance on master.", logging.INFO,
False)
console.register_instance(True, False)
self._report("Failover console stopped.", logging.INFO, False)
except:
pass
return res
