MySQL Forums
Forum List  »  NDB clusters

SQL nodes not connected with Management node! HELP!!
Posted by: james jiang
Date: January 18, 2020 01:49AM

Sql Nodes can't connect to management node. Is something wrong here ? Please correct me! Many thanks!!!!


I've downloaded the latest version Mysql NDB cluster bundle file (mysql-cluster-community-8.0.19-1.el8.x86_64.rpm-bundle.tar). I'm using CentOS 8.

I followed the manual and other articles searched by Google:
1. Installed Management Node (192.168.11.113)
- installed mysql-cluster-community-management-server-8.0.19-1.el8.x86_64.rpm
- installed mysql-cluster-community-client-8.0.19-1.el8.x86_64.rpm
- mkdir -p /var/lib/mysql-cluster
cd /var/lib/mysql-cluster
vi config.ini
##################################
# Default settings
[ndbd default]
NoOfReplicas=2

# Management node
[ndb_mgmd]
hostname=192.168.11.113
datadir=/var/lib/mysql-cluster

# 1st data node
[ndbd]
hostname=192.168.11.115
NodeId=2
datadir=/usr/local/mysql/data

# 2nd data node
[ndbd]
hostname=192.168.11.114
NodeId=3
datadir=/usr/local/mysql/data

# SQL node
[mysqld]
hostname=192.168.11.116
######################################

Then used ndb_mgmd load the config file. and used ndb_mgm , show...

2. Installed Data Node 1, everything was going well, and successfully connected with management node.

3. but after installed Sql node 1:
- mysql-cluster-community-server-8.0.19-1.el8.x86_64.rpm
- mysql-cluster-community-client-8.0.19-1.el8.x86_64.rpm
somehow it requires perl(Class::MethodMaker) andy python2??? But they were installed from epel-release..

And I modified /etc/my.cnf

[mysqld]
ndbcluster

[mysql_cluster]
ndb-connectstring=192.168.11.113 # IP address for server management node

and then use the command to start mysql

systemctl start mysqld

But in management node, use show command, it shows:

[mysqlid(API)] 1 node(s)
id=4 (not connected, accepting connect from 192.168.11.116).

Tried many times, still CAN NOT make it connect to management node.

I even tried: 1. disabled SELINUX, 2. disabled FirewallD. Still not working.

Any help is appreciated!!!!


Thanks!

James

Options: ReplyQuote


Subject
Views
Written By
Posted
SQL nodes not connected with Management node! HELP!!
205
January 18, 2020 01:49AM


Sorry, only registered users may post in this forum.

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.