RDS MySQL replication error: Slave failed to initialize relay log info structure from the repository
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository
This issue happens on configuring MySQL replication from AWS RDS to self-hosted server. We can resolve this by restarting the replication.
Step1: Login to the slave MySQL terminal as root.
Step2: Check the slave status.
>show slave status \G;
Please note tha values of Master_Log_File and Read_Master_Log_Pos from the result.
Step3: Reset the slave.
This will clear the master replication configurations from slave.
Step4: Reconfigure replication.
>CHANGE MASTER TO MASTER_HOST='host', MASTER_USER='user', MASTER_PASSWORD='password', MASTER_LOG_FILE='log-file', MASTER_LOG_POS= log-position;
Here we need to replace the values of host, user, password, log-file and log-position with the corresponding values.
Step5: Start the replication.
Now the replication should starts working.