postgreSQL vs Cassandra vs MongoDB vs Voldemart ?

Posted by ramonrails on Server Fault See other posts from Server Fault or by ramonrails
Published on 2010-05-03T15:43:55Z Indexed on 2010/05/03 15:48 UTC
Read the original article Hit count: 946

Filed under:

database

|

sharding

|

scalability

|

database-performance

Which database to decide upon? Any comparisions?

Existing: postgresql
Issues
- Not easily scalable horizontal. Needs sharding etc
- Clustering does not solve the data growth problem
Looking for: Any database that is easily horizontally scalable
- Cassandra (Twitter uses that?)
- MongoDB (rapidly gaining popularity)
- Voldemart
- Other?
Why?
- Data growing with snowball effect
- existing postgresql locks table etc for vaccuum tasks periodically
- Archiving data is tideous currently
- Human interaction involved in existing archive, vaccuum, ... process periodically
- Need a 'set it. forget it. just add another server when data grows more.' type of solution

© Server Fault or respective owner

Related posts about database

SQL SERVER Retrieve and Explore Database Backup without Restoring Database Idera virtual database

as seen on Dot net Slackers - Search for 'Dot net Slackers'
I recently downloaded Ideras SQL virtual database, and tested it. There are a few things about this tool which caught my attention.My ScenarioIt is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database… >>> More
Cloning A Database On The Same Server Using Rman Duplicate From Active Database

as seen on Oracle Blogs - Search for 'Oracle Blogs'
To clone a database using Rman we used to require an existing Rman backup, on 11g we can clone databases using the "from active" database option. In this case we do not require an existing backup, the active datafiles will be used as the source for the clone. In order to clone with the source database… >>> More
cPickle ImportError: No module named multiarray

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I'm using cPickle to save my Database into file. The code looks like that: def Save_DataBase(): import cPickle from scipy import * from numpy import * a=Results.VersionName #filename='D:/results/'+a[a.find('/')+1:-a.find('/')-2]+Results.AssType[:3]+str(random.randint(0,100))+Results.Distribution+"… >>> More
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

as seen on SQL Authority - Search for 'SQL Authority'
Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More

Related posts about sharding

Custom Lucene Sharding with Hibernate Search

as seen on Stack Overflow - Search for 'Stack Overflow'
Has anyone experience with custom Lucene sharding / paritioning using Hibernate Search? The documentation of Hibernate Search says the following about Lucene Sharding : In some cases, it is necessary to split (shard) the indexing data of a given entity type into several Lucene indexes.… >>> More
PASS Conference 2011 Topic: Multitenant Design and Sharding with SQL Azure

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I am really happy to announce that I have been accepted as a speaker at the 2011 PASS Conference in Seattle. The topic? It will be about SQL Azure scalability using shards, and the Data Federation feature of SQL Azure. I will also talk extensively about the community open-source sharding library Enzo… >>> More
SQL Sharding and SQL Azure…

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Herve Roggero has just published a paper that outlines patterns for scaling using SQL Azure and the Blue Syntax (he and Scott Klein’s company) sharding api. You can find the paper at: http://www.bluesyntax.net/files/EnzoFramework.pdf Herve and Scott have also just released an Apress book Pro SQL… >>> More
Webscale is all about sharding and its coming to SQL Azure

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
There are many that joke about developers always talking about webscale and needing to shard to be able to scale. In reality many systems, if not most, don’t need to be able to scale to numerous nodes because todays processing is so powerful. However in the cloud world where you don’t have 1 big box… >>> More
High-concurrency counters without sharding

as seen on Stack Overflow - Search for 'Stack Overflow'
This question concerns two implementations of counters which are intended to scale without sharding (with a tradeoff that they might under-count in some situations): http://appengine-cookbook.appspot.com/recipe/high-concurrency-counters-without-sharding/ (the code in the comments) http://blog.notdot… >>> More