Brian,
Ndb.cfg (note case) needs to be set up in;
ndbd start dir
mysql data dir
Contents:
host=10.0.0.10:2200
Where these refer to the host and port for the ndb_mgmd
There are also command line options as an alternative when starting ndbd &
mysqld
Some links which give more details;
http://dev.mysql.com/doc/mysql/en/mysqld_process.html
http://dev.mysql.com/doc/mysql/en/ndbd_process.html
SB
-----Original Message-----
From: Brian L [mailto:tiger1763@stripped]
Sent: 11 November 2004 00:57
To: Burnett, Stewart; cluster@stripped
Subject: RE: How to configure mysql cluster properly
Hi,
Thanks so much. I think I didnt set up the NDB.cfg
properly. Do you know where I can find the information
how to set up the NDB.cfg ?
And I think I also start up the process in the
different order. So it means that I have to start the
ndb_mgmd first, then the ndbd.. then the mysqld,
right.
Regards
Brian
--- "Burnett, Stewart" <stewart.burnett@stripped>
wrote:
>
> 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.
>
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:
>
http://lists.mysql.com/cluster?unsub=1
>
>
__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
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.
