Re: Missing rows while scanning table using java driver

2016-02-03 Thread priyanka gugale
Thanks for all help. The problem was, my application was starting read process as soon as write is over. I guess due to eventual consistency of write in cassandra reader was missing records as they were still in process of writing. I will be using paging feature for processing than what I was doin

Re: EC2 storage options for C*

2016-02-03 Thread Jack Krupansky
I meant to reply earlier that the current DataStax doc on EC2 is actually reasonably decent. It says this about EBS: "SSD-backed general purpose volumes (GP2) or provisioned IOPS volumes (PIOPS) are suitable for production workloads." with the caveat of: "EBS magnetic volumes are not recommended

Re: EC2 storage options for C*

2016-02-03 Thread Jeff Jirsa
I don’t want to be “that guy”, but there’s literally almost a dozen emails in this thread answering exactly that question. Did you read the thread to which you replied? From: James Rothering Reply-To: "user@cassandra.apache.org" Date: Wednesday, February 3, 2016 at 4:09 PM To: "user@cassan

Re: EC2 storage options for C*

2016-02-03 Thread Sebastian Estevez
By the way, if someone wants to do some hard core testing like Al, I wrote a guide on how to use his tool: http://www.sestevez.com/how-to-use-toberts-effio/ I'm sure folks on this list would like to see more stats : ) All the best, [image: datastax_logo.png] Sebasti

Re: EC2 storage options for C*

2016-02-03 Thread Sebastian Estevez
Good points Bryan, some more color: Regular EBS is *not* okay for C*. But AWS has some nicer EBS now that has performed okay recently: http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/EBSVolumeTypes.html https://www.youtube.com/watch?v=1R-mgOcOSd4 The cloud vendors are moving toward shared s

Re: EC2 storage options for C*

2016-02-03 Thread Bryan Cheng
>From my experience, EBS has transitioned from "stay the hell away" to "OK" as the new GP2 SSD type has come out and stabilized over the last few years, especially with the addition of EBS-optimized instances that have dedicated EBS bandwidth. The latter has really helped to stabilize the problemat

Re: Any tips on how to track down why Cassandra won't cluster?

2016-02-03 Thread Bryan Cheng
> On Wed, 3 Feb 2016 at 11:49 Richard L. Burton III > wrote: > >> >> Any suggestions on how to track down what might trigger this problem? I'm >> not receiving any exceptions. >> > You're not getting "Unable to gossip with any seeds" on the second node? What does nodetool status show on both machi

Re: EC2 storage options for C*

2016-02-03 Thread James Rothering
Just curious here ... when did EBS become OK for C*? Didn't they always push towards using ephemeral disks? On Wed, Feb 3, 2016 at 12:17 PM, Ben Bromhead wrote: > For what it's worth we've tried d2 instances and they encourage terrible > things like super dense nodes (increases your replacement

Re: EC2 storage options for C*

2016-02-03 Thread Will Hayworth
We're using GP2 EBS (3 TB volumes) with m4.xlarges after originally looking at I2 and D2 instances (thanks, Jeff, for your advice with that one). So far, so good. (Our workload is write-heavy at the moment but reads are steadily increasing.)

Re: Re : Possibility of using 2 different snitches in the Multi_DC cluster

2016-02-03 Thread Will Hayworth
Ec2MultiRegionSnitch does remove a bit of complexity for us, speaking as someone who runs a small cluster that serves one system. It doesn't sound like the right solution for you, though. ___ Will Hayworth Developer, Engagement Engine My pron

Re: EC2 storage options for C*

2016-02-03 Thread Ben Bromhead
For what it's worth we've tried d2 instances and they encourage terrible things like super dense nodes (increases your replacement time). In terms of useable storage I would go with gp2 EBS on a m4 based instance. On Mon, 1 Feb 2016 at 14:25 Jack Krupansky wrote: > Ah, yes, the good old days of

Re: Any tips on how to track down why Cassandra won't cluster?

2016-02-03 Thread Ben Bromhead
Check network connectivity. If you are using public addresses as the broadcast, make sure you can telnet from one node to the other nodes public address using the internode port. Last time I looked into something like this, for some reason if you only add a security group id to the allowed traffic

Re: Re : Possibility of using 2 different snitches in the Multi_DC cluster

2016-02-03 Thread Ben Bromhead
Also you may want to run multiple data centres in the one AWS region (load segmentation, spark etc). +1 GPFS for everything On Wed, 3 Feb 2016 at 07:42 sai krishnam raju potturi wrote: > thanks a lot Robert. Greatly appreciate it. > > thanks > Sai > > On Tue, Feb 2, 2016 at 6:19 PM, Robert Coli

Any tips on how to track down why Cassandra won't cluster?

2016-02-03 Thread Richard L. Burton III
I'm deploying 2 nodes at the moment using cassandra-dse on Amazon. I configured it to use EC2Snitch and configured rackdc to use us-east with rack "1". The second node points to the first node as the seed e.g., "seeds": ["54.*.*.*"] and all of the ports are open. Any suggestions on how to track d

Re: Re : Possibility of using 2 different snitches in the Multi_DC cluster

2016-02-03 Thread sai krishnam raju potturi
thanks a lot Robert. Greatly appreciate it. thanks Sai On Tue, Feb 2, 2016 at 6:19 PM, Robert Coli wrote: > On Tue, Feb 2, 2016 at 1:23 PM, sai krishnam raju potturi < > pskraj...@gmail.com> wrote: > >> What is the possibility of using GossipingPropertFileSnitch on >> datacenters in our private

Re: Missing rows while scanning table using java driver

2016-02-03 Thread Jack Krupansky
CL=ALL has no benefit is RF=1. Your code snippet doesn't indicate how you initialize and update the token in the query. The ">" operator would assure that you skip the first token. -- Jack Krupansky On Wed, Feb 3, 2016 at 1:36 AM, Priyanka Gugale wrote: > Hi, > > I am using Cassandra 2.2.0 and

RE: automated CREATE TABLE just nuked my cluster after a 2.0 -> 2.1 upgrade....

2016-02-03 Thread Jacques-Henri Berthemet
You will have the same problem without IF NOT EXIST, at least I had Cassandra 2.1 complaining about having tables with the same name but different UUIDs. In the end in our case we have a single application node that is responsible for schema upgrades, that’s ok for us as we don’t plan to have th