Problem connecting two mysql servers to a cluster

[Warren Turner]

Hey Everybody, I'm having a problem connecting multiple mysql servers (mysqld) to a single cluster. Here is the setup:

Server 1:
Mgm Server
Data Node
mysql server

Server 2:
Data Node
mysql server


The cluster starts up fine. In my config.ini file I have two mysqld hosts:

[mysqld]
HostName=wal1qa-looker1.paytronix.com

[mysqld]
HostName=wal1qa-looker2.paytronix.com


Both servers show up in ndb_mgm:

Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.97.134 (mysql-5.7.19 ndb-7.5.7, Nodegroup: 0, *)
id=3 @192.168.97.139 (mysql-5.7.19 ndb-7.5.7, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.97.134 (mysql-5.7.19 ndb-7.5.7)

[mysqld(API)] 2 node(s)
id=4 @192.168.97.134 (mysql-5.7.19 ndb-7.5.7)
id=5 (not connected, accepting connect from wal1qa-looker2.paytronix.com)


However, which ever mysqld host I have configured in the config.ini file second (yes if I swap the order the one that can connect changes) will not connect. I see this error in the logs:

2017-10-02T15:59:43.870275Z 0 [Note] NDB Index Stat: Wait for cluster to start
2017-10-02T16:00:13.873733Z 0 [Warning] NDB : Tables not available after 30 seconds. Consider increasing --ndb-wait-setup value
2017-10-02T16:00:13.873823Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2017-10-02T16:00:13.873833Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-10-02T16:00:13.876679Z 4 [Warning] NDB: Failed to acquire global schema lock, error: (4009)Cluster Failure
2017-10-02T16:00:13.877778Z 4 [Warning] NDB: Failed to acquire global schema lock, error: (4009)Cluster Failure
2017-10-02T16:00:13.880879Z 4 [Warning] NDB: Failed to acquire global schema lock, error: (4009)Cluster Failure
2017-10-02T16:00:13.881791Z 4 [Warning] NDB: Failed to acquire global schema lock, error: (4009)Cluster Failure


Anybody have any ideas? Thanks!