MYSQL 集群的数据节点错误信息归档

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 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 unpartitioned cluster, please investigate if there are error(s) on other node(s) (Arbitration error)
Error: 2305
Error data: Arbitrator decided to shutdown this node
Error object: QMGR (Line: 4897) 0x0000000e
Program: /usr/local/mysql/bin/ndbd
Pid: 6285
Trace: /usr/local/mysql/data/ndb_4_trace.log.1
Version: Version 5.1.21 (beta)
***EOM***

Time: Monday 3 December 2007 - 17:50:51
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)
Error: 2305
Error data: Arbitrator decided to shutdown this node
Error object: QMGR (Line: 4897) 0x0000000a
Program: /usr/local/mysql/bin/ndbd
Pid: 8794
Trace: /usr/local/mysql/data/ndb_4_trace.log.2Version: Version 5.1.21 (beta)***EOM***

2、我进行在线恢复的时候出现的。
[root@localhost data]# /usr/local/mysql/bin/ndb_restore -n5 -b1 -r -m --backup_path=/usr/local/mysql/data/BACKUP/BACKUP-1/
Nodeid = 5
Backup Id = 1
backup path = /usr/local/mysql/data/BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.22
Configuration error: Error : Could not alloc node id at 192.168.0.231 port 1186: No free node id found for mysqld(API).
Failed to initialize consumers

NDBT_ProgramExit: 1 - Failed

原因是我的管理节点配置中的SQL节点部分没有加空的[MYSQLD]部分。
所以我加了和SQL节点数目一致的[MYSQLD]就好了。