Shulou(Shulou.com)05/31 Report--

This article mainly explains "Linux MySQL master-slave synchronization failure error 1594 solution", the explanation content in the article is simple and clear, easy to learn and understand, please follow the small series of ideas slowly in-depth, together to study and learn "Linux MySQL master-slave synchronization failure error 1594 solution"!

mysql's master-slave synchronization hangs, and the error reported from the log is as follows:

120309 18:39:23 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000004' at position 2207467, relay log './ mysqld-relay-bin.000011' position: 2207613

120309 18:39:23 [ERROR] Error in Log_event::read_log_event(): 'read error', data_len: 166, event_type: 2

120309 18:39:23 [ERROR] Error reading relay log event: slave SQL thread aborted because of I/O error

120309 18:39:23 [ERROR] Slave SQL: 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.

Error_code: 1594

120309 18:39:23 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000004' position 2207467

The main reason for the analysis is because of power failure, so cause reading binlog error, according to some information on the Internet, repair method is:

1 stop slave;

2 change master to

3 master_host='192.168.1.251',

4 master_user='repl',

5 master_password='password',

6 master_log_file='mysql-bin.000004',

7 master_log_pos=2207467;

8 start slave;

This fixes OK. The synchronization file and synchronization point pos above are the last recorded location of the error reported in the log.

Thank you for reading, the above is the "Linux MySQL master-slave synchronization failure error 1594 solution" content, after learning this article, I believe that everyone on Linux MySQL master-slave synchronization failure error 1594 solution This problem has a deeper understanding, the specific use of the situation also needs to be verified. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.