MySQL Forums
Forum List  »  NDB clusters

Second Management Node not connecting
Posted by: Joppe van Loo
Date: May 19, 2020 10:25AM

So this is the idea of the MySQL cluster:

192.168.0.82 = Management Node 1+ SQL Node 2

192.168.0.85 = Management Node 2 + SQL Node 2

192.168.0.83 = Data Node 1

192.168.0.84 = Data Node 2

The config.ini on 192.168.0.82 looks like this:

[ndb_mgmd default]
DataDir=/var/lib/mysql-cluster
[ndbd default]
NoOfReplicas=2
DataMemory=2048M
IndexMemory=512M
MaxNoOfOrderedIndexes=200
MaxNoOfUniqueIndexes=200
[ndb_mgmd]
HostName=192.168.0.82
NodeId=1
[ndb_mgmd]
HostName=192.168.0.85
NodeId=2
[ndbd]
HostName=192.168.0.83
NodeId=3
DataDir=/usr/local/mysql/data
[ndbd]
HostName=192.168.0.84
NodeId=4
DataDir=/usr/local/mysql/data
[mysqld]
HostName=192.168.0.82
NodeId=5
[mysqld]
HostName=192.168.0.85
NodeId=6

The config.ini on 192.168.0.82 looks like:

[ndb_mgmd default]
DataDir=/var/lib/mysql-cluster
[ndbd default]
NoOfReplicas=2
DataMemory=2048M
MaxNoOfUniqueIndexes=200
MaxNoOfOrderedIndexes=200
[ndb_mgmd]
HostName=192.168.0.82
NodeId=1
[ndb_mgmd]
HostName=192.168.0.85
NodeId=2
[ndbd]
HostName=192.168.0.83
NodeId=3
DataDir=/usr/local/mysql/data
[ndbd]
HostName=192.168.0.84
NodeId=4
DataDir=/usr/local/mysql/data
[mysqld]
HostName=192.168.0.85
NodeId=6
[mysqld]
HostName=192.168.0.82
NodeId=5

The my.cnf file on all nodes looks like this (excluding commentary):

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/ [mysqld]
ndbcluster
default-storage-engine=ndbcluster
ndb-connectstring=192.168.0.82,192.168.0.85
[mysql_cluster]
ndb-connectstring=192.168.0.82,192.168.0.85

Problem being that 192.168.0.85 won't connect (it shows this on both 192.168.0.85 and 192.168.0.82):

ndb_mgm> show
Connected to Management Server at: 192.168.0.82:1186
Cluster Configuration ---------------------
[ndbd(NDB)] 2 node(s)
id=3 @192.168.0.83 (mysql-8.0.19 ndb-8.0.19, Nodegroup: 0)
id=4 @192.168.0.84 (mysql-8.0.19 ndb-8.0.19, Nodegroup: 0, *)
[ndb_mgmd(MGM)] 2 node(s)
id=1 @192.168.0.82 (mysql-8.0.19 ndb-8.0.19)
id=2 (not connected, accepting connect from 192.168.0.85)
[mysqld(API)] 2 node(s)
id=5 @192.168.0.82 (mysql-8.0.19 ndb-8.0.19)
id=6 @192.168.0.85 (mysql-8.0.19 ndb-8.0.19)

I tried so many combinations of configuring them differently, nothing seems to work. Does anybody have an idea of what I am doing wrong? They all run on Ubuntu 18.04 LTS.

Thanks in advance!

Options: ReplyQuote


Subject
Views
Written By
Posted
Second Management Node not connecting
38
May 19, 2020 10:25AM


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.