Saturday 15 May 2010

database - High Performance DB for Fast Read and Fast Write. No Update or Delete -



database - High Performance DB for Fast Read and Fast Write. No Update or Delete -

i looking database/mechanism store info can write info , read info high performance.

this storage used storing logging of import info across multiple systems. since it's critical info logged, read performance should pretty fast these info used show history. since never update on them/delete on them/or kinda joins, looking right solution. might archive info in long time that's ok deal with.

i tried looking @ different sources understand different nosql databases, experts sentiment improve :)

must have: 1. fast read without fail 2. fast write without fail 3. random access performance 4. replication kinda feature, 1 goes down, should , working 5. concurrent write/read info have: 1. search content analysing info auditing with/without indexes don't required: 1. transactions not required @ 2. update never happens 3. delete never happens 4. joins not required

referred: http://kkovacs.eu/cassandra-vs-mongodb-vs-couchdb-vs-redis

be sure consider aerospike; aerospike dominates in adtech space high throughput reads , writes required. aerospike touted having "the speed of redis scalability of cassandra." searching/querying see aerospike's secondary index documentation.

for more info see discussion/articles below:

aerospike vs cassandra aerospike vs redis , mongo aerospike benchmarks

lastly verify performance one 1000000 tps on ec2 instructions.

database performance nosql aerospike

No comments:

Post a Comment