MySQL Forums
Forum List  »  NDB clusters

Re: Unable to connect SQL node to a MySQL cluster
Posted by: Cyril CLARISSE
Date: December 11, 2009 11:52AM

I confirm there is no FW between (and on) the different hosts.

I made another test which confirm this point. I used the following command line to launch mysql :

/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --user=mysql --ndbcluster --ndb-connectstring=172.16.10.12:1186&

And it works !

#ndb_mgm -e show
Connected to Management Server at: 172.16.10.12:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @172.16.10.20 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0, Master)
id=3 @172.16.10.21 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @172.16.10.12 (mysql-5.1.39 ndb-7.0.9)

[mysqld(API)] 2 node(s)
id=4 @172.16.10.13 (mysql-5.1.39 ndb-7.0.9)

So the issue come from the fact that mysqld do not read (or understood ?) the content of the /etc/my.cnf. But what's wrong with it ?

[mysqld]
ndbcluster
server-id=4
ndb-nodeid=4
ndb-connectstring=172.16.10.12

[mysql_cluster]
ndb-connectstring=172.16.10.12

Effectively, if I start mysqld with "service start mysql", the command-line displayed in the process list is :

/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/srcxd04.cpa-sante.priv.pid

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Unable to connect SQL node to a MySQL cluster
9767
December 11, 2009 11:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.