• mysql同步复制报Slave can not handle replication events with the checksum that master 错误


    slave服务器,查看状态时,发现下面的错误:

    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.000001' at 5115510, the last event read from './mysql-bin.000001' at 5115510, the last byte read from './mysql-bin.000001' at 120.'

    搜了一下,原来是mysql版本的问题,原来都是5.5的,后来主库机器的硬盘坏了,重新装了一个5.6版本的mysql。据说5.6的binlog_checksum 默认设置的是 crc32

    更改master的binlog_checksum 为none即可,

  • 相关阅读:
    《JavaScript语言精粹》学习心得
    Linq笔记
    关于缓存
    JS-替换全部全部字符串
    相同数据用分号分割
    单例模式
    es6- ArrayBuffer
    vue常用属性解释。
    装饰者模式
    中介者模式
  • 原文地址:https://www.cnblogs.com/jenqz/p/3629560.html
Copyright © 2020-2023  润新知