MySQL Forums :: NDB clusters :: MySQL Cluster SQL Node connection is not working


Advanced Search

MySQL Cluster SQL Node connection is not working
Posted by: Sapna Mishra ()
Date: January 17, 2017 05:38AM

Hello, I am creating all node on same server for testing but I am not able to get connected to SQL node I have tried this setup on different server still no luck. I am sharing configuration file detail below.
Management Node Output

ndb_mgm> show
Connected to Management Server at: 127.0.0.1:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 1 node(s)
id=2 @127.0.0.1 (mysql-5.7.16 ndb-7.5.4, Nodegroup: 0, *)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @127.0.0.1 (mysql-5.7.16 ndb-7.5.4)

[mysqld(API)] 1 node(s)
id=3 (not connected, accepting connect from any host)

ndb_mgm> ALL STATUS
Node 2: started (mysql-5.7.16 ndb-7.5.4)


/var/lib/mysql-cluster/config.ini

[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=1 # Number of replicas

[mysqld default]
[ndb_mgmd default]
[tcp default]

[ndb_mgmd]
# Management process options:
hostname=X.X.X.X # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node log files
nodeid=1

[ndbd]
# Options for data node "A":
nodeid=2 # (one [ndbd] section per data node)
hostname=X.X.X.X # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data file

[mysqld]
# SQL node options:
hostname=X.X.X.X # Hostname or IP address
nodeid=3 # (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)

/etc/my.cnf

# MySQL Config
[mysqld]
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
user=mysql

# Run ndb storage engine
ndbcluster
# IP address management node
ndb-connectstring=X.X.X.X

[mysql_cluster]
# IP address management node
ndb-connectstring=X.X.X.X

# MySQL Pid and Log
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Options: ReplyQuote


Subject Views Written By Posted
MySQL Cluster SQL Node connection is not working 324 Sapna Mishra 01/17/2017 05:38AM
Re: MySQL Cluster SQL Node connection is not working 145 Mikael Ronström 01/17/2017 02:36PM


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.