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 !