def execute_status_command(self, orig_master_host, orig_master_ip, ssh_user, ssh_options, ssh_port): config_helper = MHA_config_helper(host=orig_master_host) if ssh_port is None: ssh_port = 22 self.debug_message("Doing sanity checks") mysql_user = config_helper.get_mysql_user() mysql_password = config_helper.get_mysql_password() if mysql_user == False or mysql_password == False: self.debug_message("Error accessing MySQL credentials from config") return MHA_IP_failover_helper.CODE_ERR_GENERAL if config_helper.get_manage_vip() == True: cluster_interface = config_helper.get_cluster_interface() writer_vip_cidr = config_helper.get_writer_vip_cidr() if cluster_interface == False or writer_vip_cidr == False: self.debug_message("Error fetching cluster_interface and " "writer_vip_cidr from config") return MHA_IP_failover_helper.CODE_ERR_GENERAL return MHA_IP_failover_helper.CODE_SUCCESS
def __init__(self, slave_host): self._slave_host_config_helper = MHA_config_helper(host=slave_host) self._slave_hostname = slave_host mysql_user = self._slave_host_config_helper.get_mysql_user() mysql_password = self._slave_host_config_helper.get_mysql_password() host_ip = self._slave_host_config_helper.get_host_ip() self._slave_host = MySQL_helper(host=host_ip, user=mysql_user, password=mysql_password)
def __init__(self, orig_master_host, orig_master_ip, orig_master_ssh_port, new_master_host, new_master_ip, new_master_ssh_port, ssh_options, privileged_users): self._orig_master_config_helper = MHA_config_helper( host=orig_master_host) self._new_master_config_helper = MHA_config_helper( host=new_master_host) self._orig_master = MySQL_helper( host=orig_master_ip, user=self._orig_master_config_helper.get_mysql_user(), password=self._orig_master_config_helper.get_mysql_password()) self._new_master = MySQL_helper( host=new_master_ip, user=self._new_master_config_helper.get_mysql_user(), password=self._new_master_config_helper.get_mysql_password()) self._orig_master_ip = orig_master_ip if orig_master_ssh_port is None: self._orig_master_ssh_port = 22 else: self._orig_master_ssh_port = orig_master_ssh_port self._new_master_ip = new_master_ip if new_master_ssh_port is None: self._new_master_ssh_port = 22 else: self._new_master_ssh_port = new_master_ssh_port self._ssh_options = ssh_options self._privileged_users = privileged_users self._user_grants_orig_master = []
def execute_start_command(self, orig_master_host, orig_master_ip, new_master_host, new_master_ip, ssh_user, ssh_options, ssh_port): config_helper = MHA_config_helper(host=new_master_host) new_master = MySQL_helper(host=new_master_ip, user=config_helper.get_mysql_user(), password=config_helper.get_mysql_password()) if ssh_port is None: ssh_port = 22 # Connect to the new master if new_master.connect() == False: return MHA_IP_failover_helper.CODE_ERR_GENERAL # If we have to manage the VIP, then assign the VIP to the new master if config_helper.get_manage_vip() == True: return_val = MHA_VIP_helper.assign_vip(config_helper=config_helper, host_ip=new_master_ip, ssh_user=ssh_user, ssh_port=ssh_port, ssh_options=ssh_options) if return_val == False: new_master.disconnect() return MHA_IP_failover_helper.CODE_ERR_GENERAL # Remove the read_only flag self.debug_message("Removing the read_only flag from the new master") new_master.unset_read_only() # Disconnect from the new master new_master.disconnect() return MHA_IP_failover_helper.CODE_SUCCESS
def execute_stopssh_command(self, orig_master_host, orig_master_ip, ssh_user, ssh_options, ssh_port): config_helper = MHA_config_helper(host=orig_master_host) orig_master = MySQL_helper(host=orig_master_ip, user=config_helper.get_mysql_user(), password=config_helper.get_mysql_password()) if ssh_port is None: ssh_port = 22 # If we have to manage the VIP, then remove the VIP from the original master if config_helper.get_manage_vip() == True: return_val = MHA_VIP_helper.remove_vip(config_helper=config_helper, host_ip=orig_master_ip, ssh_user=ssh_user, ssh_port=ssh_port, ssh_options=ssh_options) if return_val == True: exit_code = MHA_IP_failover_helper.CODE_SUCCESS else: exit_code = MHA_IP_failover_helper.CODE_ERR_GENERAL return exit_code