MySQL Cluster setup, receiving error "Specify node id"
0
votes
2
answers
2618
views
I am attempting to set up a MySQL Cluster.
I have the following setup:
- One management node
- Two data nodes
- One SQL node
Below is the
config.ini
file:
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=1 # Number of replicas
DataMemory=256M # How much memory to allocate for data storage
IndexMemory=128M # How much memory to allocate for index storage
#Directory for Data Node
DataDir=/var/lib/mysql-cluster
[ndb_mgmd]
# Management process options:
HostName=x.x.x.21
datadir=/var/lib/mysql-cluster
# Storage Nodes
[NDBD]
HostName=x.x.x.188
DataDir= /var/lib/mysql-cluster
[NDBD]
HostName=x.x.x.189
DataDir= /var/lib/mysql-cluster
# Setup node IDs for MySQL API-servers (clients of the cluster)
[mysqld]
# SQL node options:
hostname=x.x.x.22
Below is my.cnf
file
[mysqld]
ndbcluster # run NDB storage engine
ndb-connectstring=X.X.X.21 # location of management server
[mysql_cluster]
ndb-connectstring=X.X.X.21 # location of management server
But when I start command ndb_mgmd -f /etc/config.ini --initial
I am getting the following error:
> MySQL Cluster Management Server mysql-5.6.28 ndb-7.4.10
>
> 2018-05-09 14:29:08 [MgmtSrvr] ERROR -- Could not determine which nodeid to use for this node. Specify it with --ndb-nodeid= on command line
Can anyone please help?
Asked by subbhashree
(1 rep)
May 9, 2018, 02:47 PM
Last activity: Mar 11, 2025, 03:06 AM
Last activity: Mar 11, 2025, 03:06 AM