Forum Stats

  • 3,839,647 Users
  • 2,262,519 Discussions
  • 7,901,032 Comments

Discussions

MySQL Clustering

Raghav_DBA
Raghav_DBA Member Posts: 96 Red Ribbon
edited May 16, 2018 2:36AM in MySQL Community Space

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