From: Maxime Thébault Date: October 4 2012 4:36pm Subject: Re: Problem with memcached List-Archive: http://lists.mysql.com/cluster/8412 Message-Id: <506DBB09.9010505@siteenligne.fr> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit I have a result with good value. I try to search variable for set limit of use for a node but i cant find it! (i see it on mysql website but impossible to refind!) I'd try increasing the number of connections per node as possible. Thank Andrew. Le 04/10/2012 18:32, Andrew Morgan a écrit : > Hi Maxime, > > Try running "ndb_mgm -c 37.59.48.15:1186 -e show" from the same host that you're running memcached from to see if you get the same response. > > Regards, Andrew. > >> -----Original Message----- >> From: Maxime Thébault [mailto:webmaster@stripped] >> Sent: 04 October 2012 17:22 >> To: cluster@stripped >> Subject: Re: Problem with memcached >> >> Thanks for your answer ! >> >> I check in my ndb_1_cluster.log and i have this line : >> 2012-10-04 18:10:39 [MgmtSrvr] WARNING -- Failed to allocate nodeid for >> API at 2.2.2.2. Returned eror: 'No free node id found for mysqld(API).' >> 2012-10-04 18:10:42 [MgmtSrvr] WARNING -- Failed to allocate nodeid for >> API at 2.2.2.2. Returned eror: 'No free node id found for mysqld(API).' >> >> >> But when i run on my manager ndb_mgm -e show i have this : >> >> ndb_mgm> show >> Connected to Management Server at: localhost: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) >> >> Twelve free nodes... I have 14 empty [MYSQLD] in my manager config file. >> I must specific option in this sections ? >> >> Maxime >> >> Le 04/10/2012 18:02, Andrew Morgan a écrit : >>> Hi Maxime, could you please check the Cluster log (it should be located >> with the ndb_mgmd) to see if there's evidence of the memcached trying to >> connect? Otherwise, double check that the connect string is for the correct >> host and port for the ndb_mgmd and that there are no firewall rules that >> would block communication between these hosts. >>> Regards, Andrew. >>> >>> Andrew Morgan | MySQL Principal Product Manager >>> Mobile: +447833483595 >>> Web: www.clusterdb.com >>> United Kingdom >>> >>> ORACLE Corporation UK Ltd is a company incorporated in England & Wales >>> | Company Reg. No. 1782505 | Reg. office: Oracle Parkway, Thames >>> Valley Park, Reading RG6 1RA >>> >>>> -----Original Message----- >>>> From: Maxime Thébault [mailto:webmaster@stripped] >>>> Sent: 04 October 2012 09:56 >>>> To: cluster@stripped >>>> Subject: Problem with memcached >>>> >>>> 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 ! >>>> >>>> >>>> >>>> >>>> -- >>>> MySQL Cluster Mailing List >>>> For list archives: http://lists.mysql.com/cluster >>>> To unsubscribe: http://lists.mysql.com/cluster >>>> >>> >>> >> >> -- >> MySQL Cluster Mailing List >> For list archives: http://lists.mysql.com/cluster >> To unsubscribe: http://lists.mysql.com/cluster >> > > >