Skip navigation links

MySQL Forums :: Cluster :: Unable to connect SQL node to a MySQL cluster


Advanced Search

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
Unable to connect SQL node to a MySQL cluster 8486 Cyril CLARISSE 12/11/2009 07:38AM
Re: Unable to connect SQL node to a MySQL cluster 4673 Matthew Montgomery 12/11/2009 11:31AM
Re: Unable to connect SQL node to a MySQL cluster 5505 Cyril CLARISSE 12/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.