From: Maxime Thébault
Date: October 4 2012 8:56am
Subject: Problem with memcached
List-Archive: http://lists.mysql.com/cluster/8408
Message-Id: <506D4F2C.4030706@siteenligne.fr>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

I try to configure memcached on my mysql cluster but i have an error.

Result of ndb_mgm -e show :
ndb_mgm -e show
Connected to Management Server at: 3.3.3.3:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=3    @1.1.1.1  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)
id=4    @2.2.2.2  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 2 node(s)
id=1    @3.3.3.3  (mysql-5.5.22 ndb-7.2.6)
id=2    @4.4.4.4  (mysql-5.5.22 ndb-7.2.6)

[mysqld(API)]   14 node(s)
id=5    @2.2.2.2  (mysql-5.5.22 ndb-7.2.6)
id=6    @1.1.1.1  (mysql-5.5.22 ndb-7.2.6)
id=7 (not connected, accepting connect from any host)
id=8 (not connected, accepting connect from any host)
id=9 (not connected, accepting connect from any host)
id=10 (not connected, accepting connect from any host)
id=11 (not connected, accepting connect from any host)
id=12 (not connected, accepting connect from any host)
id=13 (not connected, accepting connect from any host)
id=14 (not connected, accepting connect from any host)
id=15 (not connected, accepting connect from any host)
id=16 (not connected, accepting connect from any host)
id=17 (not connected, accepting connect from any host)
id=18 (not connected, accepting connect from any host)

But when i execute the command from 1.1.1.1 (api node) :
memcached -E /usr/local/mysql/lib/ndb_engine.so -u mysql -e 
"connectstring=3.3.3.3:1186;role=db-only;debug=true" -vv -c 20
(3.3.3.3 is the manager)

The result is :

main --> ndb_initialize()
main --> connect_to_primary_cluster()
04-Oct-2012 10:54:42 CEST NDB Memcache 5.5.22-ndb-7.2.6 started [NDB 
7.2.6; MySQL 5.5.22]
Contacting primary management server (37.59.48.15:1186) ...
main --> ClusterConnectionPool::connect()
FAILED.
Could not connect to NDB.  Shutting down.
main --> ndb_destroy()
Failed to initialize instance. Error code: 255

I try with localhost, without connectstring...

Can you help me ?

Many thanks !