Mysql master-slave synchronization Last_IO_Errno:1236 error solution

What is the reason for the Last_IO_Errno:1236 error of Mysql master-slave synchronization? How can we solve this problem? Let's take a look at the records and solutions of this problem with the editor.

<script>ec(2);</script>

Error code from server:

Last_IO_Errno: 1236
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Slave can not handle replication events with the checksum that master is configured to log; the first event 'mysql-bin.000005' at 16750821, the last event read from '/usr/local/mysql/Binlog/mysql-bin.000005' at 16750821, the last byte read from '/usr/local/mysql/Binlog/mysql-bin.000005' at 120.'

After a rough analysis of the reasons, I personally think that the most likely factors are ① different MySQL versions; ② incomplete backup. This problem did not exist in the previous MySQL configuration with the same version. (Time issue, no specific test reason)

The main server was upgraded to the latest version of MySQL (5.6.29) due to the last PHP-induced downtime, and the slave server used the 5.5.49 version of the db when I just compiled it. Therefore, I infer that it may be caused by this problem. I have not read the official documentation and it is just my personal guess.

Another problem caused by different versions is:

[root@Backup tmp]# /usr/local/mysql/bin/mysql -uroot -p <./all.sql 
Enter password: 
ERROR 1064 (42000) at line 279: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STATS_PERSISTENT=0' at line 11

I was lazy and just recompiled a MySQL version of the same version. I didn't study the specific reasons carefully because the versions were different.

Slave temporarily skips error method:

MySQL

mysql>slave stop; #stop slave
mysql>SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
mysql>slave start; #start slave

How to permanently skip errors with slave:

vi /etc/my.cnf
[mysqld]
slave-skip-errors=1062,1053,1146 #Skip errors of the specified error no type #slave-skip-errors=all #Skip all errors

Summarize

The above is all the content of this article about the solution to the error Last_IO_Errno:1236 in Mysql master-slave synchronization. I hope it will be helpful to everyone. If you have any better solution, please leave a message and we can discuss it together.

Interested friends can refer to: Analysis of different error problems in MySQL table sorting rules, Introduction to enterprise production MySQL optimization, Analysis of MYSQL subquery and nested query optimization examples, etc. If you have any questions, please leave a message and the editor will reply to you in time. Thank you friends for supporting this site!