Ldap/AD Authentication

Hi All, Do we have any open source ldap/AD pkgs/software for caasandra? I see instacluster has some but seems thats paid one.

Cassandra 4.0 upgrade from Cassandra 3x

Hi apart from standard upgrade process any thing specific needs ti be handled separately for this upgrade process? Any changes needed at client side w.r.t drivers?

Log4j vulnerability

Hi all, Any idea if any of open source Cassandra versions are impacted with log4j vulnerability which was reported on dec 9th

Re: High disk usage casaandra 3.11.7

Twcs is best for TTL not for excipilitly delete correct? On Friday, September 17, 2021, Abdul Patel wrote: > 48hrs deletion is deleting older data more than 48hrs . > LCS was used as its more of an write once and read many application. > > On Friday, September 17, 2021, Bowen

Re: High disk usage casaandra 3.11.7

serted? If so, are you sure LCS is the > right compaction strategy for this table? TWCS sounds like a much better > fit for this purpose. > On 17/09/2021 19:16, Abdul Patel wrote: > > Thanks. > Application deletes data every 48hrs of older data. > Auto compaction works but as sp

Re: High disk usage casaandra 3.11.7

sual? Also, do you know the application logic? Does it do a lots of > delete or update (including 'upsert')? Writes with TTL? Does the table has > a default TTL? > > On 17/09/2021 13:45, Abdul Patel wrote: > > Close 300 gb data. Nodetool decommission/removenode and added back o

Re: High disk usage casaandra 3.11.7

e table. Also, try major compaction, it's a lot easier than > replacing a node. > > > On 17/09/2021 12:28, Abdul Patel wrote: > > Yes i checked and cleared all snapshots and also i had incremental backups > in backup folder ..i removed the same .. its purely data.. > > >

Re: High disk usage casaandra 3.11.7

t; > On 17/09/2021 05:48, Abdul Patel wrote: > >> Hello >> >> We have cassandra with leveledcompaction strategy, recently found >> filesystem almost 90% full but the data was only 10m records. >> Manual compaction will work? As not sure its recommended and space is >

High disk usage casaandra 3.11.7

Hello We have cassandra with leveledcompaction strategy, recently found filesystem almost 90% full but the data was only 10m records. Manual compaction will work? As not sure its recommended and space is also constraint ..tried removing and adding one node and now data is at 20GB which looks

Re: [RELEASE] Apache Cassandra 4.0-rc2 released

no issues found, this will turn into the GA > release. > > Patrick > > On Wed, Jun 30, 2021 at 1:09 PM Abdul Patel wrote: > >> Great news!! >> Is this production ready? >> >> On Wed, Jun 30, 2021, 3:56 PM Patrick McFadin wrote: >> >>> Congr

Re: [RELEASE] Apache Cassandra 4.0-rc2 released

Great news!! Is this production ready? On Wed, Jun 30, 2021, 3:56 PM Patrick McFadin wrote: > Congrats to everyone that worked on this iteration. If you haven't looked > at the CHANGES.txt there were some great catches in RC1. Just like it > should happen! > > On Wed, Jun 30, 2021 at 12:29 PM

Encryption at rest

Team, Do we have option in open source to do encryption at rest in cassandra ?

Re: Running select against cassandra

nt to request. So I’d say yes, if a materialized view is how > you want to achieve a denormalized state where the query model directly > supports giving you want you want to query for, that sounds like an > appropriate option to consider. You might want a composite partition key >

Re: [EXTERNAL] Re: Running select against cassandra

f your reporting requires > different granularities, you could consider a different time bucket for the > table (by hour, by week, etc.) > > > > > > Sean Durity – Staff Systems Engineer, Cassandra > > > > *From:* Abdul Patel > *Sent:* Thursday, February 6, 20

Re: Running select against cassandra

Also is materialized view good for production? We are on 3.11.4 On Thursday, February 6, 2020, Abdul Patel wrote: > Its sort of user connected, app team needa number of active users > connected say every 1 to 5 mins. > The timeout at app end is 120ms. > > > > On Thurs

Re: Running select against cassandra

our data model. > > 1 query per minute is a minuscule fraction of the basic capacity of > queries per minute that a Cassandra cluster should be able to handle with > good data modeling and table-relevant query. All depends on the data model > and query. > > Michael > >

