7 messages in com.mysql.lists.clusterRE: NDBCLUSTER - no ndb commands work
FromSent OnAttachments
Alex Davies23 Feb 2005 04:40 
phil...@bt.com23 Feb 2005 08:53 
Alex Davies23 Feb 2005 10:55 
phil...@bt.com24 Feb 2005 02:18 
phil...@bt.com18 Mar 2005 06:43 
Stewart Smith20 Mar 2005 15:52 
Johan Andersson29 Mar 2005 04:51 
Subject:RE: NDBCLUSTER - no ndb commands work
From:phil...@bt.com (phil@bt.com)
Date:02/23/2005 08:53:32 AM
List:com.mysql.lists.cluster

Sorry Alex, It works. I can run all NDB commands

I should have waited a bit longer for the cluster to complete startup.

Another question though, is it possible to make a backup automatically apart from doing it manually from the management server ?

Also, I tried to start a DB node from the Management server and it fails.

ndb_mgm> 2 start Start failed. * 22: Error * No contact with the process (dead ?).

Do you have any idea why.

Thanks.

Philong

-----Original Message----- From: Alex Davies [mailto:davi@gmail.com] Sent: Wednesday, February 23, 2005 1:40 PM To: Nguyen,P,Philong,IMA32 C; clus@lists.mysql.com Subject: Re: NDBCLUSTER - no ndb commands work

Please reply to the list as well as me!

Can you post the ouput of show; on the managment server before and during the attempted start of your other ndb commands? I have to say I am a little confused - the only other references for your problem seem to be fixed by adding more API sections. Thanks,

Alex

On Wed, 23 Feb 2005 12:35:17 -0000, phil@bt.com <phil@bt.com> wrote:

Hi,

I've added few more [MYSQLD] and restarted the cluster. (see below my config.ini file)

[NDBD DEFAULT] NoOfReplicas= 2 DataDir= /usr/local/mysql/var DataMemory= 900M IndexMemory= 300M MaxNoOfConcurrentTransactions= 10000 MaxNoOfConcurrentOperations= 25000 MaxNoOfOrderedIndexes=100 MaxNoOfUniqueHashIndexes=10000 MaxNoOfTables=200 MaxNoOfAttributes=1500

LogLevelError=15 LogLevelConnection=15 LogLevelStartup=15 LogLevelNodeRestart=15 LogLevelInfo=15

[NDB_MGMD] HostName= 147.151.69.13 PortNumber=1186 DataDir= /usr/local/mysql/var LogDestination=FILE:filename=cluster.log,maxsize=10000000,maxfiles=3

[NDBD] HostName= 147.151.69.1

[NDBD] HostName= 147.151.69.2

[MYSQLD] HostName= 147.151.69.1

[MYSQLD] HostName= 147.151.69.2

[MYSQLD] [MYSQLD] [MYSQLD]

Running this command on one of the node gives following error.

$ndb_show_tables waitUntilReady - 4009: Cluster Failure

NDBT_ProgramExit: 1 - Failed

What am I doing wrong here ?

Thanks for your help

Philong

-----Original Message----- From: Alex Davies [mailto:davi@gmail.com] Sent: Saturday, February 19, 2005 7:26 PM To: Nguyen,P,Philong,IMA32 C Subject: Re: NDBCLUSTER - no ndb commands work

Hi,

You need to add more [API] sections to the bottom of your config.ini on your managmentserver, then restart the cluster.

With best wishes,

Alex

I\\\\\\'ve a setup of MySQL Cluster 4.1.8 on 3 computers as follows: C1 with MGM C2 with DB1 & API1 C3 with DB2 & API2

From C1, I tried to run following commands: ndb_show_tables, ndb_select_all, ..

and none of them works

I\\\\\\'ve got error like \\\\\"Configuration error: Could not alloc

node id at 147.151.69.5 port 1186: No free node id found for mysqld(API)\\\\\"

Can you help me out please. Thanks.

Philong

-- Alex Davies // http://www.davz.net

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender immediately by e-mail and delete this e-mail permanently.