SQL nodes not connected with Management node! HELP!!

[james jiang]

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