Re: Alter table gc_grace_seconds

On Sun, Oct 1, 2017 at 4:14 PM, Gábor Auth wrote: > Hi, > > On Sun, Oct 1, 2017 at 3:44 PM Varun Barala > wrote: > >> This is the property of table and It's not written in sstables. If you >> change gc_grace, It'll get applied for all the data. >> > > Hm... I've migrated lot of data from `number

Re: Migrating a Limit/Offset Pagination and Sorting to Cassandra

Without knowing other details, of course, have you considered using something like Elassandra? That is a pretty tightly integrated Cassandra + Elastic Search solution. You’d insert data into Cassandra like you do normally, then query it with Elastic Search. Of course this would increase the

Re:

On Sun, Oct 1, 2017 at 6:14 PM, Bill Walters wrote: > Hi All, > > I need some help with deploying a monitoring and alerting system for our > new Cassandra 3.0.4 cluster that we are setting up in AWS East region. > I have a good experience with Cassandra as we are running some 2.0.16 > clusters in

Re: Migrating a Limit/Offset Pagination and Sorting to Cassandra

Thanks Kurt, I thought about that but one issue is that we are doing limit/offset not pages. So one customer can choose to page through the list in 10 Item increments, another might want to page through with 100 elements per page. So I can't have a clustering key that represents a page range. What

Re: CREATE INDEX without IF NOT EXISTS when snapshoting

Certainly would make sense and should be trivial. here is where you want to look. Just create a ticket for it and prod here for a reviewer once

Re: What is performance gain of clustering columns

Clustering info is stored in the index of an SSTable, so if you are only querying a subset of rows within the partition you don't necessarily have to hit all SSTables, just the SSTables that contain the relevant clustering col's. They make a big improvement, and can also be used quite effectively i

CREATE INDEX without IF NOT EXISTS when snapshoting

Hi everyone, I came across something that bothers me a lot. I'm using snapshots to backup data from my Cassandra cluster in case something really bad happens (like dropping a table or a keyspace). Exercising the recovery actions from those backups, I discover that the schema put on the file "sche

Re: Read-/ Write Latency - Cassandra 2.1 .15 vs 3.10

RecentReadLatency metrics has been deprecated for years (1.1 or 1.2) and were removed in 2.2. It was a very misleading metric. Instead pull from the Table's ReadLatency metrics from the org.apache.cassandra.metrics domain. http://cassandra.apache.org/doc/latest/operating/metrics.html?highlight=m

Re: How do I install Cassandra on AWS

Thank You Michael https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon"; target="_blank">https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif"; alt="" width="46" height=

What is performance gain of clustering columns

Hi, Clustering columns are used to order the data in a partition. However, since data is split into SSTables, the rows are ordered by clustering key only within each SSTable. Cassandra still needs to check all SSTables, and merge the data if it is found in several SSTables. The only scanario where

Read-/ Write Latency - Cassandra 2.1 .15 vs 3.10

Hi, We were running splunk queries to pull read / write latency. It's working fine in 2.1.15 , but not returning result from upgraded version 3.10. The bean used in the script is as shown below. Let me know, if any changes on the functionality on 2.1.15 vs 3.10 or it replaced to some other bea

Re: cassandra hardware requirements (STAT/SSD)

Hello, It's a bit old but at least for me, still a great guide: https://tobert.github.io/pages/als-cassandra-21-tuning-guide.html My 2 cents: We deal with electronic invoices and our load is about 10,000 transactions/s during the peak housr. We are not located in USA, so AWS would be a bit expen

Re: How do I install Cassandra on AWS

How to EC2: https://aws.amazon.com/ec2/getting-started/ After "Step 4: Connect to your instance", then install Cassandra as in the steps on the download page. If you're looking for details on instance configuration and cluster strategy, a quick search of "ec2 cassandra" found me the AWS whitep

Re: How do I install Cassandra on AWS

http://lmgtfy.com/?q=how+to+install+cassandra+on+aws On 10/03/2017 05:28 AM, Lutaya Shafiq Holmes wrote: How do I install Cassandra on AWS- Amazon web services The instructions are not listed there On 10/2/17, Michael Shuler wrote: On 10/02/2017 10:53 AM, Lutaya Shafiq Holmes wrote: How

Re: How do I install Cassandra on AWS

How do I install Cassandra on AWS- Amazon web services The instructions are not listed there On 10/2/17, Michael Shuler wrote: > On 10/02/2017 10:53 AM, Lutaya Shafiq Holmes wrote: >> >> How do I install Cassandra on AWS- Amazon web services > > Follow the installation instructions on the follo

Re: Migrating a Limit/Offset Pagination and Sorting to Cassandra

I get the impression that you are paging through a single partition in Cassandra? If so you should probably use bounds on clustering keys to get your "next page". You could use LIMIT as well here but it's mostly unnecessary. Probably just use the pagesize that you intend for the API. Yes you'll ne

Migrating a Limit/Offset Pagination and Sorting to Cassandra

Hi, I am currently working on migrating a service that so far was MySQL based to Cassandra. Everything seems to work fine so far, but a few things in the old services API Spec is posing some interesting data modeling challenges: The old service was doing Limit/Offset pagination which is obviously