def mess_up_mysql(self): """Ruin MySQL's ability to restart.""" self.fix_mysql() # kill files server = create_server_connection(self.instance_id) cmd = "sudo cp /dev/null /var/lib/mysql/ib_logfile%d" for index in range(2): server.execute(cmd % index)
def fix_mysql(self): """Fix MySQL's ability to restart.""" if not FAKE_MODE: server = create_server_connection(self.instance_id) cmd = "sudo rm /var/lib/mysql/ib_logfile%d" for index in range(2): server.execute(cmd % index)
def find_mysql_proc_on_instance(self): server = create_server_connection(self.instance_id) cmd = "ps aux | grep /usr/sbin/mysqld " \ "| awk '{print $2}'" stdout, stderr = server.execute(cmd) try: return int(stdout) except ValueError: return None
def fix_mysql(self): """Fix MySQL's ability to restart.""" if not FAKE_MODE: server = create_server_connection(self.instance_id) cmd = "sudo rm /var/lib/mysql/ib_logfile%d" # We want to stop mysql so that upstart does not keep trying to # respawn it and block the guest agent from accessing the logs. instance_info.dbaas_admin.management.stop(self.instance_id) for index in range(2): server.execute(cmd % index)