Thursday 1 October 2009

Observations on key-value databases

Observations on key-value databases: "

Key-value databases are catching fire these days. Memcached, Redis, Cassandra, Keyspace, Tokyo Tyrant, and a handful of others are surging in popularity, judging by the contents of my feed reader.



I find a number of things interesting about these tools.




  • There are many more of them than open-source traditional relational databases. (edit: I mean that there are many options that all seem similar to each other, instead of 3 or 4 standing out as the giants.)

  • It seems that a lot of people are simultaneously inventing solutions to their problems in private without being aware of each other, then open-sourcing the results. That points to a sudden sea change in architectures. Tipping points tend to be abrupt, which would explain isolated redundant development.

  • Many of the products are feature-rich with things programmers need: diverse language bindings, APIs, embeddability, and the ability to speak familiar protocols such as memcached protocol.

  • I think there are more solutions here than the ecosystem will support, and in five years a few will stand out as the most popular.

  • This process of paring down the gene pool is win-win because they’re open-source, and nothing will be lost.

  • Choosing which one to use is no easy task even for a highly skilled, technical, up-to-date person. Perhaps the decision-makers will choose on the availability of commercial support and consulting.

  • Many of them offer built-in, dead-simple, distributed, synchronous replication. This is very difficult to achieve with traditional relational databases. What makes key-value databases different? They don’t have MVCC, for one thing; but I’m not sure of the complete answer to that question, to tell the truth.



We live in interesting times.



Related posts:

  1. Analyze and optimize memcached usage with Maatkit Ryan poste
  2. A review of SQL and Relational Theory by C. J. Date

    SQL an
  3. Sessions of interest at MySQL Conference and Expo 2009 I haven


Related posts brought to you by Yet Another Related Posts Plugin.


PlanetMySQL Voting:
Vote UP /
Vote DOWN"

No comments:

Sike's shared items