mysql Could not alloc node id 簇问题（巳解决）

zhanghuiyun

                错误现象：Configuration error: Error : Could not alloc node id at 192.168.5.254 port 1186: Connection done from wrong host ip 192.168.5.45.
所有其它正常，在管节点上用show查看所有存储节点与sql节点正常 ，管理节点配置文件如下
#options affecting ndbd processes on all data nodes:
[NDBD DEFAULT]
NoOfReplicas=2    # Number of replicas
DataMemory=180M    # How much memory to allocate for data storage
IndexMemory=80M   # How much memory to allocate for index storage
                  # For DataMemory and IndexMemory, we have used the
                  # default values. Since the "world" database takes up
                  # only about 500KB, this should be more than enough for
                  # this example Cluster setup.
# TCP/IP options:
[TCP DEFAULT]
portnumber=2202   # This the default; however, you can use any
                  # port that is free for all the hosts in cluster
                  # Note: It is recommended beginning with MySQL 5.0 that
                  # you do not specify the portnumber at all and simply allow
                  # the default value to be used instead
# Management process options:
[NDB_MGMD]
id=1
hostname=192.168.5.254           # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster  # Directory for MGM node logfiles
# Options for data node "A":
[NDBD]
                                # (one [NDBD] section per data node)
id=2
hostname=192.168.5.45           # Hostname or IP address
datadir=/usr/local/mysql/data   # Directory for this data node's datafiles
# Options for data node "B":
[NDBD]
id=3
hostname=192.168.5.30          # Hostname or IP address
datadir=/usr/local/mysql/data   # Directory for this data node's datafiles
# SQL node options:
[MYSQLD]
id=4
hostname=192.168.5.238           # Hostname or IP address
                                # (additional mysqld connections can be
                                # specified for this node for various
                                # purposes such as running ndb_restore)
后另添加了跟数据存储节点一样的两个[MYSQLD]空选项，一切运行正常。如下是我更改后的管理节点配置文件
红色部分为我新添加的选项
[NDBD DEFAULT]
NoOfReplicas=2    # Number of replicas
DataMemory=180M    # How much memory to allocate for data storage
IndexMemory=80M   # How much memory to allocate for index storage
                  # For DataMemory and IndexMemory, we have used the
                  # default values. Since the "world" database takes up
                  # only about 500KB, this should be more than enough for
                  # this example Cluster setup.
# TCP/IP options:
[TCP DEFAULT]
portnumber=2202   # This the default; however, you can use any
                  # port that is free for all the hosts in cluster
                  # Note: It is recommended beginning with MySQL 5.0 that
                  # you do not specify the portnumber at all and simply allow
                  # the default value to be used instead
# Management process options:
[NDB_MGMD]
id=1
hostname=192.168.5.254           # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster  # Directory for MGM node logfiles
# Options for data node "A":
[NDBD]
                                # (one [NDBD] section per data node)
id=2
hostname=192.168.5.45           # Hostname or IP address
datadir=/usr/local/mysql/data   # Directory for this data node's datafiles
# Options for data node "B":
[NDBD]
id=3
hostname=192.168.5.30          # Hostname or IP address
datadir=/usr/local/mysql/data   # Directory for this data node's datafiles
# SQL node options:
[MYSQLD]
id=4
hostname=192.168.5.238           # Hostname or IP address
                                # (additional mysqld connections can be
                                # specified for this node for various
                                # purposes such as running ndb_restore)
［MYSQLD］［MYSQLD］
               
               
               
               
               

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u2/74118/showart_1227421.html