During replication from a lower version to a higher version, MySQL restarts repeatedly and a BUG message appears in the error log. Note: For synchronization from a lower version to a higher version, as long as the point of synchronization refers
During replication from a lower version to a higher version, MySQL restarts repeatedly and a BUG message appears in the error log. Note: For synchronization from a lower version to a higher version, as long as the point of synchronization refers
MySQL version:
Mysql5.5.19 (master)
Mysql5.1.59 (slave)
During replication from a lower version to a higher version, MySQL restarts repeatedly and a BUG message appears in the error log.
Note: For synchronization from a lower version to a higher version, the mysql Service of the Master node restarts cyclically as long as the synchronization point is incorrect. This is true for both MYSQL and Percona versions, but the versions are consistent, this problem will not occur. If the point is correct, the mysql service of the host Master will not be restarted cyclically due to synchronization errors.
For example, the binlog and POS points on the master are mysql-bin.000001, 107
On SLAVE, change master to MASTER_LOG_FILE = 'mysql-bin.000001 ', MASTER_LOG_POS = 106;
This will trigger the BUG. You can try.
The latest version 5.5.25a has been fixed.
However, it is not recommended to synchronize earlier versions to higher versions. The manual explains: