Re: Compaction Strategy guidance

2014-11-23 Thread Andrei Ivanov
Stephane, We are having a somewhat similar C* load profile. Hence some comments in addition Nikolai's answer. 1. Fallback to STCS - you can disable it actually 2. Based on our experience, if you have a lot of data per node, LCS may work just fine. That is, till the moment you decide to join anothe

RE: A questiion to adding a new data center

2014-11-23 Thread Lu, Boying
This is what I want to know. Thanks a lot ☺ From: Mark Reddy [mailto:mark.l.re...@gmail.com] Sent: 2014年11月21日 18:07 To: user@cassandra.apache.org Subject: Re: A questiion to adding a new data center Hi Boying, I'm not sure I fully understand your question here, so some clarification may be ne

Getting the counters with the highest values

2014-11-23 Thread Robert Wille
I’m working on moving a bunch of counters out of our relational database to Cassandra. For the most part, Cassandra is a very nice fit, except for one feature on our website. We manage a time series of view counts for each document, and display a list of the most popular documents in the last se

Re: Compaction Strategy guidance

2014-11-23 Thread Nikolai Grigoriev
Just to clarify - when I was talking about the large amount of data I really meant large amount of data per node in a single CF (table). LCS does not seem to like it when it gets thousands of sstables (makes 4-5 levels). When bootstraping a new node you'd better enable that option from CASSANDRA-6

Re: Compaction Strategy guidance

2014-11-23 Thread Jean-Armel Luce
Hi Nikolai, Thanks for those informations. Please could you clarify a little bit what you call " 2014-11-24 4:37 GMT+01:00 Nikolai Grigoriev : > Just to clarify - when I was talking about the large amount of data I > really meant large amount of data per node in a single CF (table). LCS does >

Re: Compaction Strategy guidance

2014-11-23 Thread Jean-Armel Luce
Hi Nikolai, Please could you clarify a little bit what you call "a large amount of data" ? How many tables ? How many rows in your largest table ? How many GB in your largest table ? How many GB per node ? Thanks. 2014-11-24 8:27 GMT+01:00 Jean-Armel Luce : > Hi Nikolai, > > Thanks for those

Re: Compaction Strategy guidance

2014-11-23 Thread Andrei Ivanov
Jean-Armel, I have the same problem/state as Nikolai. Here are my stats: ~ 1 table ~ 10B records ~ 2TB/node x 6 nodes Nikolai, I'm sort of wondering if switching to some larger sstable_size_in_mb (say 4096 or 8192 or something) with LCS may be a solution, even if not absolutely permanent? As for