mysql主从同步报错 Got fatal error 1236 from master when reading data from binary log
来源:互联网 发布:淘宝网的商品分类 编辑:程序博客网 时间:2024/05/17 03:37
突然发现从库不同步主库了 ,不知道是什么原因 来不及分析 只能先恢复
报错;Got fatal error 1236 from master when reading data from binary log
刚开始怎么的执行set global sql_slave_skip_counter=1; 再执行什么stop/start slave都不行,真是没有办法了。后来Google了一个日志发现以下步骤,终于搞好了。记录一下,以后遇到可以马上搞定。
解决方法:
Slave: stop slave;
Master: flush logs
Master: show master status;
Slave: CHANGE MASTER TO MASTER_LOG_FILE=’log-bin.00000X’, MASTER_LOG_POS=106;
Slave: start slave;
0 0
- mysql主从同步报错 Got fatal error 1236 from master when reading data from binary log
- 刚建的mysql主从,但是主机的bin日志没有开启,报如下错:Got fatal error 1236 from master when reading data from binary log: '
- MySQL之Got fatal error 1236 from master when reading data from binary log
- Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find
- Got fatal error 1236 from master when reading data from binary log
- Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find
- Got fatal error 1236 from master when reading data from binary log
- Got fatal error 1236 from master when reading data from binary log
- MySQL 的一次错误处理 Got fatal error 1236 from master when reading data from binary log
- 主库磁盘满,从库io线程报错Got fatal error 1236 from master when reading data from binary log
- Got fatal error 1236 from master when reading data from binary log: ‘Slave can not handle replicatio
- Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Slave can not h
- Got fatal error 1236 from master when reading data from binary log: 'A slave with the same server_uu
- Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary lo
- Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary lo
- mysql主从同步失败Last_IO_Error: Got fatal error 1236 from master解决方法
- error 1236 from master when reading data from binary log: 'Slave can not handle replication events w
- Got fatal error 1236 from master
- php学习-11for循环
- Codeforces Round #316 (Div. 2) (ABC题)
- codeforces 232D. Fence
- 黑马程序员 继承
- 【笔记】互联网+:运营商
- mysql主从同步报错 Got fatal error 1236 from master when reading data from binary log
- php学习-12函数
- tar压缩命令
- Linux学习笔记---用户管理命令---
- Javascript 面向对象编程(一):封装
- hdu 2883 kebab(时间区间压缩 && dinic)
- 程序员跳槽全攻略
- Objective-C #include、#import 、 @class的使用区别
- php学习-13数组