(Edit: as compared to other 'non traditional' database systems).
(Edit: as compared to other 'non traditional' database systems).
Cassandra only guarantees eventual consistency where as most RDBMS systems are focused on always showing a consistent view of data. Because of this (and other trade-offs), Cassandra is able to provide much higher IO rates as well as improved fault tolerance and linear scalability.
Twitter, Digg, and Facebook all happen to have usages which fit perfectly with this model. If you see a status update a few seconds (or even minutes) late occasionally it's no big deal. If your bank funds aren't matching for that long, it can be a big deal.
Edit: I just started looking into Cassandra a few days ago so someone please correct me if I've mis-stated anything.
How will we add new machines? Are their any single points of failure? Do the writes scale as well? How much administration will the system require? If its open source, is there a healthy community?
(And I would add, is it _fast_ as well as scalable?)