Skip to Main Content
Forums

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

MySQL Clustering

Raghav_DBAMay 13 2018 — edited May 16 2018

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

Comments

Post Details

Added on May 13 2018
#mysql, #mysql-user-groups
2 comments
527 views