Sorry to fork this topic, but in "composite indexes" do you mean as strings or as "Composite()". I only ask cause we have started using the Composite as rowkeys and column names to replace the use of concatenated strings mainly for lookup purposes.
Plenty of comments in this thread already, and I agree with those saying
"it depends". From my experience, a cluster with 18 spindles total
could not match the performance and throughput of our primary
Oracle server which had 108 spindles. After we upgraded to SSD,
things have definitely changed for the better, for Cassandra.
Another thing is that if you plan to implement "composite indexes" by
catenating column values into additional columns, that would constitute
a "write" hence you'll need CPU. So watch out.
On 8/29/2011 9:15 AM, Helder Oliveira wrote:
What is the type of profile of a cassandra server.
Are SSD an option ?
Does cassandra needs better CPU ou lots of memory ?
Are SATA II disks ok ?
I am making some tests, and i started evaluating the possible hardware.
If someone already has conclusions about it, please share :D
Thanks a lot.