Re: Tripling size of a cluster

2012-07-19 Thread Mariusz Dymarek
Hi again, we have now moved all nodes to correct position in ring, but we can see higher load on 2 nodes, than on other nodes: ... node01-05 rack1 Up Normal 244.65 GB 6,67% 102084710076281539039012382229530463432 node02-13 rack2 Up Normal 240.26 GB 6,67%

random partitioner and key scan

2012-07-19 Thread Patrik Modesto
Hi, I know that RandomPartitioner does MD5 of a key and the MD5 is then used for key distribution AND key ordering. I was just wondering if it's possible to have RandomPartitioner just for key distribution and OrderedPartitioner just for per-node key ordering. That would solve the often requested

Re: random partitioner and key scan

2012-07-19 Thread prasenjit mukherjee
I agree. The probem could be while redistributing the tokens. In that case the hashes has to be recalculated on each fo the candidate node. -Thanks, Prasenjit On Thu, Jul 19, 2012 at 12:19 PM, Patrik Modesto patrik.mode...@gmail.com wrote: Hi, I know that RandomPartitioner does MD5 of a key

Re: random partitioner and key scan

2012-07-19 Thread Patrik Modesto
Hi Prasenjit, I don't see the need to recalculate anything. One key has a one MD5 hash, it doesn't change. Just use the hash to select a node, than just the plain key. Can you elaborate on the redistribution please? Regards, P. On Thu, Jul 19, 2012 at 9:09 AM, prasenjit mukherjee

Unreachable node, not in nodetool ring

2012-07-19 Thread Alain RODRIGUEZ
Hi, I tried to add a node a few days ago and it failed. I finally made it work with an other node but now when I describe cluster on cli I got this : Cluster Information: Snitch: org.apache.cassandra.locator.Ec2Snitch Partitioner: org.apache.cassandra.dht.RandomPartitioner Schema

Re: Unreachable node, not in nodetool ring

2012-07-19 Thread Olivier Mallassi
I got that a couple of time (due to DNS issues in our infra) what you could try - check in cassandra log. It is possible you see a log line telling you 10.56.62.211 and 10.59.21.241 o 10.58.83.109 share the same token - if 10.56.62.211 is up, try decommission (via nodetool) - if not, move

Re: Unreachable node, not in nodetool ring

2012-07-19 Thread Alain RODRIGUEZ
Hi, I wasn't able to see the token used currently by the 10.56.62.211 (ghost node). I already removed the token 6 days ago : - Removing token 170141183460469231731687303715884105727 for /10.56.62.211 - check in cassandra log. It is possible you see a log line telling you 10.56.62.211 and

Re: Unreachable node, not in nodetool ring

2012-07-19 Thread Alain RODRIGUEZ
Not sure if this may help : nodetool -h localhost gossipinfo /10.58.83.109 RELEASE_VERSION:1.1.2 RACK:1b LOAD:5.9384978406E10 SCHEMA:e7e0ec6c-616e-32e7-ae29-40eae2b82ca8 DC:eu-west STATUS:NORMAL,85070591730234615865843651857942052864 RPC_ADDRESS:0.0.0.0 /10.248.10.94

Counters values are less than expected [1.0.6 - Java/Pelops]

2012-07-19 Thread cbert...@libero.it
Hi all, I have a problem with counters I'd like to solve before going in production. When a user write a comment in my platform I increase a counter (there is a counter for each user) and I write a new column in the user specific row. Everything worked fine but yesterday I noticed that the

Re: random partitioner and key scan

2012-07-19 Thread prasenjit mukherjee
When a request for token change is issued ( via nodetool ) then on what basis a node will move some of its rows to other node, as there will be no way to scan rows based on MD5 hash in a given node ( if the keys are not prefixed with MD5 hash ) On Thu, Jul 19, 2012 at 1:43 PM, Patrik Modesto

does secondary index get created(rebuilt?) every time Cassandra restarts?

2012-07-19 Thread Feng Qu
We have a CF with 11 secondary indexes (don't ask me why) and I noticed restarting cassandra takes much longer time comparing to other clusters without secondary indexes. In system.log I see 20 mins pause on building index.  this example shows a 12 mins gap.  INFO [SSTableBatchOpen:13]

Re: Inability to drop column families

2012-07-19 Thread Kirk
What does show schema show? Is the CF showing up? Are the data files for the CF on disk? If you poke around with the system CFs, is there any data still present? On 07/17/2012 02:54 PM, sj.climber wrote: Looking for ideas on how to diagnose this issue. I have installed v1.1.2 on a two-node

Re: Replication factor - Consistency Questions

2012-07-19 Thread Kirk True
But isn't QUORUM on a 2-node cluster still 2 nodes? On 07/17/2012 11:50 PM, Jason Tang wrote: Yes, for ALL, it is not good for HA, and because we meet problem when use QUORAM, and current solution is switch Write:QUORAM / Read:QUORAM when got UnavailableException exception. 2012/7/18 Jay

Re: Batch update efficiency with composite key

2012-07-19 Thread Kirk True
In Cassandra you don't read-then-write updates, you just write the updates. Sorry for being dense, but can you clarify a logical vs. physical row? Batching is useful for reducing round trips to the server. On 07/18/2012 06:18 AM, Leonid Ilyevsky wrote: I have a question about efficiency of

0.8 -- 1.1 Upgrade: Any Issues?

2012-07-19 Thread Chris Navta
Hello All, We currently have a 0.8 production cluster that I would like to upgrade to 1.1. Are there any know compatibility or upgrade issues between 0.8 and 1.1? Can a rolling upgrade be done or is it all-or-nothing? Thanks! -Chris

Re: 0.8 -- 1.1 Upgrade: Any Issues?

2012-07-19 Thread Peter Schuller
We currently have a 0.8 production cluster that I would like to upgrade to 1.1. Are there any know compatibility or upgrade issues between 0.8 and 1.1? Can a rolling upgrade be done or is it all-or-nothing? If you have lots of keys: https://issues.apache.org/jira/browse/CASSANDRA-3820 -- /

Re: Cassandra Evaluation/ Benchmarking: Throughput not scaling as expected neither latency showing good numbers

2012-07-19 Thread aaron morton
Three node cluster with replication factor of 3 gets me around 10 ms 100% writes with consistency equal to ONE. The reads are really bad and they are around 65ms. Using CL ONE in that situation, with a test that runs in a tight loop, can result in the clients overloading the cluster.

Re: Can't change replication factor in Cassandra 1.1.2

2012-07-19 Thread aaron morton
Check the logs server to see if any errors are reported. If possible can you change the logging to DEBUG and run it ? Note that the UUID did not change, Sounds fishy. There is an issue fixed in 1.1.3 similar to this https://issues.apache.org/jira/browse/CASSANDRA-4432 But I doubt it applies

Compaction not remove the deleted data from secondary index when use TTL

2012-07-19 Thread Jason Tang
Hi For some consistency problem, we can not use delete direct to delete one row, and then we use TTL for each column of the row. We using the Cassandra as the central storage of the stateful system. All request will be stored in Cassandra, and marked as status;NEW, and then we change