From: Stewart Burnett Date: November 11 2004 7:49am Subject: RE: How to configure mysql cluster properly List-Archive: http://lists.mysql.com/cluster/1091 Message-Id: <9D1A50FA0C36D311BED80008C75F6886079D5943@exsal01.capgemini.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Brian, Ndb.cfg (note case) needs to be set up in; ndbd start dir mysql data dir Contents: host=3D10.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" wrote: >=0D > Hi, >=0D > Looks like MySQL has not connected to NDBD. >=0D > Try using ndb_mgm utility and use SHOW command. This > will tell you is every > thing is connected properly e.g. >=0D > NDB> show > Cluster Configuration > --------------------- > [ndbd(NDB)] 2 node(s) > id=3D3 @127.0.0.1 (Version: 3.5.3, Nodegroup: 0, > Master) > id=3D4 (not connected, accepting connect from > 10.99.99.111) >=0D > [ndb_mgmd(MGM)] 1 node(s) > id=3D1 @10.99.99.35 (Version: 3.5.3) >=0D > [mysqld(API)] 2 node(s) > id=3D5 @127.0.0.1 (Version: 3.5.3) > id=3D6 @10.99.99.111 (Version: 3.5.3) >=0D > Note in this example id=3D4 is not connected - one of > the NDB nodes. In your > case it sounds like the API node(s) have not > connected. >=0D > Have you set up Ndb.cfg files correctly? >=0D > Also need to start processes in order; >=0D > ndm_mgmd on management server > ndbd on each server (using --initial option the > first time) > mysqld on each server >=0D >=0D >=0D > SB >=0D > -----Original Message----- > From: Brian L [mailto:tiger1763@stripped] > Sent: 10 November 2004 06:27 > To: cluster@stripped > Subject: How to configure mysql cluster properly >=0D >=0D > Hi there, >=0D > 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. >=0D > The following is my config.ini > [NDBD DEFAULT] > NoOfReplicas: 2 >=0D > [MYSQLD DEFAULT] > [NDB_MGMD DEFAULT] > [TCP DEAFULT] >=0D > [NDB_MGMD] > HostName =3D 10.117.29.120 >=0D > [NDBD] > HostName =3D 10.117.29.120 > DataDir: /var/local/mysql-cluster >=0D > [NDBD] > HostName =3D 10.117.29.121 > DataDir: /var/local/mysql-cluster >=0D > [MYSQLD] > [MYSQLD] > [MYSQLD] >=0D >=0D > 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). >=0D > Please advice if anyone encountered similar > incidents. >=0D >=0D > Thanks so much >=0D >=0D > =0D > __________________________________ > Do you Yahoo!? > Check out the new Yahoo! Front Page. > www.yahoo.com >=0D >=0D >=0D > -- > MySQL Cluster Mailing List > For list archives: http://lists.mysql.com/cluster > To unsubscribe: > http://lists.mysql.com/cluster?unsub=3Dstewart.burnett@stripped >=0D >=0D > 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. >=0D >=0D > -- > MySQL Cluster Mailing List > For list archives: http://lists.mysql.com/cluster > To unsubscribe: =0D > http://lists.mysql.com/cluster?unsub=3Dtiger1763@stripped >=0D >=0D =0D __________________________________=0D Do you Yahoo!?=0D Check out the new Yahoo! Front Page.=0D www.yahoo.com=0D =0D 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.