Re: MySQL client not connecting to management server?

On Thu, 2007-09-27 at 07:08 -0700, Jake Conk wrote:
> I only have 1 data node at the moment and I'm working on building
> another one but for the one that I do have ndbd was fully connected
> before I tried to connect the NDB APE client. All I need is ndbcluster
> and ndb-connectstring=XX in my my.cnf right?

Based on the attached output of 'SHOW', your config.ini has two [NDBD] blocks defined which dictates that two datanodes constitutes a full cluster. For a "initial system start" all defined NDBD nodes must be present. For a "system start", NDBD requires that at least one member from each node group is started before the cluster as a whole may start.

You haven't stated what your NoOfReplicas value is. This is fairly important for understanding how start up is handled. If NoOfReplicas = 1 you have one node per node group. This setting makes it such that all nodes must be present for a "system start". If NoOfReplicas = 2 then the cluster will wait for at least one node from each node group and StartPartialTimeout and StartPartitionedTimeout to expire before attempting to do a "system start".

Defaults for these are:
StartPartialTimeout = 30000 milliseconds StartPartitionedTimeout = 60000 milliseconds

Regarding NDB API connections, the ndb-connectstring directs the application to where the management node is located. The management node then notifies the API node when the cluster is started and which data nodes are members of the cluster. The API node then connects to the data nodes using various randomly assigned ports.

> Are there any other methods of debugging since this isn't giving me
> any errors or any clues to help troubleshoot my problem of none of my
> ndb clients are able to connect?
>

Within the Datadir for ndb_mgmd on 192.168.20.1 will be a ndb_1_cluster.log file this should show you messages from the starting node "id=2 @192.168.20.30" as to why it is delaying start up. Likely it is because this node is waiting for its peer.

> Thanks,
> > >>> [ndbd(NDB)] 2 node(s)
> > >>> id=2 @192.168.20.30 (Version: 5.0.45, starting, Nodegroup:0)
> > >>> id=3 (not connected, accepting connect from 192.168.20.40)

-- 
Matthew Montgomery, Support Engineer
San Antonio, TX
MySQL Inc, www.mysql.com


-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek