Second Management Node not connecting
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!
Subject
Views
Written By
Posted
Second Management Node not connecting
666
May 19, 2020 10:25AM
334
August 28, 2020 05:02AM
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.