Re: EC2 storage options for C*

How about reads? Any differences between read-intensive and write-intensive workloads? -- Jack Krupansky On Sun, Jan 31, 2016 at 3:13 AM, Jeff Jirsa wrote: > Hi John, > > We run using 4T GP2 volumes, which guarantee 10k iops. Even at 1M writes > per second on 60

Re: EC2 storage options for C*

Also in that video - it's long but worth watching We tested up to 1M reads/second as well, blowing out page cache to ensure we weren't "just" reading from memory -- Jeff Jirsa > On Jan 31, 2016, at 9:52 AM, Jack Krupansky wrote: > > How about reads? Any

Re: EC2 storage options for C*

http://m.theregister.co.uk/2013/08/26/amazon_ebs_cloud_problems/ That's what I'm worried about. Granted that's an article from 2013, and While the the general purpose EBS volumes are performant for a production C* workload, I'm worried about EBS outages. If EBS is down, my cluster is down. On

Re: EC2 storage options for C*

Yes, but getting at why you think EBS is going down is the real point. New GM in 2011. Very different product. 35:40 in the video -- Jeff Jirsa > On Jan 31, 2016, at 9:57 PM, Eric Plowe wrote: > > Jeff, > > If EBS goes down, then EBS Gp2 will go down as well, no? I'm

Re: EC2 storage options for C*

Jeff, If EBS goes down, then EBS Gp2 will go down as well, no? I'm not discounting EBS, but prior outages are worrisome. On Sunday, January 31, 2016, Jeff Jirsa wrote: > Free to choose what you'd like, but EBS outages were also addressed in > that video (second

Can't select count(*)

Hi all! I have a table with simple primary key (one field on primary key only), and ~1 million records. Table stored on single-node C* 2.2.4. Problem: when I'm trying to execute "SELECT count(*) FROM my_table;", operation is timed out. As I understand, 1 mln rows is not so big dataset to use

Re: EC2 storage options for C*

Thank you all for the suggestions. I'm torn between GP2 vs Ephemeral. GP2 after testing is a viable contender for our workload. The only worry I have is EBS outages, which have happened. On Sunday, January 31, 2016, Jeff Jirsa wrote: > Also in that video - it's long

Re: EC2 storage options for C*

Free to choose what you'd like, but EBS outages were also addressed in that video (second half, discussion by Dennis Opacki). 2016 EBS isn't the same as 2011 EBS. -- Jeff Jirsa > On Jan 31, 2016, at 8:27 PM, Eric Plowe wrote: > > Thank you all for the suggestions.

Re: EC2 storage options for C*

Hi John, We run using 4T GP2 volumes, which guarantee 10k iops. Even at 1M writes per second on 60 nodes, we didn’t come close to hitting even 50% utilization (10k is more than enough for most workloads). PIOPS is not necessary. From: John Wong Reply-To: "user@cassandra.apache.org" Date: