RE: How to configure mysql cluster properly - Burnett, Stewart - com.mysql.lists.cluster

12 messages in com.mysql.lists.clusterRE: How to configure mysql cluster pr...

From	Sent On	Attachments
Brian L	09 Nov 2004 22:27
Burnett, Stewart	10 Nov 2004 03:29
Brian L	10 Nov 2004 16:56
Chad Martin	10 Nov 2004 22:15
Brian L	10 Nov 2004 23:46
Burnett, Stewart	10 Nov 2004 23:48
Olivier Kaloudoff	11 Nov 2004 00:49
Brian L	11 Nov 2004 02:00
Brian L	11 Nov 2004 02:03
Martin Holzhauer	15 Nov 2004 04:40
Martin Holzhauer	15 Nov 2004 06:31
Tomas Ulin	16 Nov 2004 03:33

Subject:	RE: How to configure mysql cluster properly
From:	Burnett, Stewart (stew...@capgemini.com)
Date:	11/10/2004 11:48:53 PM
List:	com.mysql.lists.cluster

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

-----Original Message----- From: Brian L [mailto:tige...@yahoo.com] Sent: 11 November 2004 00:57 To: Burnett, Stewart; clus...@lists.mysql.com 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" <stew...@capgemini.com> 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

-----Original Message----- From: Brian L [mailto:tige...@yahoo.com] Sent: 10 November 2004 06:27 To: clus...@lists.mysql.com 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=stew...@capgemini.co.uk

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: