Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 394 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
MySQL Clustering

Hi ,
I am MYSQL clustering first time.
Using 1 server for data and manager, 2 server for SQL. Below config file.
cat config.ini
[ndb_mgmd]
# Management process options:
hostname=mysqlmanager.example.com # Hostname of the manager
datadir=/var/lib/mysql_cluster # Directory for the log files
[ndbd]
#datanode 1
hostname=mysqlmanager.example.com # Hostname of the first data node
datadir=/usr/local/mysql/data # Remote directory for the data files
[mysqld]
# SQL node 1
hostname=mysqlnode1.example.com
[mysqld]
# SQL node 2
hostname=mysqlnode2.example.com
while running command
ndb_mgmd --config-file=/var/lib/mysql_cluster/config.ini
MySQL Cluster Management Server mysql-5.6.40 ndb-7.4.20
2018-05-13 11:58:28 [MgmtSrvr] ERROR -- at line 17: Nodegroup 0 has 1 members, NoOfReplicas=2
2018-05-13 11:58:28 [MgmtSrvr] ERROR -- Could not load configuration from '/var/lib/mysql_cluster/config.ini'
2018-05-13 11:58:28 [MgmtSrvr] ERROR -- Could not determine which nodeid to use for this node. Specify it with --ndb-nodeid=<nodeid> on command line
--ndb-nodeid=1
bash: --ndb-nodeid=1: command not found
Answers
-
Need more information
-
You can't only execute --ndb-nodeid, the Command to specifiy the Node ID should look like this:
ndbd --ndb-nodeid=2 --nowait-nodes=3 --initial-start
You can look at this documentations to find more informations about configuring the ndb cluster:
https://docs.oracle.com/cd/E17952_01/mysql-5.6-en/mysql-cluster-programs-ndbd.html
https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster.html
https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-options-variables.html
Greetings Daniel