Re: hw requirements

2011-09-01 Thread Maxim Potekhin
Sorry about unclear naming scheme. I meant that if I want to index on a few columns simultaneously, I create a new column with catenated values of these. On 8/31/2011 3:10 PM, Anthony Ikeda wrote: Sorry to fork this topic, but in "composite indexes" do you mean as strings or as "Composite()". I

Re: hw requirements

2011-08-31 Thread Anthony Ikeda
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. Anthony On Wed, Aug 31, 2011 at 10:27 AM, Maxim

Re: hw requirements

2011-08-31 Thread Terje Marthinussen
SSD's definitely makes live simpler as you will get a lot less trouble with impact from things like compactions. Just beware that Cassandra expands data a lot due to storage overhead (for small columns), replication and needed space for compactions and repairs. It is well worth doing some rea

Re: hw requirements

2011-08-31 Thread Maxim Potekhin
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 f

Re: hw requirements

2011-08-29 Thread Richard Low
Hi, The hardware you choose depends a bit on your workload - writes vs reads, amount of cacheable data, latency requirements, etc.. What sort of workload do you expect? See http://wiki.apache.org/cassandra/CassandraHardware for some general advice. People typically have 8-24 GB RAM per node wit

hw requirements

2011-08-29 Thread Helder Oliveira
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 Than