Problem: Slave cannot start after changing relay log directory
2018-08-03t02:53:36.172465z 0 [ERROR] Failed to open the relay log './mysql03-relay-bin.000018 ' (relay_log_ POS 9680848). 2018-08-03t02:53:36.172515z 0 [ERROR] Could not find target log file mentioned in relay log info in the index File '/var/lib/mysql/logs/relay-bin.index ' during relay log initialization.2018-08-03t02:53:36.222879z 0 [ERROR] Slave : Failed to initialize the master info structure for channel '; Its record may still is present in ' mysql.slave_master_info ' table, consider deleting it.2018-08-03t02:53:36.222955z 0 [ER ROR] Failed to create or recover replication info repositories.2018-08-03t02:53:36.222995z 0 [ERROR] Slave SQL for Channel ": Slave failed to initialize relay log info structure from the repository, error_code:18722018-08-03t02:53:36.223007z 0 [ERROR]/usr/sbin/mysqld:slave failed to initialize relay log info structure from the repository2018-08-03t02:53:36.223 014Z 0 [ERROR] Failed to start slave threads for channel '
Processing method:
mysql> reset slave;mysql> change master to master_host=‘192.168.1.224‘,master_user=‘root‘,master_password=‘MySQL5.7‘,master_auto_position=1;mysql> start slave;
Slave fails to start after processing changes to MySQL relay log directory