Re: Unable to connect SQL node to a MySQL cluster
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
Subject
Views
Written By
Posted
16317
December 11, 2009 07:38AM
7377
December 11, 2009 11:31AM
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.