MySQL is the most popular open source SQL database. The ever-increasing performance demands of web-based services have generated significant interest in providing NoSQL access methods to MySQL. Today, MySQL is announcing the preview of the NoSQL to InnoDB via memcached. This offering provides users with the best of both worlds – maintain all of the advantages of rich SQL query language, while providing better performance for simple queries via direct access to shared data.
In this preview release, memcached is implemented as a MySQL plugin daemon, accessing InnoDB directly via the native InnoDB API:
Features provided in the current release:
- 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”
Sounds interesting? You can download the source or binary from MySQL Labs (only tested on Linux) – select”mysql-5.6-labs-innodb-memcached”. After unpacking the files, please read the readme file “README-innodb_memcached”. Also, please read the upcoming blog “Get started with InnoDB Memcached Daemon plugin” by Jimmy.
This is a technology preview, with some limitations. We will gradually address those limitations. If you’d like to see additional new features or improvements, please let us know.
April 11th, 2011 at 6:47 pm
[...] Calvin mentioned in “NoSQL to InnoDB with Memcached“, we just released a “technology preview” of the feature that makes memcached a [...]
April 11th, 2011 at 9:28 pm
Why does Quora use MySQL as the data store rather than NoSQLs such as Cassandra, MongoDB, CouchDB, etc?…
“I think the “NoSQL” fad will end when someone finally implements a distributed relational database with relaxed semantics.” Adam D’Angelo MySQL’s NDBCLUSTER engine springs to mind as an example of this. Though I’m not sure what is meant by “r…
April 12th, 2011 at 11:46 am
[...] which comes with an integrated Memcached plugin accessing the InnoDB storage engine directly: NoSQL to InnoDB with Memcached The ever-increasing performance demands of web-based services have generated significant interest [...]
April 13th, 2011 at 7:21 am
[...] http://blogs.innodb.com/wp/2011/04/nosql-to-innodb-with-memcached/ http://blogs.oracle.com/mysql/2011/04/nosql_to_mysql_with_memcached.html Related postsNoSQL в [...]
April 18th, 2011 at 12:58 pm
[...] [...]
April 26th, 2011 at 9:36 am
[...] Learn more » [...]
April 27th, 2011 at 1:12 pm
[...] פעולות כגון SQL Statement Parsing לא פועלות, כך שיותר משאבי מערכת (מעבד, זיכרון ו-I/O) מוקדשים לשרת שאילתות במנוע האחסון עצמו. ניתן לקרוא עוד בלינק הבא. [...]
May 6th, 2011 at 7:15 pm
[...] NoSQL to InnoDB with Memcached, by Calvin Sun [...]
May 12th, 2011 at 12:51 am
[...] NoSQL to InnoDB with Memcached [...]
May 12th, 2011 at 7:55 am
[...] NoSQL to InnoDB with Memcached [...]
May 12th, 2011 at 9:56 am
[...] 写这一篇内容的原因是MySQL5.6.2突然推出了memcached的功能。NoSQL to InnoDB with Memcached的 出现，可以看出NoSQL对关系数据库的确产生了巨大的影响，个人觉得这是一个非常大的进步，可以让开发人员更加方便的使用NoSQL和关系数据库。 NoSQL一般被认为性能高于关系数据库，那么直接在InnoDB之上提供NoSQL功能并和MySQL共存是否是一个更好的选择呢？ [...]
May 18th, 2011 at 4:54 am
[...] interno da integração entre o MySQL 5.6 o chamado “NoSQL Style”, publicada no site da InnoDB (antiga InnoBase Oy), empresa de propriedade da Oracle desde 2005, que desenvolve o InnoDB built-in e o InnoDB [...]
July 27th, 2011 at 2:22 am
[...] Transactions on InnoDB » Blog Archive » NoSQL to InnoDB with Memcached (tags: nosql innodb mysql memcached) [...]
September 19th, 2011 at 4:04 am
[...] for exceeding 750000 QPS on a server has [reproduced] UPDATE: Oracle officially released memcached daemon plugin that talks with InnoDB. I’m glad to see that NoSQL+MySQL has become an official solution. [...]
October 4th, 2011 at 2:02 pm
[...] http://blogs.innodb.com/wp/2011/04/nosql-to-innodb-with-memcached/ [...]
October 10th, 2011 at 9:13 am
[...] and transactions, bringing the best of both worlds together. More information can be found on the InnoDB blog, as well as an installation guide. Weiterführende Artikel04.10.2011 — NoSQL in MySQL26.09.2011 [...]
December 27th, 2011 at 4:06 am
[...] Shared Transactions on InnoDB » Blog Archive » NoSQL to InnoDB with Memcached. [...]
March 9th, 2012 at 12:59 pm
When i’ used memcached my server load decrease about 70%.
[Reply]
April 11th, 2012 at 8:52 pm
[...] interno da integração entre o MySQL 5.6 o chamado “NoSQL Style”, publicada no site da InnoDB (antiga InnoBase Oy), empresa de propriedade da Oracle desde 2005, que desenvolve o InnoDB built-in e o InnoDB [...]
April 14th, 2012 at 5:07 pm
[...] introduziu em sua entrutura uma interface NoSQL usando a API memcached que permite que usuários acessem diretamente o motor de armazenamento InnoDB, contornando completamente procedimentos SQL e mantendo compatibilidade com o modelo de base de [...]