亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標題: mysql 集群問題在網(wǎng)上查找了好久沒有解決 [打印本頁]

作者: daitaohong 時間: 2010-05-13 15:42
標題: mysql 集群問題在網(wǎng)上查找了好久沒有解決
三臺電腦做集群 192.168.0.100為管理節(jié)點，192.168.0.120和192.168.0.130做集群節(jié)點和mysql節(jié)點
my.conf的文件內(nèi)容為
[mysqld]
default-storage-engine=ndbcluster
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
#user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
#old_passwords=1

#[mysqld_safe]
#log-error=/var/log/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid
ndbcluster
ndb-connectstring=192.168.0.100
[ndbd]
connect-string=192.168.0.130,192.168.0.120
[ndb_mgm]
connect-string=192.168.0.130,192.168.0.120
[ndb_mgmd]
config-file=/etc/config.ini
[mysql_cluster]
ndb-connectstring=192.168.0.100
集群節(jié)點config.ini的內(nèi)容為
[tcp default]
PortNumber=2202
[ndbd default]
NoOfReplicas=2
[ndb_mgmd]
Id=1
hostname=192.168.0.100
datadir=/var/lib/mysql-cluster
[ndbd]
Id=2
HostName=192.168.0.120
datadai=/usr/local/mysql/data
[ndbd]
Id=3
HostName=192.168.0.130
datadir=/usr/local/mysql/data
[mysqld]
[mysqld]

奇怪的是我在別的地方用虛擬機可以成功，今天在單位又做實驗
192.168.0.100
[root@mysqlserver ~]# /usr/local/mysql/bin/ndb_mgmd -f /etc/config.ini
2010-05-13 15:05:20 [MgmtSrvr] INFO    -- NDB Cluster Management Server. mysql-5.1.44 ndb-7.1.3
2010-05-13 15:05:20 [MgmtSrvr] INFO    -- Loaded config from '/usr/local/mysql/mysql-cluster/ndb_1_config.bin.1'
可以啟動
在192.168.0.120上
/usr/local/mysql/bin/ndbd --initial
可以啟動沒有問題
但是在192.168.0.130上
/usr/local/mysql/bin/ndbd --initial
2010-05-13 15:08:50 [ndbd] INFO    -- Unable to alloc node id
2010-05-13 15:08:50 [ndbd] INFO    -- Error : Could not alloc node id at 192.168.0.100 port 1186: Connection done from wrong host ip 192.168.0.130.
error=2350
2010-05-13 15:08:50 [ndbd] INFO    -- Error handler shutting down system
2010-05-13 15:08:50 [ndbd] INFO    -- Error handler shutdown completed - exiting
sphase=0
exit=-1
啟動不了
請教高手我的問題在哪里

歡迎光臨 Chinaunix (http://72891.cn/)