RE: sstableloader 1.1 won't stream

2012-05-10 Thread Pieter Callewaert
Firstly I disabled ipv6 on the server to be sure it wasn't trying to use the ipv6, but no effect. I've tried using sstableloader on one of the cassandra nodes, no probem here, worked perfectly! So was doubting if the first server was corrupt or something, so I tried on another server, CentOS

Re: Timeout Exception in get_slice

2012-05-10 Thread Luís Ferreira
The multi get batches range from 100 to 200. The tests I'm running need to do get_slices and the multigets on those results. I can't turn either of them off. I was only setting 16 threads for reading, but I'll boost it up to 32 and see what happens. On May 9, 2012, at 11:03 AM, aaron morton

Re: Use-case: multi-instance webshop

2012-05-10 Thread aaron morton
It's hard to beat Solr for seach and faceted navigation. Perhaps consider using Cassandra and Solr or take a look at http://www.datastax.com/products/enterprise Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 8/05/2012, at 11:06 PM, R.

Re: enforcing ordering

2012-05-10 Thread Franc Carter
On Thu, May 10, 2012 at 9:05 PM, aaron morton aa...@thelastpickle.comwrote: Kewl. I'd be interested to know what you come up with. Sure - I'll post details once we have them nailed down. I suspect that it will be 'obvious in hindsight', I'm still suffering from RDBMS brain - which is

Re: Use-case: multi-instance webshop

2012-05-10 Thread Radim Kolar
Is Cassandra a fit for this use-case or should we just stick with the oldskool MySQL and put things like votes, reviews etc in our C* store? If all your data fits into one computer and you expect only tens of millions records in table then go for SQL. It has far more features and people are

Re: sstableloader 1.1 won't stream

2012-05-10 Thread aaron morton
It looks like a networking thing. Is there anything interesting in the network config ? Are the nodes using a broadcast_address ? Can you telnet from the machine running sstableloader to port 7000 on 10.10.10.101 ? I *think* sstableload will use the log4j-server.properties log config. Can you

Re: Use-case: multi-instance webshop

2012-05-10 Thread R. Verlangen
@Aaron: Solr will probably be the solution to our problem. Thank you! @Radim: We already have a Cassandra cluster, we do not want to add an extra MongoDB cluster. At this moment the data would fit easily in SQL, but we don't know how our platform grows and we want to be prepared for the future.

live ratio counting

2012-05-10 Thread Radim Kolar
liveratio calc should do nothing if memtable has 0 columns. I did manual flush before this. WARN [MemoryMeter:1] 2012-05-10 13:21:19,430 Memtable.java (line 181) setting live ratio to maximum of 64 instead of Infinity INFO [MemoryMeter:1] 2012-05-10 13:21:19,431 Memtable.java (line 186)

Re: .bat files in cassandra1.1?

2012-05-10 Thread cyril auburtin
sorry found something interesting here http://www.datastax.com/download/community 2012/5/10 cyril auburtin cyril.aubur...@gmail.com I wanted to use on Windows, but I don't see the .bat files for cassandra, cassandra-cli I remember they existed for 0.7.10 I think thx

Re: how to re-distribute replicas after changing rack assignment

2012-05-10 Thread Bill Au
Thanks, Aaron. Moving one node at a time and running repair does seem to do the trick. Bill On Thu, May 10, 2012 at 7:03 AM, aaron morton aa...@thelastpickle.comwrote: That's a bit tricky. How many nodes, what is the replication and what is the current rack assignment ? NTS stripes data

Re: [1.1] Can't create column

2012-05-10 Thread Conan Cook
Just stumbled upon this by chance, is it related? https://issues.apache.org/jira/browse/CASSANDRA-2497 Conan On 6 May 2012 13:19, cyril auburtin cyril.aubur...@gmail.com wrote: It's the comparator so? because I tried without the single quotes on column_name and same error thanks 2012/5/6

removing second data center from live cluster

2012-05-10 Thread Bill Au
My cluster is currently running with 2 data centers, dc1 and dc2. I would like to remove dc2 and all its nodes completely. I am using local quorum for read and right. I figure that I need to change the replication factor to {dc1:3, dc2:0} before running nodetool decommission on each node in

Behavior on inconsistent reads

2012-05-10 Thread Carpenter, Curt
Hi all, newbie here. Be gentle. From http://www.datastax.com/docs/1.0/cluster_architecture/about_client_reque sts: Thus, the coordinator first contacts the replicas specified by the consistency level. The coordinator will send these requests to the replicas that are currently responding most

Re: Behavior on inconsistent reads

2012-05-10 Thread Dave Brosius
If you read at Consistency of at least quorum, you are guaranteed that at least one of the nodes has the latest data, and so you get the right data. If you read with less than quorum it would be possible for all the nodes that respond to have stale data. On 05/10/2012 09:46 PM, Carpenter,