8 messages in com.mysql.lists.clusterRe: Installation Instructions Problem
FromSent OnAttachments
phil...@bt.com05 Apr 2005 08:49 
Jonas Oreland06 Apr 2005 05:00 
Vasiliy Boulytchev12 Mar 2007 14:32 
Jon Stephens12 Mar 2007 17:48 
Serge Kozlov13 Mar 2007 06:37 
Vasiliy Boulytchev15 Mar 2007 07:47 
Vasiliy Boulytchev22 Mar 2007 08:07 
Jonathan Miller24 Mar 2007 07:32 
Subject:Re: Installation Instructions Problem
From:Serge Kozlov (skoz@mysql.com)
Date:03/13/2007 06:37:05 AM
List:com.mysql.lists.cluster

Jon Stephens wrote:

Vasiliy Boulytchev wrote:

Ladies and Gents,

After following the directions at : http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-multi-install.html, I am running into some difficulties in the last step.

The startup procedures :). I understand the startup sequence. First the mgm node, then the data nodes, then the sql node.

1.) So after firing up the management node via "**|ndb_mgmd -f /var/lib/mysql-cluster/config.ini"|**, I procede on to the data guys. I presume, thats the only command that needs to be given on the mgm host.

Correct.

This step seems to start OK.

2.) I give /usr/local/mysql/bin/*|ndbd --initial|* on both ndbd1 and ndbd2 hosts I dont need to start anything else, do I?

No, you don't.

This steps seems to work fine as well.

3.) The problems start on the mysql host. What command do I initiate on the sql host? I dont seem to be able to find precise instructions in the docs (maybe I need to reload on coffee)... ndb_mgm> show Cluster Configuration

--------------------- [ndbd(NDB)] 2 node(s) id=2 @172.30.35.75 (Version: 5.1.16, Nodegroup: 0, Master) id=3 @172.30.35.76 (Version: 5.1.16, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s) id=1 @172.30.35.71 (Version: 5.1.16)

[mysqld(API)] 1 node(s) id=4 (not connected, accepting connect from mysql1)

Start mysqld with the --ndbcluster and --ndb-connectstring options.

For example:

./mysqld_safe --ndbcluster --ndb-connectstring=172.30.35.71 &

or

./mysqld_safe --ndbcluster --ndb-connectstring=nodeid=4,172.30.35.71 &

(I think either of these should work for your setup.)

For more info about these options and about the cluster connectstring, see

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-mysqld-command-options.html

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-connectstring.html

OR:

You can also put these options into the MySQL Server's my.cnf file. See

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-config-example.html

HTH!

Also make sure that you have at least one line in your config.ini:

[mysqld]

Or:

[mysqld] id=4 hostname=172.30.35.XX

where 172.30.35.XX - ip address of machine with mysqld server (or hostname)

jon.

---------------------

Thank you all for your kind attention,

Best Regards,

Vasiliy Boulytchev vasi@linuxspecial.com

-- Serge Kozlov, QA Developer MySQL AB, Moscow, Russia, www.mysql.com Office:

Are you MySQL certified? www.mysql.com/certification