MySQL Forums
Forum List  »  NDB clusters

data going to sqlnode datadir in NDB config
Posted by: praneeth papishetty
Date: November 01, 2018 06:20PM

Hi,

I installed a NDB cluster on linux using tarball and I am able to successfully start all 4 nodes. below is the status. But when I create databases from sqlnode, they are going in to sqlnode's local datadir. they are not going in to ndb nodes. Can someone please help me. below are my cnf contents .

NOTE: I am using a custom directory structure and I used below command to bring the sqlnode up

./bin/mysqld --defaults-file=/sites/app/servers/sqlnode/etc/my.cnf --initialize-insecure --datadir=/sites/app/servers/sqlnode/data/ --basedir=/sites/app/APPS/mysql

./bin/mysqld --defaults-file=/sites/app/servers/sqlnode/etc/my.cnf --basedir=/sites/app/APPS/mysql/ --datadir=/sites/app/servers/sqlnode/data/ &


ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @xxx.xxx.xxx.xx (mysql-5.7.24 ndb-7.5.12, Nodegroup: 0, *)
id=3 @xxx.xxx.xxx.xx (mysql-5.7.24 ndb-7.5.12, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @xxx.xxx.xxx.xx (mysql-5.7.24 ndb-7.5.12)

[mysqld(API)] 1 node(s)
id=4 @xxx.xxx.xxx.xx (mysql-5.7.24 ndb-7.5.12)


sqlnode:
[mysqld]
ndbcluster
lc-messages-dir=/sites/app/APP/mysql/share/
lc-messages=en_US
[mysql_cluster]
ndb-connectstring=XXX.XXX.XXX.XX

ndb data nodes:
[mysqld]
ndbcluster
[mysql_cluster]
ndb-connectstring=XXX.XXX.XXX.XX

management node:
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2
DataMemory=200M
IndexMemory=50M
ServerPort=2202

[ndb_mgmd]
# Management process options:
HostName=XXX.XXX.XXX.XX
DataDir=/sites/app/servers/mgnd/data

[ndbd]
# Options for data node "A":
HostName=XXX.XXX.XXX.XX
NodeId=2
DataDir=/sites/app/servers/datanode1/data/

[ndbd]
# Options for data node "B":
HostName=XXX.XXX.XXX.XX
NodeId=3
DataDir=/sites/app/servers/datanode2/data/

[mysqld]
# SQL node options:
HostName=XXX.XXX.XXX.XX

Options: ReplyQuote


Subject
Views
Written By
Posted
data going to sqlnode datadir in NDB config
987
November 01, 2018 06:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.