mysql同步出错问题
mysql>show slave status\\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: xxxxxxxx
Master_User: xxxxxxxx
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000036
Read_Master_Log_Pos: 11719407
Relay_Log_File: localhost-relay-bin.000338
Relay_Log_Pos: 911985373
Relay_Master_Log_File: mysql-bin.000035
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB: xxxxxxxx
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1594
Last_Error: 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.
Skip_Counter: 0
Exec_Master_Log_Pos: 911985228
Relay_Log_Space: 1085463840
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1594
Last_SQL_Error: 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.
1 row in set (0.00 sec)
注意上面的黑色字体。
执行
mysql>stop slave;
mysql>change master to master_host=’xxxxx’, master_user=’xxxx’,master_password=’xxxxxx’,master_port=3306,master_log_file=’mysql-bin.000036‘,master_log_pos=911985228;
mysql>start slave;
建议继续学习:
- 关于IO的同步,异步,阻塞,非阻塞 (阅读:14458)
- mysql 主从同步原理 (阅读:5702)
- 消息分发的同步均衡策略 (阅读:5019)
- 五款最好的免费同步软件 (阅读:3846)
- 大量小文件的实时同步方案 (阅读:3718)
- MySQL5.5复制/同步的新特性及改进 (阅读:3706)
- redis源代码分析 - replication (阅读:3394)
- rsync主动同步代码 (阅读:3114)
- 三款面向 Amazon S3 的开源文件同步工具之对比 (阅读:3060)
- truncate table 不能复制到从库 (阅读:2718)
扫一扫订阅我的微信号:IT技术博客大学习
- 作者:ready 来源: 架构研究室
- 标签: 同步
- 发布时间:2009-11-11 23:47:57
- [65] Oracle MTS模式下 进程地址与会话信
- [65] Go Reflect 性能
- [64] 如何拿下简短的域名
- [59] android 开发入门
- [59] IOS安全–浅谈关于IOS加固的几种方法
- [58] 图书馆的世界纪录
- [58] 【社会化设计】自我(self)部分――欢迎区
- [53] 视觉调整-设计师 vs. 逻辑
- [47] 界面设计速成
- [46] 读书笔记-壹百度:百度十年千倍的29条法则