Re: decommission dead node without token

2014-06-01 Thread Jens Rantil
You might need double backslashes in bash.— Sent from Mailbox On Sun, Jun 1, 2014 at 6:42 AM, Tim Dunphy wrote: >> >> backslash it \-9485547484 >> just guessing. > Oh, worth a shot! But I'm heading to bed now. I'll try again with this > tomorrow. > cya > Tim > On Sun, Jun 1, 2014 at 12:39 AM, S

Batched statements two different cassandra clusters.

2014-06-01 Thread Kevin Burton
As far as I understand, this is impossible. There isn't a way to figure out which statement goes to which cluster. We are going to have two different clusters because the hardware config is slightly different and so is our caching strategy. A plan B could be to write to both commits to something

Tune cache MB settings per table.

2014-06-01 Thread Kevin Burton
It's possible to set caching to: all, keys_only, rows_only, or none .. for a given table. But we have one table which is MASSIVE and we only need the most recent 4-8 hours in memory. Anything older than that can go to disk as the queries there are very rare. … but I don't think cassandra can d

Re: Batched statements two different cassandra clusters.

2014-06-01 Thread Colin
Set it up as one cluster with multiple datacenters and configure replication accordingly. -- Colin Clark +1-320-221-9531 > On Jun 1, 2014, at 2:43 PM, Kevin Burton wrote: > > As far as I understand, this is impossible. > > There isn't a way to figure out which statement goes to which clust

Re: Tune cache MB settings per table.

2014-06-01 Thread Colin
The OS should handle this really well as long as your on v3 linux kernel -- Colin Clark +1-320-221-9531 > On Jun 1, 2014, at 2:49 PM, Kevin Burton wrote: > > It's possible to set caching to: > > all, keys_only, rows_only, or none > > .. for a given table. > > But we have one table w

Re: Tune cache MB settings per table.

2014-06-01 Thread DuyHai Doan
Hello Kevin You'll be probably interested by this : http://www.datastax.com/dev/blog/row-caching-in-cassandra-2-1 On Sun, Jun 1, 2014 at 9:49 PM, Kevin Burton wrote: > It's possible to set caching to: > > all, keys_only, rows_only, or none > > .. for a given table. > > But we have one table w

Re: I have a deaf node?

2014-06-01 Thread Kevin Burton
could be worse… it could be under caffeinated and say decafbad … On Sat, May 31, 2014 at 10:45 AM, Tim Dunphy wrote: > I think the "deaf" thing is just the ending of the host ID in hexadecimal. >> It's an extraordinary coincidence that it ends with DEAF :D > > > Hah.. yeah that thought did cros

Re: Tune cache MB settings per table.

2014-06-01 Thread Kevin Burton
Not in our experience… We've been using fadvise don't need to purge pages that aren't necessary any longer. Of course YMMV based on your usage. I tend to like to control everything explicitly instead of having magic. That's worked out very well for us in the past so it would be nice to still hav

Re: Tune cache MB settings per table.

2014-06-01 Thread Colin
Have you been unable to achieve your SLA's using Cassandra out of the box so far? Based upon my experience, trying to tune Cassandra before the app is done and without simulating real world load patterns, you might actually be doing yourself a disservice. -- Colin 320-221-9531 > On Jun 1, 20

Re: Tune cache MB settings per table.

2014-06-01 Thread Jonathan Haddad
I think of all the areas you could spend your time, this will have the least returns. The OS will keep the most frequently used data in memory. There's no reason to require cassandra to do it. If you're curious as to what's been loaded into ram, try Al Tobey's pcstat utility. https://github.com

Re: Tune cache MB settings per table.

2014-06-01 Thread Kevin Burton
Good question. still migrating.. but we don't want to paint ourselves into a corner. There's an interesting line between premature optimization and painting yourself into a corner ;) Best to get it right in between both extremes. On Sun, Jun 1, 2014 at 4:30 PM, Colin wrote: > Have you been un

Re: Tune cache MB settings per table.

2014-06-01 Thread Colin
Your data model will most likely be the far most important component of your migration. Get that right, and the rest is easy. -- Colin Clark +1-320-221-9531 > On Jun 1, 2014, at 7:01 PM, Kevin Burton wrote: > > Good question. still migrating.. but we don't want to paint ourselves into a >

Re: I have a deaf node?

2014-06-01 Thread Apostolis Xekoukoulotakis
That made my day. Not to worry thought unless you start seeing the number 23 in your host ids. On Jun 2, 2014 12:40 AM, "Kevin Burton" wrote: > could be worse… it could be under caffeinated and say decafbad … > > > On Sat, May 31, 2014 at 10:45 AM, Tim Dunphy wrote: > >> I think the "deaf" thin

Re: I have a deaf node?

2014-06-01 Thread Tim Dunphy
> > That made my day. Not to worry thought unless you start seeing the number > 23 in your host ids. Yeah man, glad to provide some comic relief to the list! ;) On Sun, Jun 1, 2014 at 11:01 PM, Apostolis Xekoukoulotakis < xekou...@gmail.com> wrote: > That made my day. Not to worry thought unl

Re: I have a deaf node?

2014-06-01 Thread Paulo Ricardo Motta Gomes
This post should definitely make to the hall of fame!! :) On Mon, Jun 2, 2014 at 12:05 AM, Tim Dunphy wrote: > That made my day. Not to worry thought unless you start seeing the number >> 23 in your host ids. > > > Yeah man, glad to provide some comic relief to the list! ;) > > > On Sun, Jun 1

Re: I have a deaf node?

2014-06-01 Thread Tim Dunphy
> > This post should definitely make to the hall of fame!! :) My proudest accomplishment on the list. heh On Sun, Jun 1, 2014 at 11:24 PM, Paulo Ricardo Motta Gomes < paulo.mo...@chaordicsystems.com> wrote: > This post should definitely make to the hall of fame!! :) > > > On Mon, Jun 2, 2014 a

Re: I have a deaf node?

2014-06-01 Thread David Daeschler
I wouldnt worry unless it changes from deaf to deadbeef On Sun, Jun 1, 2014 at 11:34 PM, Tim Dunphy wrote: > This post should definitely make to the hall of fame!! :) > > > My proudest accomplishment on the list. heh > > > On Sun, Jun 1, 2014 at 11:24 PM, Paulo Ricardo Motta Gomes < > paulo.mo.