Sample Header Ad - 728x90

Adding Memcached plugin to Mysql Cluster Fails to start

0 votes
1 answer
160 views
I was able to setup a new mysql cluster, with total 6 VMs. New requirement is to add memcache plugin to mysql cluster, memcache failing to start with this error message WARNING -- Failed to allocate nodeid for API at 192.168.1.100. Returned error: 'No free node id found for mysqld(API).' . Here is my existing setup. 192.168.1.100 Management1 192.168.1.101 Management2 192.168.1.102 datanode1 192.168.1.103 datanode2 192.168.1.104 sqlnode1 192.168.1.105 sqlnode2 I am trying to run memcached on existing sql nodes > sqlnode1 & sqlnode2 Here is the configuration on management nodes Management1, Management2 [ndb_mgmd default] DataDir=/mysql/data [ndbd default] NoOfReplicas=2 LockPagesInMainMemory=1 DataMemory=25G IndexMemory=5G NoOfFragmentLogFiles=300 DataDir=/mysql/data MaxNoOfConcurrentOperations=1000000 SchedulerSpinTimer=400 SchedulerExecutionTimer=100 RealTimeScheduler=1 MaxNoOfTables=1024 MaxNoOfOrderedIndexes=256 [ndb_mgmd] HostName=192.168.1.100 NodeId=51 [ndb_mgmd] HostName=192.168.1.101 NodeId=52 [ndbd] HostName=192.168.1.102 NodeId=53 [ndbd] HostName=192.168.1.103 NodeId=54 [mysqld] HostName=192.168.1.104 NodeId=55 [mysqld] HostName=192.168.1.105 NodeId=56 [mysqld] HostName=192.168.1.104 NodeId=57 [mysqld] HostName=192.168.1.105 NodeId=58 Here is configuration file /etc/my.conf on data & sql nodes datenode1, datanode2, sqlnode1, sqlnode2. [mysqld] ndbcluster ndb-connectstring=192.168.1.100,192.168.1.101 datadir=/mysql/data socket=/var/lib/mysql/mysql.sock symbolic-links=0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [mysql_cluster] ndb-connectstring=192.168.1.100,192.168.1.101 current status of cluster. #ndb_mgm -e show Connected to Management Server at: 192.168.1.100:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=53 @192.168.1.102 (mysql-5.7.19 ndb-7.5.7, Nodegroup: 0) id=54 @192.168.1.103 (mysql-5.7.19 ndb-7.5.7, Nodegroup: 0, *) [ndb_mgmd(MGM)] 2 node(s) id=51 @192.168.1.100 (mysql-5.7.19 ndb-7.5.7) id=52 @192.168.1.101 (mysql-5.7.19 ndb-7.5.7) [mysqld(API)] 4 node(s) id=55 @192.168.1.104 (mysql-5.7.19 ndb-7.5.7) id=56 @192.168.1.105 (mysql-5.7.19 ndb-7.5.7) id=57 (not connected, accepting connect from 192.168.1.104) id=58 (not connected, accepting connect from 192.168.1.105) # here is the error when I try to add memcache plugin to mysql cluster. created ndbmemcache configuration in database, didnt notice any error. # mysql -u root -p ndb_initialize() main --> connect_to_primary_cluster() 27-Oct-2017 15:35:04 UTC NDB Memcache 5.7.19-ndb-7.5.7 started [NDB 7.5.7; MySQL 5.7.19] Contacting primary management server (192.168.1.100:1186,192.168.1.101:1186) ... main --> ClusterConnectionPool::connect() FAILED. Could not connect to NDB. Shutting down. main --> ndb_destroy() Failed to initialize instance. Error code: 255 # cluster management logs ndb_51_cluster.log show this Warning message. 2017-10-27 15:33:44 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 192.168.1.104. Returned error: 'No free node id found for mysqld(API).' 2017-10-27 15:35:06 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 192.168.1.104. Returned error: 'No free node id found for mysqld(API).' 2017-10-27 15:35:09 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 192.168.1.104. Returned error: 'No free node id found for mysqld(API).' 2017-10-27 15:35:12 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 192.168.1.104. Returned error: 'No free node id found for mysqld(API).' 2017-10-27 15:35:15 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 192.168.1.104. Returned error: 'No free node id found for mysqld(API).' 2017-10-27 15:35:18 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 192.168.1.104. Returned error: 'No free node id found for mysqld(API). ' Can someone please suggest how can I fix this issue, I already have additional sql client nodes, but not able to start memcache process. Thanks,
Asked by bobby (1 rep)
Oct 27, 2017, 10:35 PM
Last activity: Jul 12, 2025, 09:07 AM