mysql主备同步系统优化建议

mysql主备同步问题总结

一、能用命令修复的几种报错：

基础知识：mysql主备同步模式有三种：半同步、异步和双通道. 其中,半同步和异步同步模式在备库上执行show slave status\G的结果只有row1, 若结果里除了row1还有row2,同步模式则为双通道。

1.1 last_errno:1305错误
last_error:error ‘savepoint trans5 does not exist’ on query. Default database: ‘shop’. Query: ‘release savepoint’ trans5
解决方法:
在备库上执行：set global rds_query_event_filter = ‘RELEASE SAVEPOINT’; stop slave; start slave;

1.2 Last_SQL_Errno: 145
Last_SQL_Error: Worker 0 failed executing transaction ‘’ at master log mysql-bin.000080, end_log_pos 283450; Error ‘Table ‘./mysql/proc’ is marked as crashed and should be repaired’