Skip navigation links

MySQL Forums :: memcached :: memcached error Could not connect to NDB


Advanced Search

Re: memcached error Could not connect to NDB
Posted by: deepak m ()
Date: March 26, 2012 01:03AM

hi everyone

finally i resolved this problem, now memcached service is running properly

actually i got 2 points from that

1)While working with memcached with NoSQL access then there should not be any mysqld process running on that host

2)To start Memcached service we should add 2 extra API nodes for each existing API node and after adding node perform ROLLING RESTART

like i have 3 API nodes in that 2 API node with mysqld process and the other unstarted

[mysqld(API)] 3 node(s)
id=4 @10.10.221.157 (mysql-5.5.19 ndb-7.2.4)
id=5 (not connected, accepting connect from 10.10.223.174)
id=6 @10.10.221.254 (mysql-5.5.19 ndb-7.2.4)

now add 2 node each for each api
now status become

[mysqld(API)] 9 node(s)
id=4 @10.10.221.157 (mysql-5.5.19 ndb-7.2.4)
id=5 (not connected, accepting connect from 10.10.223.174)
id=6 @10.10.221.254 (mysql-5.5.19 ndb-7.2.4)
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)

now perform rolling restart
now node status become

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.10.221.160 (mysql-5.5.19 ndb-7.2.4, Nodegroup: 0, Master)
id=3 @10.10.221.254 (mysql-5.5.19 ndb-7.2.4, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.12.200.117 (mysql-5.5.19 ndb-7.2.4)

[mysqld(API)] 9 node(s)
id=4 @10.10.221.157 (mysql-5.5.19 ndb-7.2.4)
id=5 (not connected, accepting connect from 10.10.223.174)
id=6 @10.10.221.254 (mysql-5.5.19 ndb-7.2.4)
id=7 @10.10.221.254 (mysql-5.5.19 ndb-7.2.4)
id=8 @10.10.221.157 (mysql-5.5.19 ndb-7.2.4)
id=9 @10.10.221.157 (mysql-5.5.19 ndb-7.2.4)
id=10 @10.10.221.254 (mysql-5.5.19 ndb-7.2.4)
id=11 (not connected, accepting connect from any host)
id=12 (not connected, accepting connect from any host)

now start the memcached service from 10.10.223.174 node
with command
/usr/local/mysql/bin/memcached -E /usr/local/mysql/lib/ndb_engine.so -e "connectstring=10.12.200.117:1186;role=db-only;debug=true" -vv -u root

now its started without any error

now status of all the nodes

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.10.221.160 (mysql-5.5.19 ndb-7.2.4, Nodegroup: 0, Master)
id=3 @10.10.221.254 (mysql-5.5.19 ndb-7.2.4, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.12.200.117 (mysql-5.5.19 ndb-7.2.4)

[mysqld(API)] 9 node(s)
id=4 @10.10.221.157 (mysql-5.5.19 ndb-7.2.4)
id=5 @10.10.223.174 (mysql-5.5.19 ndb-7.2.4)
id=6 @10.10.221.254 (mysql-5.5.19 ndb-7.2.4)
id=7 @10.10.221.254 (mysql-5.5.19 ndb-7.2.4)
id=8 @10.10.221.157 (mysql-5.5.19 ndb-7.2.4)
id=9 @10.10.221.157 (mysql-5.5.19 ndb-7.2.4)
id=10 @10.10.221.254 (mysql-5.5.19 ndb-7.2.4)
id=11 @10.10.223.174 (mysql-5.5.19 ndb-7.2.4)
id=12 @10.10.223.174 (mysql-5.5.19 ndb-7.2.4)

now i can tryout the example from link
http://www.clusterdb.com/mysql-cluster/scalabale-persistent-ha-nosql-memcache-storage-using-mysql-cluster/

NOW ITS WORKING FINE


thanks with regards
Deepak M



now status of all the nodes become

Options: ReplyQuote


Subject Views Written By Posted
memcached error Could not connect to NDB 2455 deepak m 02/24/2012 04:15AM
Re: memcached error Could not connect to NDB 1186 john.duncan 02/24/2012 08:10AM
Re: memcached error Could not connect to NDB 1309 deepak m 02/27/2012 07:25PM
Re: memcached error Could not connect to NDB 1157 Kamil J 03/06/2012 11:52AM
Re: memcached error Could not connect to NDB 1218 deepak m 03/20/2012 03:03AM
Re: memcached error Could not connect to NDB 1606 deepak m 03/20/2012 06:27AM
Re: memcached error Could not connect to NDB 1983 deepak m 03/26/2012 01:03AM
Re: memcached error Could not connect to NDB 1151 john.duncan 03/26/2012 09:15AM
Re: memcached error Could not connect to NDB 1100 deepak m 03/27/2012 03:25AM


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.