Hi,
Looks like MySQL has not connected to NDBD.
Try using ndb_mgm utility and use SHOW command. This will tell you is every
thing is connected properly e.g.
NDB> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=3 @127.0.0.1 (Version: 3.5.3, Nodegroup: 0, Master)
id=4 (not connected, accepting connect from 10.99.99.111)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.99.99.35 (Version: 3.5.3)
[mysqld(API)] 2 node(s)
id=5 @127.0.0.1 (Version: 3.5.3)
id=6 @10.99.99.111 (Version: 3.5.3)
Note in this example id=4 is not connected - one of the NDB nodes. In your
case it sounds like the API node(s) have not connected.
Have you set up Ndb.cfg files correctly?
Also need to start processes in order;
ndm_mgmd on management server
ndbd on each server (using --initial option the first time)
mysqld on each server
SB
-----Original Message-----
From: Brian L [mailto:tiger1763@stripped]
Sent: 10 November 2004 06:27
To: cluster@stripped
Subject: How to configure mysql cluster properly
Hi there,
I was attempting to set up to run the mysql cluster
among two machines, so that when one machine down and
the other can be up right away. Both of the machine is
successfully running the mysqld daemon. And I set up
one machine as the management server. It ran the ndbd
and ndb_mgmd daemon. And the other just ran the ndbd.
The following is my config.ini
[NDBD DEFAULT]
NoOfReplicas: 2
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEAFULT]
[NDB_MGMD]
HostName = 10.117.29.120
[NDBD]
HostName = 10.117.29.120
DataDir: /var/local/mysql-cluster
[NDBD]
HostName = 10.117.29.121
DataDir: /var/local/mysql-cluster
[MYSQLD]
[MYSQLD]
[MYSQLD]
However, when I attempted to test and create table on
one machine (e.g. 10.117.29.120), I got the error
message Error: Can't create table './test/ctest.frm'
(errno:4009).
Please advice if anyone encountered similar incidents.
Thanks so much
__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
--
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com/cluster
To unsubscribe:
http://lists.mysql.com/cluster?unsub=1
This message contains information that may be privileged or confidential and is the
property of the Capgemini Group. It is intended only for the person to whom it is
addressed. If you are not the intended recipient, you are not authorized to read, print,
retain, copy, disseminate, distribute, or use this message or any part thereof. If you
receive this message in error, please notify the sender immediately and delete all
copies of this message.