Running select against cassandra

Hi, Is it advisable to run select query to fetch every minute to grab data from cassandra for reporting purpose, if no then whats the alternative?

Re: Cassandra 4 alpha/alpha2

images for my own purposes). > > Update between alpha and alpha2 was just about mere version bump. > > Cheers > > On Thu, 31 Oct 2019 at 20:40, Abdul Patel wrote: > > > > Hey Everyone > > > > Did anyone was successfull to install either alpha or al

Re: Cassandra 4 alpha/alpha2

Centos 7.6 On Thursday, October 31, 2019, Jon Haddad wrote: > What artifact did you use and what OS are you on? > > On Thu, Oct 31, 2019 at 12:40 PM Abdul Patel wrote: > >> Hey Everyone >> >> Did anyone was successfull to install either alpha or alpha2 version fo

Cassandra 4 alpha/alpha2

Hey Everyone Did anyone was successfull to install either alpha or alpha2 version for cassandra 4.0? Found 2 issues : 1> cassandra-env.sh: JAVA_VERSION varianle is not defined. Jvm-server.options file is not defined. This is fixable and after adding those , the error for cassandra-env.sh errora

Re: [RELEASE] Apache Cassandra 4.0-alpha1 released

Have anyone used this yet? Any intial thoughts? When will be full and final ready fornprod version coming in? On Sunday, September 8, 2019, Michael Shuler wrote: > The Cassandra team is pleased to announce the release of Apache Cassandra > version 4.0-alpha1. > > Apache Cassandra is a fully

Re: Nodetool snapshot

lly - if you do this, you can > 'nodetool clearsnapshot' to free up space. > > > On Thu, Sep 19, 2019 at 10:54 AM Abdul Patel wrote: > >> Hey All, >> >> I found recentmy that the nodetool snapshot golder is creating almost >> 120GB of filea when my actual keys

Nodetool snapshot

Hey All, I found recentmy that the nodetool snapshot golder is creating almost 120GB of filea when my actual keyspace folder has 20GB only. Do we need to change any paramater to avoid this? Is this normal? I have 3.11.4 version

Logon trigger

Hi All, As per normal databases have logon trigger, do we have similar option in cassandra. Would like to implement ip restrictions in cassandra, or any other method?

Re: All time blocked in nodetool tpstats

on frequency, long garbage collection pauses, and high > tombstone read warnings. > > Regards, > Anthony > > On Thu, 11 Apr 2019 at 06:01, Abdul Patel wrote: > >> Yes the queries are all select queries as they are more of read intensive >> app. >> Last night i reboo

All time blocked in nodetool tpstats

t; > Regards > > Paul Chandler > > > > > On 9 Apr 2019, at 18:58, Abdul Patel wrote: > > > > Hi, > > > > My nodetool tpstats arw showing all time blocked high numbers a d also > read dropped messages as 400 . > > Client is expeirince h

Re: All time blocked in nodetool tpstats

ed queries, have you investigated which > queries are producing the client timeouts? > > Regards > > Paul Chandler > > > > > On 9 Apr 2019, at 18:58, Abdul Patel wrote: > > > > Hi, > > > > My nodetool tpstats arw showing all time blocked high numbers

All time blocked in nodetool tpstats

Hi, My nodetool tpstats arw showing all time blocked high numbers a d also read dropped messages as 400 . Client is expeirince high timeouts. Checked few online forums they recommend to increase, native_transport_max_threads. As of jow its commented with 128 .. Is it adviabke to increase this and

Re: Cassandra config in table

Thanks! On Monday, February 25, 2019, Jeff Jirsa wrote: > Not in any released version, but something similar to that is coming in 4.0 > > -- > Jeff Jirsa > > > > On Feb 25, 2019, at 7:22 AM, Abdul Patel wrote: > > > > Do we have any sustem table which store

Cassandra config in table

Do we have any sustem table which stores all config details which we have in yaml or cassandra env.sh?

Re: Ansible scripts for Cassandra to help with automation needs

One idea will be to rolling restart of complete cluster , that script will be huge help. Just read a blog too that last pickle group has come up with a tool called 'cstart' something which can help in rolling restart. On Thursday, February 14, 2019, Jeff Jirsa wrote: > > > > On Feb 13, 2019,

