【討論中】mysql cluster 增加數(shù)據(jù)節(jié)點(diǎn)

xGss2000

大家好：


    目前有一個(gè)問(wèn)題無(wú)法繼續(xù)了。

    以前是一個(gè)mysqlcluster 單機(jī)環(huán)境，即所有數(shù)據(jù)節(jié)點(diǎn) API節(jié)點(diǎn)都在一臺(tái)機(jī)器上。目前想增加一臺(tái)數(shù)據(jù)節(jié)點(diǎn)。

   但是有點(diǎn)問(wèn)題。


配置文件如下：


[ndb_mgmd]
hostname=localhost
datadir=/data0/cluster_data109/ndb_data
NodeId=1

[ndbd default]
noofreplicas=2
datadir=/data0/cluster_data109/ndb_data
DataMemory: 1500M
IndexMemory: 200M
MaxNoOfConcurrentTransactions:4096
MaxNoOfConcurrentOperations:500000
MaxNoOfLocalOperations:550000
MaxNoOfAttributes: 10000
MaxNoOfTables: 3000
MaxNoOfOrderedIndexes: 3000
MaxNoOfUniqueHashIndexes: 3000
MaxNoOfTriggers: 500

[ndbd]
hostname=localhost
NodeId=3

[ndbd]
hostname=localhost
NodeId=4

[ndbd]
hostname=192.168.39.157  -- 這里報(bào)錯(cuò)，意思是 localhost和非localhost不能一起使用。
NodeId=5

[ndbd]
hostname=192.168.39.157
NodeId=6

[mysqld]
NodeId=50

[mysqld]

[mysqld]

[mysqld]

xGss2000

2012-10-11 14:57:59 [MgmtSrvr] INFO     -- Loaded config from '/usr/local/mysql/mysql-cluster/ndb_1_config.bin.3'
2012-10-11 14:57:59 [MgmtSrvr] ERROR    -- at line 32: Mixing of localhost (default for [NDBD]HostName) with other hostname(compute-48-16.local) is illegal
2012-10-11 14:57:59 [MgmtSrvr] ERROR    -- at line 32: Could not store previous section of configuration file.
2012-10-11 14:57:59 [MgmtSrvr] ERROR    -- Could not load configuration from '/home/mysqlCluster/my_cluster/conf/config.ini'

xGss2000

把所有l(wèi)ocalhost 更改為ip地址也不行。

提示如下

--reload 重啟管理節(jié)點(diǎn)

--重啟一個(gè)數(shù)據(jù)節(jié)點(diǎn)

[root@compute-48-17 bin]# /home/mysqlCluster/mysqlc/bin/ndbd -c 192.168.39.158:1186
2012-10-11 14:35:05 [ndbd] INFO     -- Angel connected to '192.168.39.158:1186'
2012-10-11 14:35:35 [ndbd] ERROR    -- Failed to allocate nodeid, error: 'Error: Could not alloc node id at 192.168.39.158 port 1186: No free node id found for ndbd(NDB).'