mysql data node not connecting to node manager on AWS EC2
1
vote
1
answer
224
views
I am trying to setup mySql manager + data node + sql server (Server A) and another data node cluster on (Server B). Both running on Ubuntu 16.04 amd_64
**Server A**
*/etc/hosts* also on Server B
Both private ip
172.xx.xx.xx ip-172-xx-xx-xx-eu-west-1.compute.internal
172.xx.xx.xx ip-172-xx-xx-xx.eu-east-1.compute.internal
*/config.ini*
[ndbd default]
NoOfReplicas=2 # Number of replicas
[ndb_mgmd]
hostname=ip-172-xx-xx-xx.eu-west-1.compute.internal show
Connected to Management Server at: 172.xx.xx.xx:1186 <- A
Cluster Configuration
---------------------
[ndbd(NDB)] 1 node(s)
id=2 (not connected, accepting connect from 172.xx.xx.xx) <- B
[ndb_mgmd(MGM)] 1 node(s)
id=1 @172.x.x.x (mysql-5.7.22 ndb-7.6.6)
[mysqld(API)] 1 node(s)
id=3 (not connected, accepting connect from 172.xx.xx.xx) <- A
Not sure how would i connect to mysqld(API) that should work fine after i installed the server/client cluster.
Also i got inbound on both Instances A & B to accept all traffic between all port ranges 1000-60000 just in case i am missing something, and outbound is open to everything.
I wonder what is it i am missing, i got so tired today trying to find out what is going on with the setup.
Any help will be appreciated !
Asked by mohamed tebry
(11 rep)
Oct 14, 2019, 06:03 PM
Last activity: Jun 6, 2025, 12:03 AM
Last activity: Jun 6, 2025, 12:03 AM