README-innodb_memcached
1Following are simple steps to get everything started:
2
31) Build MySQL server. Please note libevent 1.4.12 is linked statically into daemon memcached.
4
52) Start MySQL server. (make sure libmemcached.so and innodb_engine.so are copied to MySQL plugin directory).
6
73) Create the configure table and a demo table by running innodb_memcached_config.sql
8
9mysql < scripts/innodb_memcached_config.sql
10
114) Install the memcached daemon plugin:
12
13mysql> install plugin daemon_memcached soname "libmemcached.so";
14
155) Test it out
16telnet 127.0.0.1 11211
17
18set a11 0 0 9
19123456789
20STORED
21get a11
22VALUE a11 0 9
23123456789
24END
25
266) Run memcapable
27Memcapable is part of libmemcached package, it is available at "https://code.launchpad.net/~libmemcached-developers/libmemcached/trunk". If you did not install libevent by yourself, you might need to set LD_LIBRARY_PATH to point libevent.so in the libevent directory.
28
29jy@jy-laptop:~/work2/mysql-5.6-labs-innodb-memcached/bld/mysql-test$ memcapable -v
30ascii quit [pass]
31ascii version [pass]
32ascii verbosity [pass]
33ascii set [pass]
34ascii set noreply [pass]
35ascii get [pass]
36ascii gets [pass]
37ascii mget [pass]
38ascii flush [pass]
39ascii flush noreply [pass]
40ascii add [pass]
41ascii add noreply [pass]
42ascii replace [pass]
43ascii replace noreply [pass]
44ascii cas [pass]
45ascii cas noreply [pass]
46ascii delete [pass]
47ascii delete noreply [pass]
48ascii incr [pass]
49ascii incr noreply [pass]
50ascii decr [pass]
51ascii decr noreply [pass]
52ascii append [pass]
53ascii append noreply [pass]
54ascii prepend [pass]
55ascii prepend noreply [pass]
56ascii stat [pass]
57binary noop [pass]
58binary quit [pass]
59binary quitq [pass]
60binary set [pass]
61binary setq [pass]
62binary flush [pass]
63binary flushq [pass]
64binary add [pass]
65binary addq [pass]
66binary replace [pass]
67binary replaceq [pass]
68binary delete [pass]
69binary deleteq [pass]
70binary get [pass]
71binary getq [pass]
72binary getk [pass]
73binary getkq [pass]
74binary incr [pass]
75binary incrq [pass]
76binary decr [pass]
77binary decrq [pass]
78binary version [pass]
79binary append [pass]
80binary appendq [pass]
81binary prepend [pass]
82binary prependq [pass]
83binary stat [pass]
84All tests passed
85
867) memcached command line options now can be set by specifying MySQL configure variable "daemon_memcached-option"
87
888) You can also configure the commit batch size by specifying boot time system variable "daemon_memcached-w_batch_size" and "daemon_memcached-r_batch_size" (--loose-daemon_memcached-w_batch_size=100).
89
909) To enable binlog, please turn on server configure variable
91"innodb_direct_access_enable_binlog" along with "log-bin" at server boot time:
92msqld ... --log-bin --innodb_direct_access_enable_binlog=1
93