MySQL集群ndb_mgmd误差

Question

我在Ubuntu上建立了MySQL集群。我的ndb_mgmd.cnf文件看起来：

[NDBD DEFAULT]
NoOfReplicas=2
DataDir= /var/lib/mysql-cluster

# Management Node
[NDB_MGMD]
NodeId=1
HostName=192.168.204.20
DataDir=/var/lib/mysql-cluster

# Storage Nodes (one for each node)
[NDBD]
NodeId=2
HostName=192.168.204.25
DataDir=/var/lib/mysql-cluster
[NDBD]
NodeId=3
HostName=192.168.204.26
DataDir=/var/lib/mysql-cluster

# SQL Nodes (one for each node)
[MYSQLD]
NodeId=4
HostName=192.168.204.30

现在我想编辑这个配置，所以我更改了这个文件：

[NDBD DEFAULT]
NoOfReplicas=2
DataDir= /var/lib/mysql-cluster

# Management Node
[NDB_MGMD]
NodeId=1
HostName=192.168.204.20
DataDir=/var/lib/mysql-cluster

# Storage Nodes (one for each node)
[NDBD]
NodeId=2
HostName=192.168.204.25
DataDir=/var/lib/mysql-cluster
[NDBD]
NodeId=3
HostName=192.168.204.26
DataDir=/var/lib/mysql-cluster

# SQL Nodes (one for each node)
[MYSQLD]
NodeId=4
HostName=192.168.204.25
[MYSQLD]
NodeId=5
HostName=192.168.204.26

但

ndb_mgm > show;

仍然显示：

Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from 192.168.204.25)
id=3 (not connected, accepting connect from 192.168.204.26)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.204.20  (mysql-5.1.51 ndb-7.1.9)

[mysqld(API)]   1 node(s)
id=4 (not connected, accepting connect from 192.168.204.30)

我试过：

sudo /etc/init.d/mysql-ndb-mgm restart
sudo ndb_mgmd --initial
sudo ndb_mgmd -f /etc/mysql/ndb_mgmd.cnf

但什么都不管用。有什么帮助吗？

Answer 1

MySQL集群将自己的配置缓存到通常位于/usr/mysql-集群中的文件中(使用rm命令行删除它并重新启动ndb_mgmd)。通常，启动ndb_mgmd时使用--初始get来解决这类问题，但是，您也可以使用--跳过配置缓存。

干杯，瓦格纳·比安奇