mysql cluster的ndbd不能启动

shashasu

我现在用3台机器作mysql cluster

管理节点：T2000-up
SQL节点：t2000-down
NDBD存储节点：x4200-up

管理节点
bash-3.00# more /etc/config.ini
[mysqld]
#basedir=/opt/coolstack/mysql_32bit
#datadir=/opt/coolstack/mysql_32bit/data
[NDBD DEFAULT]
NoOfReplicas=1
[TCP DEFAULT]
portnumber=3306
[NDB_MGMD]
hostname=T2000_up
datadir=/opt/coolstack/mysql_32bit/data
[NDBD]
hostname=x4200-up
datadir=/opt/coolstack/mysql_32bit/data
[MYSQLD]

SQL节点
bash-3.2# more /etc/my.cnf
[mysqld]
basedir=/opt/coolstack/mysql_32bit
datadir=/mysql-data
user=mysql
port=3306
socket=/tmp/mysql.sock
ndbcluster
ndb-connectstring=T2000_up
[MYSQL_CLUSTER]
ndb-connectstring=T2000_up
ndb-mgmd-host=T2000_up:3306
ndb-nodeid=1

NDBD存储节点：
bash-3.00# more /etc/my.cnf
[mysqld]
#basedir=/opt/coolstack/mysql_32bit
#datadir=/opt/coolstack/mysql_32bit/data
ndbcluster
ndb-connectstring=T2000_up
[MYSQL_CLUSTER]
ndb-connectstring=T2000_up
ndb-mgmd-host=T2000_up

但是我在存储节点运行ndbd --initial
error=2350
2008-03-13 11:23:21 [ndbd] INFO     -- Error handler restarting system
2008-03-13 11:23:21 [ndbd] INFO     -- Error handler shutdown completed - exiting
sphase=0
exit=-1

我运行ndbd -c T2000_up
error=2350
2008-03-13 11:23:21 [ndbd] INFO     -- Error handler restarting system
2008-03-13 11:23:21 [ndbd] INFO     -- Error handler shutdown completed - exiting
sphase=0
exit=-1

怎么回事啊？（这3个机器是互通的）

yueliangdao0608

写成
NoOfReplicas=2

而且你要确认你的t2000_up可以被解析！

shashasu

t2000_up可以被解析，现在我已经全部换成IP了
但不行
连ndb_mgmd 都不能启动了

bash-3.00# ndb_mgmd -f /etc/config.ini
Error line 18: Invalid no of db nodes wrt no of replicas.
No of nodes must be dividable with no or replicas
Invalid configuration file: /etc/config.ini
bash-3.00# more /etc/config.ini
[mysqld]
#basedir=/opt/coolstack/mysql_32bit
#datadir=/opt/coolstack/mysql_32bit/data
[NDBD DEFAULT]
NoOfReplicas=2

[TCP DEFAULT]
#portnumber=3306
[NDB_MGMD]
#hostname=T2000_up
hostname=10.10.11.30
datadir=/opt/coolstack/mysql_32bit/data
[NDBD]
hostname=10.10.11.110
datadir=/opt/coolstack/mysql_32bit/data
[MYSQLD]
#hostname=t2000-down
#hostname=x4200-up

showsa

晕，啥时候一个 NDB 节点可以组 MySQL Cluster了？
现在很多人都是瞎折腾

yueliangdao0608

原帖由 showsa 于 2008-3-13 10:00 发表
晕，啥时候一个 NDB 节点可以组 MySQL Cluster了？
现在很多人都是瞎折腾

都没有看到LZ用的是一个NDBD节点。晕