Re: Time series data and deletion

2013-03-11 Thread Flavio Baronti
Il 2013/03/11 14:42 PM, aaron morton ha scritto: I'm trying to understand what will happen when we start deleting the old data. Are you going to delete data or use the TTL? We delete the data explicitly, since we might change idea on the data TTL after it has been written. With size tiered

Time series data and deletion

2013-03-08 Thread Flavio Baronti
Hello, we are using Cassandra for storing time series data. We never update, only append; we plan to store 1 year worth of data, occupying something around 200Gb. I'm trying to understand what will happen when we start deleting the old data. With size tiered compaction, suppose we have one

Re: 1000's of column families

2012-09-28 Thread Flavio Baronti
We had some serious trouble with dynamically adding CFs, although last time we tried we were using version 0.7, so maybe that's not an issue any more. Our problems were two: - You are (were?) not supposed to add CFs concurrently. Since we had more servers talking to the same Cassandra cluster,

Tiered compation on two disks

2012-06-21 Thread Flavio Baronti
Hi, I have a Cassandra installation where we plan to store 1Tb of data, split between two 1Tb disks. Tiered compation should be better suited for our workload (append-only, deletion of old data, few reads). I know that tiered compaction needs 50% free disk space for worst case situation. How

Re: Starting cassandra with -D option

2012-06-21 Thread Flavio Baronti
The option must actually include also the name of the yaml file: Dcassandra.config=file:///Users/walmart/Downloads/Cassandra/Node2-Cassandra1.1.0/conf/cassandra.yaml Flavio Il 6/21/2012 13:16 PM, Roshni Rajagopal ha scritto: Hi Folks, We wanted to have a single cassandra installation,

Re: JMX APIs thru MX4J

2012-04-04 Thread Flavio Baronti
Hi, I can't help you with your other questions, but the type [Ljava.lang.String; is an array of String objects. More info here http://en.wikipedia.org/wiki/Java_Native_Interface#Mapping_types Flavio Il 4/4/2012 10:04 AM, Andrea Tuccia ha scritto: Hello, I'm working on a fork of Sébastien

List all keys with RandomPartitioner

2012-02-22 Thread Flavio Baronti
I need to iterate over all the rows in a column family stored with RandomPartitioner. When I reach the end of a key slice, I need to find the token of the last key in order to ask for the next slice. I saw in an old email that the token for a specific key can be recoveder through

Re: List all keys with RandomPartitioner

2012-02-22 Thread Flavio Baronti
Il 2/22/2012 12:24 PM, Franc Carter ha scritto: On Wed, Feb 22, 2012 at 8:47 PM, Flavio Baronti f.baro...@list-group.com mailto:f.baro...@list-group.com wrote: I need to iterate over all the rows in a column family stored with RandomPartitioner. When I reach the end of a key slice, I

Re: Second Cassandra users survey

2011-11-07 Thread Flavio Baronti
We are using Cassandra for time series storage. Strong points: write performance. Pain points: dinamically adding column families as new time series come in. Caused a lot of headaches, mismatchers between nodes, etc. In the end we just put everything together in a single (huge) column family.

ConsistencyLevel and write availability

2011-05-31 Thread Flavio Baronti
Suppose i have a cluster with 10 nodes and RF=5. Will every write succeed if one or two of my nodes are down, and I use ConsistencyLevel=ALL? Or will some of the writes fail?

OOM recovering failed node with many CFs

2011-05-26 Thread Flavio Baronti
I can't seem to be able to recover a failed node on a database where i did many updates to the schema. I have a small cluster with 2 nodes, around 1000 CF (I know it's a lot, but it can't be changed right now), and ReplicationFactor=2. I shut down a node and cleaned its data entirely, then

Re: OOM recovering failed node with many CFs

2011-05-26 Thread Flavio Baronti
? As a workaround, I would try manually copying the Migrations and Schema sstable files from the system keyspace of the live node, then restart the recovering one. On Thu, May 26, 2011 at 9:27 AM, Flavio Baronti f.baro...@list-group.com wrote: I can't seem to be able to recover a failed node