这是一个创建于 3009 天前的主题,其中的信息可能已经有所发展或是发生改变。
Centos6.4 安装 Mysql Cluster5.7.4 ,启动 ndbd 报错:
Unable to connect with connect string: nodeid=0,localhost:1186
我的 mysql cluster 配置如下:
my.cnf 配置
[mysqld]
# Options for mysqld process:
ndbcluster # run NDB storage engine
ndb-connectstring=192.168.6.154
[mysql_cluster]
# Options for MySQL Cluster processes:
ndb-connectstring=192.168.6.154 # location of management server
config.ini 配置
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=1 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=18M # 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 default]
# TCP/IP options:
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in the cluster
# Note: It is recommended that you do not specify the port
# number at all and simply allow the default value to be used
# instead
[ndb_mgmd]
# Management process options:
id=1
hostname=192.168.6.154 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster/data # Directory for MGM node log files
[ndbd]
# Options for data node "B":
id=2
hostname=192.168.6.151 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files
[mysqld]
# SQL node options:
hostname=192.168.6.154 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)