HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Need help configuring Memcached to store values in MySQL Cluster

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
needmemcachedhelpstoremysqlvaluesconfiguringcluster

Problem

I am working on a Memcached implementation with MySQL Cluster 7.2.
I have installed and configured memcached with following parameters:

PORT="11211" 
USER="mysql" 
MAXCONN="1024" 
CACHESIZE="1024" 
OPTIONS=""


but Memcached is working irrespective to the MySQL engine
(i.e. when inserting to Memcached it is not storing into database)

Can any one help me out giving parameters so that it will access the ndb engine and store the values in both memcache and also in database?

I am not able to figure out the relation between the two.

Solution

The basic docs for using the Memcached API for MySQL Cluster 7.2 start at http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-ndbmemcache.html

On the memcached command line, you need to supply an option like "-E ndb_engine.so". Memcached has a "pluggable engine" architecture, and the MySQL Cluster component is implemented as an NDB Engine. When memcached starts up with the correct engine you should see a log message like this:


01-Mar-2012 11:27:27 PST NDB Memcache 5.5.20-ndb-7.2.5 started [NDB 7.2.5; MySQL 5.5.20]
Contacting primary management server

Context

StackExchange Database Administrators Q#14119, answer score: 2

Revisions (0)

No revisions yet.