More NoSQL for MySQL

At the 2011 MySQL user conference and expo, which is being held this week, Oracle is presenting a lab version of the free database. Among this version's advancements are an improved optimiser that allows certain queries to be processed faster, and the integration of memcached both in individual servers and in clusters. Memcached stores its data as keys and its values entirely in RAM. This allows the data to be accessed significantly faster than data that is stored on hard disks in the usual way.

A plug-in allows MySQL data to be accessed via memcached.
Source: innodb.com

The changes allow the NoSQL technology to run within the MySQL server process, which is said to reduce latency for memcached queries. On individual computers, NoSQL currently only uses one InnoDB table, but multiple tables are planned to become available in the future. "Key" and "value" in memcached are each columns in this table. Multiple columns can be defined as the value of a memcached key; a customisable character is used to separate individual entries. As the data is stored in an InnoDB table, it can be queried and edited via SQL commands. The integrated memcached daemon has so far only become available for Linux.

A posting on the InnoDB blog describes how to get the daemon set up and running. Alternatively, memcached can be used in a cluster installation of MySQL, as described in another blog posting.

(crve)