MySQL 复制没有运行，尽管 mysql 说它正在运行
我使用 MMM 在主-主对中配置了两台服务器。我最近遇到一个问题，被动主服务器收到复制错误（收到的数据包大于 max_allowed_packet），但从服务器 IO 和 SQL 线程继续运行。即使从机没有执行新语句，秒数后面的主机仍然显示为 0。
我认为这种类型的错误会导致复制停止（过去就是这样做的）。相反，复制继续运行，我们的监视器没有注意到这个问题。此外，复制错误不断出现在 mysql 错误日志中，而不是“显示从属状态”中的“Last_Error”。
我们正在运行版本 5.0.33。
你知道这里发生了什么吗？谢谢！
I have two servers configured in a master-master pair using MMM. I recently had an issue where the passive master received a replication error (got a packet bigger than max_allowed_packet) but the slave IO and SQL threads continued running. And seconds_behind_master was still showing as 0 even though the slave was not executing new statements.
I thought this type of error would cause replication to stop (it's done this in the past). Instead replication kept running and our monitors didn't notice the problem. Also the replication errors continually showed up in the mysql error log, instead of "Last_Error" in "show slave status".
We are running version 5.0.33.
Any ideas what happened here? thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
对于允许的最大数据包大小，听起来您的两个数据库的配置不完全相同。至少网络协议的内容应该是相同的。
您是否尝试在两台机器上显示从属状态？
安静的失败是一种可怕的情况。我想知道哪些唱片没有成功。你有办法查出来吗？
您是否在错误日志中收到周期性错误或大量相同错误？被动主设备上的序列号是否递增？
雅各布
For the max allowed packet size, it sounds like your two DBs are not configured identically. At least the network protocol stuff should be identical.
Did you try show slave status on both machines?
Quiet failure is a terrible situation. I wonder what records did not make it. Do you have a way of finding out?
Are you getting periodic errors in the error log or a flood of identical errors? Is the sequence number incrementing on the passive master?
Jacob