Home You Got NoSQL in MySQL: Memcached Plugin in MySQL Technology Preview

You Got NoSQL in MySQL: Memcached Plugin in MySQL Technology Preview

Oracle released a technology preview this week a new version of MySQL that adds support for a Memcached plugin daemon for accessing InnoDB, MySQL’s default storage engine. It’s available from MySQL Labs. The plugin daemon is only available for Linux at this time.

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.

Here are the features, according to the InnoDB blog:

  • 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”

memcached was originally created for Live Journal. It’s now managed by Couchbase, the corporate sponsor of Membase and Apache CouchDB.Update: memcached is actually an independent project.

About ReadWrite’s Editorial Process

The ReadWrite Editorial policy involves closely monitoring the tech industry for major developments, new product launches, AI breakthroughs, video game releases and other newsworthy events. Editors assign relevant stories to staff writers or freelance contributors with expertise in each particular topic area. Before publication, articles go through a rigorous round of editing for accuracy, clarity, and to ensure adherence to ReadWrite's style guidelines.

Get the biggest tech headlines of the day delivered to your inbox

    By signing up, you agree to our Terms and Privacy Policy. Unsubscribe anytime.

    Tech News

    Explore the latest in tech with our Tech News. We cut through the noise for concise, relevant updates, keeping you informed about the rapidly evolving tech landscape with curated content that separates signal from noise.

    In-Depth Tech Stories

    Explore tech impact in In-Depth Stories. Narrative data journalism offers comprehensive analyses, revealing stories behind data. Understand industry trends for a deeper perspective on tech's intricate relationships with society.

    Expert Reviews

    Empower decisions with Expert Reviews, merging industry expertise and insightful analysis. Delve into tech intricacies, get the best deals, and stay ahead with our trustworthy guide to navigating the ever-changing tech market.