Re: Not able to run mutiple memcached instance

[Todd Farmer]

Hi Manjeet,

Is 192.168.175.26 your applicationserver1 machine? I ask because SHOW suggests both allocated API connections are being made from the same host:

[mysqld(API)] 2 node(s)
id=4 @192.168.175.26 (mysql-5.6.19 ndb-7.3.6)
id=5 @192.168.175.26 (mysql-5.6.19 ndb-7.3.6)

That tells me that perhaps multiple connections are being established from applicationserver1, leaving no available API node connections when applicationserver2 connects. I think this is confirmed by the fact that max_tps is 10000 by default, and the documentation states that, "The NDB Engine scheduler attempts to open 1 cluster connection per 50000 transactions per second (TPS)." You might try explicitly limiting each memcached instance to a single connection:

--scheduler=S:c1,f0,t1

http://dev.mysql.com/doc/ndbapi/en/ndbmemcache-configuration.html

Hope that helps!

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/