From: Maxime Thébault Date: October 4 2012 4:22pm Subject: Re: Problem with memcached List-Archive: http://lists.mysql.com/cluster/8410 Message-Id: <506DB7B0.1000401@siteenligne.fr> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit 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 >> > > >