RE: CQL3 Data Model Question

2013-05-08 Thread Adriano Paggi
At those rates, to avoid hot spots, and maintain rows in a manageable size (~10MB or so), maybe you should partition every 5 or 10 minutes per app_id, so your partition key looks like app_id + MMDDHHmm i.e 1234_201305081300, 1234_201305081305, 1234_201305081310, 1234_201305081315, etc.

Ten talks you shouldn’t miss at the Cassandra Summit

2013-05-08 Thread Jonathan Ellis
The Cassandra Summit is just over a month away! I wrote up my thoughts on the talks I'm most excited for here: http://www.datastax.com/dev/blog/ten-talks-you-shouldnt-miss-at-the-cassandra-summit Don't forget to register with the code SFSummit25 for a 25% discount: http://datastax.regsvc.com/E2

Replica info

2013-05-08 Thread Kanwar Sangha
Is there a way in Cassandra that we can know which node has the replica for the data ? if we have 4 nodes and RF = 2, is there a way we can find which 2 nodes have the same data ? Thanks, Kanwar

Re: Replica info

2013-05-08 Thread Hiller, Dean
nodetool describering {keyspace} From: Kanwar Sangha kan...@mavenir.commailto:kan...@mavenir.com Reply-To: user@cassandra.apache.orgmailto:user@cassandra.apache.org user@cassandra.apache.orgmailto:user@cassandra.apache.org Date: Wednesday, May 8, 2013 3:00 PM To:

Re: Replica info

2013-05-08 Thread Tyler Hobbs
You also might be interested in nodetool getendpoints keyspace cf key, which prints the nodes that are replicas for a given key On Wed, May 8, 2013 at 4:14 PM, Hiller, Dean dean.hil...@nrel.gov wrote: nodetool describering {keyspace} From: Kanwar Sangha

Backup and restore between different node-sized clusters

2013-05-08 Thread Ron Siemens
I have a 3-node cluster in production and a single-node development cluster. I tested snapshotting a column family from the 3-node production cluster, grouping the files together, and restoring onto my single node development system. That worked fine. Can I go the other direction? It's not

Re: Backup and restore between different node-sized clusters

2013-05-08 Thread Jonathan Ellis
You want to use sstableloader when the cluster sizes are different; it will stream things to the right places in the new one. On Wed, May 8, 2013 at 6:03 PM, Ron Siemens rsiem...@greatergood.com wrote: I have a 3-node cluster in production and a single-node development cluster. I tested

Re: index_interval

2013-05-08 Thread Jonathan Ellis
index_interval won't be going away, but you won't need to change it as often in 2.0: https://issues.apache.org/jira/browse/CASSANDRA-5521 On Mon, May 6, 2013 at 12:27 PM, Hiller, Dean dean.hil...@nrel.gov wrote: I heard a rumor that index_interval is going away? What is the replacement for

Cannot resolve schema disagreement

2013-05-08 Thread srmore
Hello, I have a cluster of 4 nodes and two of them are on different schema. I tried to run the commands described in the FAQ section but no luck ( http://wiki.apache.org/cassandra/FAQ#schema_disagreement) . After running the commands, I get back to the same issue. Cannot afford to lose the data

Re: Replica info

2013-05-08 Thread Edward Capriolo
http://www.datastax.com/docs/1.1/references/nodetool#nodetool-getendpoints This tells you where a key lives. (you need to hex encode the key) On Wed, May 8, 2013 at 5:14 PM, Hiller, Dean dean.hil...@nrel.gov wrote: nodetool describering {keyspace} From: Kanwar Sangha

RE: HintedHandoff

2013-05-08 Thread Kanwar Sangha
Is this correct guys ? From: Kanwar Sangha [mailto:kan...@mavenir.com] Sent: 07 May 2013 14:07 To: user@cassandra.apache.org Subject: HintedHandoff Hi -I had a question on hinted-handoff. We have 2 DCs configured with overall RF = 2 (DC1:1, DC2:1) and 4 nodes in each DC (total - 8 nodes

Sudden increase in diskspace usage

2013-05-08 Thread Nicolai Gylling
Hi I have a 3-node SSD-based cluster, with around 1 TB data, RF:3, C* v.1.2.0, vnodes. One large CF, LCS. Everything was running smooth, until one of the nodes crashed and was restarted. At the time of normal operation there was 800 gb free space on each node. After the crash, C* started using a