NoSQL Performance in MySQL: Memcached Plugin for MySQL
How to get NoSql performance with Mysql?
How to make mysql use Memcached by default?
You can download this version of mysql from mysql 5.6.4-labs innodb-memcached for linux2.6-x86_64. By the way, as per Mysql labs' recommendation, you shouldn't use this version of mysql on your production server directly, test it firstly
Memcached stores key-value queries in memory to achieve NoSQL performance. Memcached has always worked with MySQL, but has run independently. This plugin should speed up the process considerably by allowing Memcached to access the InnoDB API directly.
The main features of this version as mentioned in Innodb blog are:
- Memcached as a daemon plugin of mysqld: both mysqld and memcached are running in the same process space, with very low latency access to data.
- Direct access to InnoDB: bypassing SQL parser and optimizer.
- Support standard protocol (memcapable): support both memcached text-based protocol and binary protocol; all 55 memcapable tests are passed.
- Support multiple columns: users can map multiple columns into "value". The value is separated by a pre-defined "separator" (configurable).
- Optional local caching: three options - "cache-only", "innodb-only", and "caching" (both "cache" and "innodb store"). These local options can apply to each of four Memcached operations (set, get, delete and flush).
- Batch operations: user can specify the batch commit size for InnoDB memcached operations via "daemon_memcached_r_batch_size" and "daemon_memcached_w_batch_size" (default 32).
- Support all memcached configure options through MySQL configure variable "daemon_memcached_option".