Our experience is that you want to have all your very hot data fit in the row
cache (assuming you don’t have very large rows), and leave the rest for the OS.
Unfortunately, it completely depends on your access patterns and data what is
the right size for the cache - zero makes sense for a lot
What would the consequence be of having this updated highscore table (using
friendId as part of the clustering index to avoid name collisions):
CREATE TABLE highscore (
userId uuid,
score int,
friendId uuid,
name varchar,
PRIMARY KEY(userId, score, friendId)
) WITH CLUSTERING ORDER BY (s
Most of the work I've done like this has used sparse table definitions and
the empty column trick. I didn't explain that very well in my last
response.
I think by using the userid as the rowid, and using the friend id as the
column name with the score, that I would put an entire user's friend lis
One of tricks I've used a lot with cassandra is a sparse df definition and
inserted columns programmatically that weren't in the definition.
I'd be tempted to look at putting a users friend list on one row, the row
would look like this:
ROWIDCOLUMNS
UserID UserId, UserID, UserSco
We are seeing a weird issue with our Cassandra cluster(version
1.0.10). We have 6 nodes(DC1:3, DC2:3) in our cluster. So all 6 nodes
are replicas of each other. All reads and writes are LOCAL_QOURUM. We
see that when one of the node in DC1 fails, we see timeout errors on th
I am unable to find any references on if the tabs to monitor multiple
DC can be configure to read the DC location. I do not want to change the
cluster name itself. Right now I see three tabs all with the same names
"cluster_name: test." Like to keep the current cluster name "test",
but cha
My experience has been that the row cache is much more effective.
However, reasonable row cache sizes are so small relative to RAM that I
don't see it as a significant trade-off unless it's in a very memory
constrained environment. If you want to enable the row cache (a big if)
you probably wa
Multiple DCs are still a single cluster in OpsCenter. If you go to
Physical View, you should see one column for each data center.
Also, the Community edition of OpsCenter, last I saw, only supported a
single cluster.
On Thu, Jan 23, 2014 at 12:06 PM, Daniel Curry wrote:
> I am unable to fin
On Wed, Jan 22, 2014 at 11:13 PM, Katriel Traum wrote:
> I was if anyone has any pointers or some advise regarding using row cache
> vs leaving it up to the OS buffer cache.
>
> I run cassandra 1.1 and 1.2 with JNA, so off-heap row cache is an option.
>
Many people have had bad experiences with
On Thu, Jan 23, 2014 at 8:52 AM, Ankit Patel wrote:
> We are seeing a weird issue with our Cassandra cluster(version 1.0.10).
> We have 6 nodes(DC1:3, DC2:3) in our cluster. So all 6 nodes are replicas
> of each other. All reads and writes are LOCAL_QOURUM.
>
Frankly I'm surprised that 1.0.10 i
Alternatively you can use clustering columns to store very big collections.
Beware of not making a row too wide though (use bucketing)
Le 23 janv. 2014 04:29, "Manoj Khangaonkar" a écrit
:
> Thanks. I guess I can work around by maintaining hour_counts (which will
> have fewer items) and adding t
A vaguely related question...my OpsCenter now has two separate tabs for the
same cluster...one tab shows all six nodes and has their agents...the other
tab has the same six nodes but no agents.
I see no way to get rid of the spurious tab.
On Thu, Jan 23, 2014 at 12:47 PM, Ken Hancock wrote:
> M
Thank you everyone for your input.
My dataset is ~100G of size with 1 or 2 read intensive column families. The
cluster has plenty of RAM. I'll start off small with 4G of row cache and
monitor the success rate.
Katriel
On Thu, Jan 23, 2014 at 9:17 PM, Robert Coli wrote:
> On Wed, Jan 22, 2014 a
On Tue, Jan 21, 2014 at 7:16 AM, Tupshin Harper wrote:
> This should be the doc you are looking for.
>
>
> http://www.datastax.com/documentation/cassandra/2.0/webhelp/index.html#cassandra/operations/ops_add_dc_to_cluster_t.html
>
Rebuild (like bootstrap) only streams data from a single source re
Thanks a lot :)
From: Robert Coli [mailto:rc...@eventbrite.com]
Sent: 2014年1月24日 4:54
To: user@cassandra.apache.org
Subject: Re: How to add a new DC to cluster in Cassandra 2.x
On Tue, Jan 21, 2014 at 7:16 AM, Tupshin Harper
mailto:tups...@tupshin.com>> wrote:
This should be the doc you are loo
Hi Joel,
One simple above log record will not help. Please provide the entire
command line the process is started with including JVM options, the log
file showing all GC messages..
Is it possible for you to collect VerboseGC, which would print the before
and after statistics of the memory.
Vers
16 matches
Mail list logo
