这篇博客主要讨论了MySQL集群数据节点遇到的问题及解决方法。包括IP冲突导致的数据节点关闭，解决方法是检查并调整节点IP设置；在线恢复时出现的配置错误，解决办法是确保管理节点配置中包含与SQL节点数量一致的[MYSQLD]部分；以及数据节点内部错误，通过增加配置文件中的MaxNoOfOrderedIndexes值来解决。
1、数据节点的IP地址和其它的客户端主机冲突导致的错误。
管理节点报告：
ndb_mgm> Node 4: Forced node shutdown completed. Caused by error 2305: 'Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s) on other node(s)(Arbitration error). Temporary error, restart node'.
数据节点错误日志：
[root@localhost data]# vi ndb_4_error.log
Current byte-offset of file-pointer is: 1067
Time: Saturday 1 December 2007 - 18:10:56
Status: Temporary error, restart node
Message: Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s) on other node(s) (Arbitration error)
Current byte-offset of file-pointer is: 1067
Time: Saturday 1 December 2007 - 18:10:56
Status: Temporary error, restart node
Message: Node lost connection to other nodes and can not form a
最低0.47元/天 解锁文章
349
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
