I'm trying to setup a MySQL replica with the master on 5.7 and the slave on 5.5.
On the master I have disabled the binlog_checksum.
After import a dump of the database, change the master and start the slave, if I make a change on the master, the slave get this error:
Last_Errno: 1594 Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.
And if I run mysqlbinlog to the relay log, I get this error:
# mysqlbinlog /var/lib/mysql/mysql-relay-bin.000002 ... ERROR: Error in Log_event::read_log_event(): 'Sanity check failed', data_len: 61, event_type: 34 ERROR: Could not read entry at offset 270: Error in log format or read error. DELIMITER ; # End of log file ...
There's any chance to get this replication working? The upgrade process can be problematic for my client and I'm trying to avoid that.