MySQL Forums
Forum List  »  NDB clusters

Application nodes does not join cluster
Posted by: Kai Koppelmann
Date: June 03, 2015 05:24AM

Hello,

i am facing an issue processing my cluster start:

My Configuration (which node is located on which System):
A4TMQL103: id 1 & 3
A4TMQL104: id 2 & 4
A4TMQL105: id 5
A4TMQL106: id 6

My my.ini on A4TMQL103/104:

[mysqld]
# Options for mysqld process:
innodb=OFF
ndbcluster=ON
default-storage-engine=ndbcluster
default-tmp-storage-engine=ndbcluster
ndb-connectstring=A4TMQL103.A41MGT.LOCAL,A4TMQL104.A41MGT.LOCAL
basedir=F:\mysql
log-error=F:\Error.log
log-warnings
ndb-nodeid=3
general-log=true

My config.ini on A4TMQL103/104:

[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataDir=h:/cluster-data # Directory for each data node's data files
# Forward slashes used in directory path,
# rather than backslashes. This is correct;
# see Important note in text
DataMemory=80M # Memory allocated to data storage
IndexMemory=18M # Memory allocated to index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.

[ndb_mgmd]
# Management process options:
NodeId=1
HostName=A4TMQL103.A41MGT.LOCAL
DataDir=s:/cluster-logs
[ndb_mgmd]
# Management process options:
NodeId=2
HostName=A4TMQL104.A41MGT.LOCAL
DataDir=s:/cluster-logs

[ndbd]
# Options for data node "A":
NodeId=5
HostName=A4TMQL105.A41MGT.LOCAL
[ndbd]
NodeId=6
# Options for data node "B":
HostName=A4TMQL106.A41MGT.LOCAL

[mysqld]
# SQL node options:
NodeId=3
HostName=A4TMQL103.A41MGT.LOCAL
[mysqld]
# SQL node options:
NodeId=4
HostName=A4TMQL104.A41MGT.LOCAL



My recent cluster state:

[ndbd(NDB)] 2 node(s)
id=5 @10.251.82.81 (mysql-5.6.24 ndb-7.4.6, Nodegroup: 0, *)
id=6 @10.251.82.78 (mysql-5.6.24 ndb-7.4.6, Nodegroup: 0, *)

[ndb_mgmd(MGM)] 2 node(s)
id=1 @10.251.82.79 (mysql-5.6.24 ndb-7.4.6)
id=2 @10.251.82.80 (mysql-5.6.24 ndb-7.4.6)

[mysqld(API)] 2 node(s)
id=3 (not connected, accepting connect from A4TMQL103.A41MGT.LOCAL)
id=4 (not connected, accepting connect from A4TMQL104.A41MGT.LOCAL)


At this Point, all Looks fine.

Now i got problems starting my application nodes (mysqld).
Even the process is running, the state via ndb_mgm does not Change.
It seems, the application node never speaks to the Management nodes, even it is on the same System.


MySQLD Log result:

2015-06-03 13:17:10 2324 [Note] Plugin 'FEDERATED' is disabled.
2015-06-03 13:17:10 2324 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2015-06-03 13:17:10 2324 [Note] Plugin 'InnoDB' is disabled.
2015-06-03 13:17:10 2324 [Note] NDB: Changed global value of binlog_format from STATEMENT to MIXED
2015-06-03 13:17:10 2324 [Note] NDB: NodeID is 3, management server 'A4TMQL103.A41MGT.LOCAL:1186'
2015-06-03 13:17:41 2324 [Note] NDB[0]: NodeID: 3, no storage nodes connected (timed out)
2015-06-03 13:17:41 2324 [Warning] NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds
2015-06-03 13:17:41 2324 [Note] NDB Binlog: Starting...
2015-06-03 13:17:41 2324 [Note] NDB Util: Starting...
2015-06-03 13:17:41 2324 [Note] NDB Index Stat: Starting...
2015-06-03 13:17:41 2324 [Note] NDB Binlog: Started
2015-06-03 13:17:41 2324 [Note] NDB Index Stat: Wait for server start completed
2015-06-03 13:17:41 2324 [Note] NDB Binlog: Setting up
2015-06-03 13:17:41 2324 [Note] NDB Util: Wait for server start completed
2015-06-03 13:17:41 2324 [Note] NDB Binlog: Created schema Ndb object, reference: 0x80040003, name: 'Ndb Binlog schema change monitoring'
2015-06-03 13:17:41 2324 [Note] Server hostname (bind-address): '*'; port: 3306
2015-06-03 13:17:41 2324 [Note] NDB Binlog: Created injector Ndb object, reference: 0x80050003, name: 'Ndb Binlog data change monitoring'
2015-06-03 13:17:41 2324 [Note] IPv6 is available.
2015-06-03 13:17:41 2324 [Note] NDB Binlog: Setup completed
2015-06-03 13:17:41 2324 [Note] - '::' resolves to '::';
2015-06-03 13:17:41 2324 [Note] NDB Binlog: Wait for server start completed
2015-06-03 13:17:41 2324 [Note] Server socket created on IP: '::'.
2015-06-03 13:17:41 2324 [Note] Event Scheduler: Loaded 0 events
2015-06-03 13:17:41 2324 [Note] mysqld: ready for connections.
Version: '5.6.24-ndb-7.4.6-cluster-gpl-log' socket: '' port: 3306 MySQL Cluster Community Server (GPL)
2015-06-03 13:17:41 2324 [Note] NDB Index Stat: Wait for cluster to start
2015-06-03 13:17:41 2324 [Note] NDB Binlog: Check for incidents
2015-06-03 13:17:41 2324 [Note] NDB Util: Wait for cluster to start
2015-06-03 13:17:41 2324 [Note] ndb_index_stat_proc: Created Ndb object, reference: 0x80060003, name: 'Ndb Index Statistics monitoring'
2015-06-03 13:17:41 2324 [Note] NDB Binlog: Wait for cluster to start
2015-06-03 13:17:41 2324 [Note] NDB Util: Started
2015-06-03 13:17:41 2324 [Note] NDB Index Stat: Started
2015-06-03 13:18:11 2324 [Warning] NDB : Tables not available after 30 seconds. Consider increasing --ndb-wait-setup value


result from cluster log:

2015-06-03 13:17:10 [MgmtSrvr] INFO -- Nodeid 3 allocated for API at 9.251.82.79
2015-06-03 13:17:10 [MgmtSrvr] INFO -- Node 3: mysqld --server-id=0

Content ob ndb_1_out.log (does not looking very helpful):

==INITIAL==
==INITIAL==
==CONFIRMED==
==CONFIRMED==
Failed to flush buffer to socket, errno: 34
==INITIAL==
==CONFIRMED==
==INITIAL==
==CONFIRMED==
==CONFIRMED==
Failed to flush buffer to socket, errno: 34
==CONFIRMED==
==CONFIRMED==




Annoying: why does node 3 (application node 1) allocates ip 9.251.82.79?
all other machines are located at the 10.x.x.x subnet.

May this cause some Trouble? I tried binding the Adapter to the 10.x.x.x-address of the machine - successfully, but it does not connect to the cluster anyway.

And what does this log entry mean:

2015-06-03 13:17:41 2324 [Warning] NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds




All machines are in the same vlan, all Firewalls are turned off and my user is owning the Domain admin role.

Realy Need some Input solving that... .

Best regards,
Kai

Options: ReplyQuote


Subject
Views
Written By
Posted
Application nodes does not join cluster
3880
June 03, 2015 05:24AM


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.