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:
Hello guys, 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.
