I'm interested in hearing about design strategies you have used with non-relational "nosql" databases - that is, the (mostly new) class of data stores that don't use traditional relational design or SQL (such as Hypertable, CouchDB, SimpleDB, Google App Engine datastore, Voldemort, Cassandra, SQL Data Services, etc.). They're also often ...
I'm pretty sure this is not Serverfault material, so bear with me. Wanting to implement a cache system for our application, we've started integrating with Memcached. Recently I started hearing of Hypertable, and saw some great benchmarks done with that.. However, I couldn't find good comparison between the two. Just to get things stra...
Is there a way to keep a timestamped record of every change to every column of every row in a MySQL table? This way I would never lose any data and keep a history of the transitions. Row deletion could be just setting a "deleted" column to true, but would be recoverable. I was looking at HyperTable, an open source implementation of Goog...
I have sucessfully installed Hypertable on top of Hadoop on a small cluster of Ubunto servers. At this point the only way to access the Hypertable is via the 'ht shell' command on one of the HT servers. Thats all very interesting, but now I want to access the hypertable database from a PC thats not part of the cluster. Preferably from C...
Sorry if this question is somewhat subjective. I am new to 'could store', 'distributed store' or some concepts like this. I really wonder what do they have in common and want to get an overview on all of them. What do I need to prepare if I want to write a product similar to this? ...