mysql ndb还原数据库_ndb_restore恢复出错

一共5个节点

ndb_mgm> show

Connected to Management Server at: localhost:1186

Cluster Configuration

---------------------

[ndbd(NDB)]     2 node(s)

id=2    @192.168.2.235  (mysql-5.1.34 ndb-7.0.6, Nodegroup: 0, Master)

id=3    @192.168.2.239  (mysql-5.1.34 ndb-7.0.6, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)

id=1    @192.168.2.240  (mysql-5.1.34 ndb-7.0.6)

[mysqld(API)]   2 node(s)

id=4    @192.168.2.231  (mysql-5.1.34 ndb-7.0.6)

id=5    @192.168.2.233  (mysql-5.1.34 ndb-7.0.6)

这里显示都是正常的

当在数据节点2恢复时报错：

[root@dg bin]# ./ndb_restore -b2 -n2 -c host=192.168.2.240 -m -r /u01/mysql/data/BACKUP/BACKUP-2

Backup Id = 2

Nodeid = 2

backup path = /u01/mysql/data/BACKUP/BACKUP-2

Opening file '/u01/mysql/data/BACKUP/BACKUP-2/BACKUP-2.2.ctl'

Backup version in files: ndb-6.3.11 ndb version: mysql-5.1.34 ndb-7.0.6

Stop GCP of Backup: 0

Configuration error: Error : Could not alloc node id at 192.168.2.240 port 1186: Connection done from wrong host ip 192.168.2.235.

Failed to initialize consumers

NDBT_ProgramExit: 1 - Failed

在管理节点有报错：

2009-07-24 19:54:20 [MgmSrvr] WARNING  -- Allocate nodeid (0) failed. Connection from ip 192.168.2.235. Returned error string "Con

nection done from wrong host ip 192.168.2.235."

2009-07-24 19:54:20 [MgmSrvr] INFO     -- Mgmt server state: node id's 2 3 connected but not reserved

网上查了和防火墙有关，但我的iptables 都是off的。

遇到过的朋友，帮我看看。

[本帖最后由 stronghearted 于 2009-7-28 11:33 编辑]