Twice now I've had to dig up this list in google. Writing it down here to remember it.
http://www.metabrew.com/article/anti-rdbms-a-list-of-distributed-key-value-stores/
Another summary, thanks to Adam:
http://randomfoo.net/2009/04/20/some-notes-on-distributed-key-stores
