cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcasandra <mohitanch...@gmail.com>
Subject Re: Storing files in blob into Cassandra
Date Wed, 22 Jun 2011 17:11:28 GMT
Speaking purely from my personal experience, I haven't found cassandra
optimal for storing big fat rows. Even if it is only 100s of KB I didn't
find cassandra suitable for it. In my case I am looking at 400 writes + 400
reads per sec and grow 20%-30% every ear with file sizes from 70k-300k. What
I found is that when you have simultaneous reads and writes going in
parallel that is inserting and reading big rows it kills the performance of
cassandra. Even if you add more nodes it doesn't scale at the level you
would expect it to. You would start to see "dropped" messaged all around.
With 8 node cluster, good disks (SAS) and following recommendations of
tunning cassandra performance I was only able to get 140 inserts and 80
reads per sec.

You can simply test it by using stress tool and you will see the difference
as you start to increase the column size. and you would see that performance
of small columns that starts with 1000s / sec gets dropped quickly as you
start to increase column size.

But if your traffic is low volume it might work ok. Also, if over period you
will have tons of Blobs you might find yourself in difficult situation. I
suggest doing some tests.

--
View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Storing-files-in-blob-into-Cassandra-tp6503165p6505188.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.

Mime
View raw message