From: Andrew Morgan Date: October 4 2012 5:00pm Subject: RE: Problem with memcached List-Archive: http://lists.mysql.com/cluster/8415 Message-Id: <6d785a4d-214e-420a-99f1-a97969cffe54@default> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable It's ndb-cluster-connection-pool but this is a server option rather than a = cluster-wide one. Try disabling the firewall on the hosts - those running data nodes, ndb_mgm= d and mysqld/memcached's. Since your last change to config.ini have you restarted (with "--initial") = your ndb_mgmds and (with "--reload") your data nodes? Andrew. > -----Original Message----- > From: Maxime Th=E9bault [mailto:webmaster@stripped] > Sent: 04 October 2012 17:47 > To: Andrew Morgan > Subject: Re: Problem with memcached >=20 > Same problem : >=20 > 2012-10-04 18:45:39 [MgmtSrvr] WARNING -- Failed to allocate nodeid for > API at XX.XX.XX.XX. Returned eror: 'No free node id found for mysqld(API)= .' - > Repeated 14 times >=20 > I think it's the option for allow 1 node to have multiple connect at mana= ger > but i can't find his name. Do you know it? >=20 > thank you very much! >=20 > Le 04/10/2012 18:38, Andrew Morgan a =E9crit : > > Try running another mysqld process from the node that you're running > memcached from. By default, I believe that the memcached plug-in uses 2 > API connections to the cluster and so from your ndb_mgm output you should > have enough. > > > > Andrew. > > > >> -----Original Message----- > >> From: Maxime Th=E9bault [mailto:webmaster@stripped] > >> Sent: 04 October 2012 17:36 > >> To: cluster@stripped > >> Subject: Re: Problem with memcached > >> > >> 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 =E9crit : > >>> 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=E9bault [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=3D3 @1.1.1.1 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0) > >>>> id=3D4 @2.2.2.2 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master) > >>>> > >>>> [ndb_mgmd(MGM)] 2 node(s) > >>>> id=3D1 @3.3.3.3 (mysql-5.5.22 ndb-7.2.6) > >>>> id=3D2 @4.4.4.4 (mysql-5.5.22 ndb-7.2.6) > >>>> > >>>> [mysqld(API)] 14 node(s) > >>>> id=3D5 @2.2.2.2 (mysql-5.5.22 ndb-7.2.6) > >>>> id=3D6 @1.1.1.1 (mysql-5.5.22 ndb-7.2.6) > >>>> id=3D7 (not connected, accepting connect from any host) > >>>> id=3D8 (not connected, accepting connect from any host) > >>>> id=3D9 (not connected, accepting connect from any host) > >>>> id=3D10 (not connected, accepting connect from any host) > >>>> id=3D11 (not connected, accepting connect from any host) > >>>> id=3D12 (not connected, accepting connect from any host) > >>>> id=3D13 (not connected, accepting connect from any host) > >>>> id=3D14 (not connected, accepting connect from any host) > >>>> id=3D15 (not connected, accepting connect from any host) > >>>> id=3D16 (not connected, accepting connect from any host) > >>>> id=3D17 (not connected, accepting connect from any host) > >>>> id=3D18 (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 =E9crit : > >>>>> 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=E9bault [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=3D3 @1.1.1.1 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0) > >>>>>> id=3D4 @2.2.2.2 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master) > >>>>>> > >>>>>> [ndb_mgmd(MGM)] 2 node(s) > >>>>>> id=3D1 @3.3.3.3 (mysql-5.5.22 ndb-7.2.6) > >>>>>> id=3D2 @4.4.4.4 (mysql-5.5.22 ndb-7.2.6) > >>>>>> > >>>>>> [mysqld(API)] 14 node(s) > >>>>>> id=3D5 @2.2.2.2 (mysql-5.5.22 ndb-7.2.6) > >>>>>> id=3D6 @1.1.1.1 (mysql-5.5.22 ndb-7.2.6) > >>>>>> id=3D7 (not connected, accepting connect from any host) > >>>>>> id=3D8 (not connected, accepting connect from any host) > >>>>>> id=3D9 (not connected, accepting connect from any host) > >>>>>> id=3D10 (not connected, accepting connect from any host) > >>>>>> id=3D11 (not connected, accepting connect from any host) > >>>>>> id=3D12 (not connected, accepting connect from any host) > >>>>>> id=3D13 (not connected, accepting connect from any host) > >>>>>> id=3D14 (not connected, accepting connect from any host) > >>>>>> id=3D15 (not connected, accepting connect from any host) > >>>>>> id=3D16 (not connected, accepting connect from any host) > >>>>>> id=3D17 (not connected, accepting connect from any host) > >>>>>> id=3D18 (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=3D3.3.3.3:1186;role=3Ddb-only;debug=3Dtrue" -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 > >>>> > >>> > >>> > >> > >> -- > >> MySQL Cluster Mailing List > >> For list archives: http://lists.mysql.com/cluster > >> To unsubscribe: http://lists.mysql.com/cluster > >> > > > > > > >=20