Read and write trasanction per sec

Hi Is there a way to calculate or mesaure the read/ sec and write / sec in cassandra? I have prometheus tool to capture metrics it has read count ans write count not sure if its relevant to the clusster capacity to measure the read n write sec processing.

Cassandra 4.0

Hi all, Any idea when 4.0 is planned to release?

Nodetool info for heap usage

Hi All, Is nodetool info information is accurate to monitor memory usage, intially with 3.1.0 we had monitoring nodetool infor for heap usage and it never reported this information as high,after upgrading to 3.11.2 we started getting high usage using nodetool info later upgraded to 3.11.3 and

Re: Tracing in cassandra

Yes with range queries its timing out, one question was the where condition is primary key rather than clustering key. On Friday, October 12, 2018, Nitan Kainth wrote: > Did it still timeout? > > Sent from my iPhone > > On Oct 12, 2018, at 1:11 PM, Abdul Patel wrote: &g

Re: Tracing in cassandra

query with partition key selection in where clause. But time for >> limit 11 shouldn’t fail. Are all nodes up? Do you see any corruption in ay >> sstable? >> >> Sent from my iPhone >> >> On Oct 12, 2018, at 11:40 AM, Abdul Patel wrote: >> >> Sean, >

Re: Tracing in cassandra

t; Sent from my iPhone > > On Oct 12, 2018, at 11:40 AM, Abdul Patel wrote: > > Sean, > > here it is : > CREATE TABLE Keyspave.tblname ( > user_id bigint, > session_id text, > application_guid text, > last_access_time timestamp, > login_time ti

Re: [EXTERNAL] Re: Tracing in cassandra

partition. That is why a schema for the > involved table could help. > > > > > > Sean Durity > > > > *From:* Abdul Patel > *Sent:* Friday, October 12, 2018 10:04 AM > *To:* user@cassandra.apache.org > *Subject:* [EXTERNAL] Re: Tracing in cassandra > >

Re: Tracing in cassandra

Cpuld you elaborate cross partition query? On Friday, October 12, 2018, Durity, Sean R wrote: > I suspect you are doing a cross-partition query, which will not scale well > (as you can see). What is the schema for the table involved? > > > > > > Sean Durity > > &g

Tracing in cassandra

Hi, We have multiple timeouts with select queries. I ran trace to see why its timing out ..do we jave a good document to interpretate whats causing the queries to timeout?

Re: Connections info

this nodes native protocol server” >> >> As for where they’re coming from — I’m not sure how to get that from >> JMX. Maybe you’ll have to use “lsof” or something to get that. >> >> - Max >> >> On Oct 4, 2018, at 8:57 pm, Abdul Patel wrote: >> >> Hi All, >> >> Can we get number of users connected to each node in cassandra? >> Also can we get from whixh app node they are connecting from? >> >> >>

Connections info

Hi All, Can we get number of users connected to each node in cassandra? Also can we get from whixh app node they are connecting from?

Re: Multi dc reaper

Is the multidc reaper for load balancing if one goes dpwn another node can take care of shchedule repairs or we can actuly schedule repairs at dc level woth seperate reaper instances. I am planning to have 3 reaper instances in 3 dc . On Friday, September 28, 2018, Abdul Patel wrote: >

Re: Cassandra system table diagram

. 20007 > > We build and manage digital business technology platforms. > On Sep 19, 2018, 11:49 PM +0200, Joseph Arriola , > wrote: > > Hi, I recomend this > > http://kdm.dataview.org/ > > its free and it has the implementation of good design practices that you > can find in

Cassandra system table diagram

Hi, Do we have somehwere cassandra system tables relation diagram? Or just system table diagram?

Re: Improve data load performance

:* [EXTERNAL] Re: Improve data load performance > > > > Step one is always to measure your bottlenecks. Are you spending a lot of > time compacting? Garbage collecting? Are you saturating CPU? Or just a > few cores? Or I/O? Are repairs using all your I/O? Are you just runni

Re: Improve data load performance

one is always to measure your bottlenecks. Are you spending a lot of > time compacting? Garbage collecting? Are you saturating CPU? Or just a > few cores? Or I/O? Are repairs using all your I/O? Are you just running > out of write threads? > > On Wed, Aug 15, 2018 at 5:48 AM,

Re: Improve data load performance

; Thanks > > On Wed, Aug 15, 2018 at 8:25 AM Abdul Patel wrote: > >> How can we improve data load performance? > >

Improve data load performance

How can we improve data load performance?

90million reads

Currently our cassandra prod is 18 node 3 dc cluster and application does 55 million reads per day and want to add load and make it 90 millon reads per day.they need a guestimate of resources which we need to bump without testing ..on top of my head we can increase heap and native trasport value

Re: Reaper 1.2 released

Was abke start it but unable to start any repair manually it says POST/repair_run Unit conflits with exiting in clustername On Wednesday, July 25, 2018, Abdul Patel wrote: > Ignore , alter and create permission were missing ..will msg if i actually > see an showstopper > > On Wednes

Re: Reaper 1.2 released

Ignore , alter and create permission were missing ..will msg if i actually see an showstopper On Wednesday, July 25, 2018, Abdul Patel wrote: > I am trying to uograde to 1.2.2 version of reaper the instance isnt > starting and giving error that unable to create table snapshot ..do w

Re: Reaper 1.2 released

I am trying to uograde to 1.2.2 version of reaper the instance isnt starting and giving error that unable to create table snapshot ..do we need to create it under reaper-db? On Wednesday, July 25, 2018, Steinmaurer, Thomas < thomas.steinmau...@dynatrace.com> wrote: > Jon, > > > > eager trying it

Re: 3.11.2 memory leak

Any idea when 3.11.3 is coming in? On Tuesday, June 19, 2018, kurt greaves wrote: > At this point I'd wait for 3.11.3. If you can't, you can get away with > backporting a few repair fixes or just doing sub range repairs on 3.11.2 > > On Wed., 20 Jun. 2018, 01:10 Abdul Patel, wrote:

Re: Bind keyspace to specific data directory

t you would probably need to do this after the keyspace is created > and before the tables are created. This setup would mean that all > reads/writes for tables in keyspace "foo" would touch that volume. > > Regards, > Anthony > > On Tue, 3 Jul 2018 at 07:02, Abdul

Bind keyspace to specific data directory

Hi Can we bind or specify while creating keyspace to bind to specific filesystem or directory for writing? I see we can split data on multiple filesystems but can we decide while fileystem a particular keyspace can read and write?

Bind keyspace to specific data directory

Hi Can we bind or specify while creating keyspace to bind to specific filesystem or directory for writing? I see we can split data on multiple filesystems but can we decide while fileystem a particular keyspace can read and write?

Cassandra read/sec and write/sec

Hi all We use prometheus to monitor cassandra and then put it on graphana for dashboard. Whats the parameter to m3asure throughput of cassandra?

Re: Is it ok to add more than one node to a exist cluster

Theres always an 2 minute rule ..after adding one node wait for 2 minutes before addding second node. On Wednesday, June 27, 2018, dayu wrote: > Thanks for your reply, kurt. > > another question, Can I bootstrap a new node when some node is in Joining > state ? Or I should wait until Joining

Re: 3.11.2 memory leak

; > There have been a few people who have reported it, but nobody (yet) has > offered a patch to fix it. It would be good to have a reliable way to > repro, and/or an analysis of a heap dump demonstrating the problem (what's > actually retained at the time you're OOM'ing). > > >

3.11.2 memory leak

Hi All, I recently upgraded my non prod cluster from 3.10 to 3.11.2. It was working fine for a 1.5 weeks then suddenly nodetool info startee reporting 80% and more memory consumption. Intially it was 16gb configured, then i bumped to 20gb and rebooted all 4 nodes of cluster-single DC. Now after 8

Re: Cassandra few nodes having high mem consumption

, Abdul Patel <abd786...@gmail.com> wrote: > Hi > > I have few cassandra nodes throwing suddwnly 80% memory usage , this > happened 1 week after upgrading from 3.1.0 to 3.11.2 , no errors in log . > Is their a way i can find high cpu or memory consuming process in > cassnadra? >

Cassandra few nodes having high mem consumption

Hi I have few cassandra nodes throwing suddwnly 80% memory usage , this happened 1 week after upgrading from 3.1.0 to 3.11.2 , no errors in log . Is their a way i can find high cpu or memory consuming process in cassnadra?

Re: Question About Reaper

ingle reaper instance >> managing 50 clusters and over 2000 nodes. >> >> There might be bigger, but I either don’t know about it or can’t >> remember. >> >> On Sun, May 20, 2018 at 10:04 AM Abdul Patel <abd786...@gmail.com> wrote: >> >>>

Re: Question About Reaper

Hi, I recently tested reaper and it actually helped us alot. Even with our small footprint 18 node reaper takes close to 6 hrs.. But it really depends on number nodes. For example if you have 4 nodes then it runs on 4*256 =1024 segements , so for your env. Ut will be 256*144 close to 36k

Re: Invalid metadata has been detected for role

t;k...@instaclustr.com> wrote: > Can you post the stack trace and you're version of Cassandra? > > On Fri., 18 May 2018, 09:48 Abdul Patel, <abd786...@gmail.com> wrote: > >> Hi >> >> I had to decommission one dc , now while adding bacl the same nodes ( i >> used

Invalid metadata has been detected for role

Hi I had to decommission one dc , now while adding bacl the same nodes ( i used nodetool decommission) they both get added fine and i also see them im nodetool status but i am unable to login in them .gives invalid mwtadat error, i ran repair and later cleanup as well. Any ideas?

Re: Error after 3.1.0 to 3.11.2 upgrade

nts of replicas of system_auth > keyspace? > > Hannu > > Abdul Patel <abd786...@gmail.com> kirjoitti 12.5.2018 kello 5.21: > > No applicatiom isnt impacted ..no complains .. > Also its an 4 node cluster in lower non production and all are on same > version. > > On Fri

Re: Error after 3.1.0 to 3.11.2 upgrade

peated isn’t great, but is the application impacted? > > -- > Jeff Jirsa > > > On May 12, 2018, at 6:17 AM, Abdul Patel <abd786...@gmail.com> wrote: > > Seems its coming from 3.10, got bunch of them today for 3.11.2, so if this > is repeatedly coming , whats s

Re: Error after 3.1.0 to 3.11.2 upgrade

the auth cache failing to refresh - if it’s transient it’s > probably not a big deal. If it continues then there may be an issue with > the cache refresher. > > -- > Jeff Jirsa > > > On May 12, 2018, at 5:55 AM, Abdul Patel <abd786...@gmail.com> wrote: > > HI All

Error after 3.1.0 to 3.11.2 upgrade

HI All, Seen below stack trace messages , in errorlog one day after upgrade. one of the blogs said this might be due to old drivers, but not sure on it. FYI : INFO [HANDSHAKE-/10.152.205.150] 2018-05-09 10:22:27,160 OutboundTcpConnection.java:510 - Handshaking version with /10.152.205.150

Re: Cassandra client drivers

se versions. I would advise testing your application > out against a 3.11.2 test environment first though, just to be safe ;). > > Thanks, > Andy > > On Mon, May 7, 2018 at 5:47 PM, Abdul Patel <abd786...@gmail.com> wrote: > >> Hi >> >> I am.planning for

Cassandra client drivers

Hi I am.planning for upgrade from 3.1.0 to 3.11.2 , just wanted to confirm if cleint drivers need to upgraded? Or it will work with 3.1.0 drivers?

Re: Cassandra limitations

ust > for empty memtables. If you have a thousand tables, that's a gigabyte of > heap, just for EMPTY memtables. > > > > > > On Fri, May 4, 2018 at 11:17 AM, Abdul Patel <abd786...@gmail.com> wrote: > >> I have 3 projects in pipeline adding 3 different clus

Re: Cassandra limitations

s in the low hundreds – maybe 200 as a > rough estimate. > > > > In general, we create a new cluster (instead of a new keyspace) for each > application. > > > > > > Sean Durity > > *From:* Abdul Patel <abd786...@gmail.com> > *Sent:* Thursday, May 0

Cassandra limitations

Hi , In my environment, we are coming up with 3 to 4 new projects , hence new keyspaces will be coming into picture. Do we have any limitations or performance issues when we hit to a number of keyspaces or number of nodes vs keyspaces? Also connections limitations if any? I know as data grows we

Cassandra reaper metrics

Hi Does the metrics work with prometheus? I did find graphite example ..not sure what would be the prometheus example.

Re: Cassandra reaper

> packaging/resource/cassandra-reaper.yaml > > > Hope that helped! > > Joaquin Casares > Consultant > Austin, TX > > Apache Cassandra Consulting > http://www.thelastpickle.com > > On Tue, Apr 24, 2018 at 7:07 PM, Abdul Patel <abd786...@gmail.com> wrote:

Re: Cassandra reaper

reaper.io/docs/download/install/# > service-configuration > > > Hope that helps! > > Joaquin Casares > Consultant > Austin, TX > > Apache Cassandra Consulting > http://www.thelastpickle.com > > On Tue, Apr 24, 2018 at 6:51 PM, Abdul Patel <abd786...@gmail.com&

Cassandra reaper

Hi All, For reaper do we need both file or only one? Cassandra.reaper.yaml Cassandra-reaper-cassandra.yaml

Re: Nodetool repair multiple dc

ters, >> but I’m pretty sure Reaper is the best open source option. Otherwise you’ll >> waste a lot of time trying to figure it out own your own. No need to >> reinvent the wheel. >> >> On Apr 12, 2018, 11:02 PM -0400, Abdul Patel <abd786...@gmail.com>, >> wro

Logback-tools.xml

Hey All, I have instakled 3.11.2 and i see 2 new files ..logback-tools.xml and -jaas.config .. What are they used for ?

Cassandra downgrade version

Hi All, I am.planning to upgrade my cassandra cluster from 3.1.0 to 3.11.2 . Just in case if somethings goes back then do we have any rollback or downgrade option in cassandra to older/ previous version? Thanks

Cassandra datastax cerrification

Hi All, I am preparing for cassandra certification(dba) orielly has stopped the cassandra cerrification so the best bet is datastax now ..as per my knwledge ds201 and 220 should be enough for cerrification and also i am reading definitive guide on cassandra ..any other material required ? Any

Nodetool repair multiple dc

Hi All, I have 18 node cluster across 3 dc , if i tey to run incremental repair on singke node it takes forever sometome 45 to 1hr and sometime times out ..so i started running "nodetool repair -dc dc1" for each dc one by one ..which works fine ..do we have an better way to handle this? I am

Cssandra acid compliance?

As mongodb is coming up acid compliance , do we see cassnadra bringung this to table ? Also one brimgs in this , how it will compensate on performance and other factors? Also any chance to bringe in relational constraints and foreign key like cockroach db ?

Re: Latest version and Features

Will driver upgrade is required if i move to 3.11.2 from 3.1.0? 3.x drivers should work right? On Thursday, April 12, 2018, Carlos Rolo wrote: > Thanks for the heads-up. I will update the post. > > Regards, > > Carlos Juzarte Rolo > Cassandra Consultant / Datastax Certified

Re: Latest version and Features

Nicolas, I do see all new features but instructions for upgrade are mentioned in next section ..not sure if i missed it ..can you share that section? On Wednesday, April 11, 2018, Abdul Patel <abd786...@gmail.com> wrote: > Thanks .this is perfect > > On Wednesday, April 11, 2018,

Re: Latest version and Features

te: >> >>> Move to the latest 3.0, or if you're feeling a little more adventurous, >>> 3.11.2. >>> >>> 4.0 discussion is happening now, nothing is decided. >>> >>> On Wed, Apr 11, 2018 at 7:35 AM Abdul Patel <abd786...@gmail.com> wrote: &g

Re: Latest version and Features

ening now, nothing is decided. > > On Wed, Apr 11, 2018 at 7:35 AM Abdul Patel <abd786...@gmail.com> wrote: > >> Hi All, >> >> Our company is planning for upgrading cassandra to maitain the audit >> gudilines for patch cycle. >> We are currently on 3.1.0, w

Latest version and Features

Hi All, Our company is planning for upgrading cassandra to maitain the audit gudilines for patch cycle. We are currently on 3.1.0, whats the latest stable version and what are the new features? Will it be better to wait for 4.0? Any news on what will be new features in 4.0 ?