Databases
StackOverflow2013
Postsdbo
POdynamically horizontal scalable key value store
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POdynamically horizontal scalable key value store
    text
    copied!<p>Is there a key value store that will give me the following:</p> <ul> <li>Allow me to simply add and remove nodes and will redstribute the data automatically</li> <li>Allow me to remove nodes and still have 2 extra data nodes to provide redundancy</li> <li>Allow me to store text or images up to 1GB in size</li> <li>Can store small size data up to 100TB of data</li> <li>Fast (so will allow queries to be performed on top of it)</li> <li>Make all this transparent to the client</li> <li>Works on Ubuntu/FreeBSD or Mac</li> <li>Free or open source</li> </ul> <p>I basically want something I can use a "single", and not have to worry about having memcached, a db, and several storage components so yes, I do want a database "silver bullet" you could say.</p> <p>Thanks</p> <p>Zubair</p> <p>Answers so far: MogileFS on top of BackBlaze - As far as I can see this is just a filesystem, and after some research it only seems to be appropriate for large image files</p> <p>Tokyo Tyrant - Needs lightcloud. This doesn't auto scale as you add new nodes. I did look into this and it seems it is very fast for queries which fit onto a single node though</p> <p>Riak - This is one I am looking into myself, but I don't have any results yet</p> <p>Amazon S3 - Is anyone using this as their sole persistance layer in production? From what I have seen it seems to be used for storage of images as complex queries are too expensive</p> <p>@shaman suggested Cassandra - definitely one I am looking into</p> <p>So far it seems that there is no database or key value store that fulfills the criteria I mentioned, not even after offering a bounty of 100 points did the question get answered!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload