MySQL Forums
Forum List  »  Quality Assurance

Re: how update occurs in ndb cluster
Posted by: deepak m
Date: March 27, 2012 07:21AM

hi

start the memcached with following options

/usr/local/mysql/bin/memcached -E /path/to/ndb_engine.so -e "connectstring=<managmt host ip>:1186;role=db-only;debug=true" -vv -u root


to work with memcached you need to import this sql file

/usr/local/mysql/share/memcache-api/ndb_memcache_metadata.sql


memcached will first checks the ndbmemcache database
in that cache_policies table is there

there are 4 types of policies are there those are

cache_only: updates will be done for cache only
ndb_only: updated will be done for database only
caching: first it will updates database and then cache
disabled: not permit anything

we can set these froperty for GET,SET,ADD,FLUSH metheds in cache_policies table

container is the table which contains container name which database,which table, key columns,value columns informations

key_prefixes is the another table which contains the key prefix name which policy name to be used and the container name

check below link for more info
http://docs.oracle.com/cd/E17952_01/refman-5.5-en/mysql-cluster-ndbmemcache-configuration.html

Regards
Deepak M

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how update occurs in ndb cluster
1426
March 27, 2012 07:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.