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
[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 ?
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
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.