Re: moving from 4.0-alpha4 to 4.0.1

Thank you Paulo for your detailed answer! I was not monitoring NEWS.txt in the Git repo so far but that file definitely has info I was looking for. cheers Attila Wind http://www.linkedin.com/in/attilaw <http://www.linkedin.com/in/attilaw> Mobile: +49 176 43556932 09.10.2021

moving from 4.0-alpha4 to 4.0.1

or similar questions? As a user I see the changelog and that's cool but that is not providing obvious answers (of course). So I mean some sort of migration hints/guide. thanks! -- Attila Wind http://www.linkedin.com/in/attilaw <http://www.linkedin.com/in/attilaw> Mobile: +49 176 43556932

Re: Integration tests - is anything wrong with Cassandra beta4 docker??

Yes this defintely explains the (much) longer startup - however I'm not sure about stability issues still... Anyways thanks Erik for the info! Attila Wind http://www.linkedin.com/in/attilaw <http://www.linkedin.com/in/attilaw> Mobile: +49 176 43556932 10.03.2021 14:26 keltezéssel

Integration tests - is anything wrong with Cassandra beta4 docker??

at around 60-80% of completed test cases Anyone similar / related experiences maybe? thanks -- Attila Wind http://www.linkedin.com/in/attilaw <http://www.linkedin.com/in/attilaw> Mobile: +49 176 43556932

Re: moving away from Counters - strategy?

Requires serial writes and serial reads, so a bit more expensive, but > allows TTL. > > > On Mar 6, 2021, at 8:03 AM, Attila Wind wrote: > >  > > Hi guys, > > We do use Counter tables a lot because in our app we have several things > to count (business logic) > >

moving away from Counters - strategy?

if I have a race condition so ThreadA and ThreadB are executing the above sequence ~ the same time then the mycounter value will be wrong... I started to wonder: how do you solve this problem? Is anyone aware of any nice post/article regarding migration strategy - stepping away from counters?

Re: underutilized servers

:-) Thanks again - and thanks to others as well It looks mastering the "nodetool tpstats" and the Cassandra thread pools would worth some time... :-) Attila Wind http://www.linkedin.com/in/attilaw <http://www.linkedin.com/in/attilaw> Mobile: +49 176 43556932 06.03.2021 13:03

Re: underutilized servers

0  0.00 0.00  0.00  0.00 ASYMMETRIC_SYNC_REQ  0  0.00 0.00  0.00  0.00 REPLICATION_DONE_REQ 0  0.00 0.00  0.00  0.00 PAXOS_PROPOSE_RSP    0   

underutilized servers

back to fully utilize the server resources... We are clearly missing something! Anyone any idea / tip? thanks! -- Attila Wind http://www.linkedin.com/in/attilaw <http://www.linkedin.com/in/attilaw> Mobile: +49 176 43556932

Re: strange behavior of counter tables after losing a node

Thanks Elliott, yepp! This is exactly what we also figured out as a next step. Upgrade our TEST env to that so we can re-evaluate the test we did. Makes 100% sense Attila Wind http://www.linkedin.com/in/attilaw <http://www.linkedin.com/in/attilaw> Mobile: +49 176 43556932 27.01.2021

Re: strange behavior of counter tables after losing a node

luster I'm all ears! :-) thanks Attila Wind http://www.linkedin.com/in/attilaw <http://www.linkedin.com/in/attilaw> Mobile: +49 176 43556932 22.01.2021 07:35 keltezéssel, Attila Wind írta: Hey guys, Yesterday we had an outage after we have lost a node and we saw such a behavior we c

strange behavior of counter tables after losing a node

is implemented in Java 8, we are using Datastax driver 3.7.1 and server cluster is running on Cassandra 4.0 alpha 4. Cluster size is 3 nodes. Any feedback is appreciated! :-) thanks -- Attila Wind http://www.linkedin.com/in/attilaw <http://www.linkedin.com/in/attilaw> Mobile: +49 176 43556932

Re: Cassandra timeout during read query

strategies in your tables to keep the amount of data managed somehow. TTL based approach e.g. is the best if you ask me especially if you have huge data set. cheers Attila Wind http://www.linkedin.com/in/attilaw Mobile: +49 176 43556932 27.10.2020 20:07 keltezéssel, Deepak Sharma írta: Hi Attlil

best pointers to learn Cassandra maintenance

ined blog post(s), article(s), book(s). Not some "half done" or  "I quickly write a post because it was too long ago when I blogged something..." things  :-) Good pointers would be appreciated! thanks -- Attila Wind http://www.linkedin.com/in/attilaw Mobile: +49 176 43556932

data modeling qu: use a Map datatype, or just simple rows... ?

mments, pointers to some related case studies, articles, etc is highly appreciated!! :-) thanks! -- Attila Wind http://www.linkedin.com/in/attilaw Mobile: +49 176 43556932

Re: Cassandra timeout during read query

will start happening is a clean indication) cheers Attila Wind http://www.linkedin.com/in/attilaw Mobile: +49 176 43556932 14.09.2020 18:36 keltezéssel, Aaron Ploetz írta: Deepak, Can you reply with: 1) The query you are trying to run. 2) The table definition (PRIMARY KEY, specifically). 3) Maybe

best setup of tombstones cleanup over a "wide" table (was: efficient delete over a "wide" table?)

setup for everything which I believe should be fine tuned a bit better FYI: this table has ~500k new UUID keyed rows every day in each partition... thanks a lot! Attila Wind http://www.linkedin.com/in/attilaw Mobile: +49 176 43556932 04.09.2020 16:33 keltezéssel, Jeff Jirsa írta: As

efficient delete over a "wide" table?

e one-by-one like DELETE FROM ... WHERE ... uuid = 'a' DELETE FROM ... WHERE ... uuid = 'b' ... DELETE FROM ... WHERE ... uuid = 'z' or b) issue delete in a group fashion like DELETE FROM ... WHERE ... uuid in ('a', 'b', ... 'z') ? or is there any other way to effeicently delete which I mi

Re: tombstones - however there are no deletes

right! silly me (regarding "can't have null for clustering column") :-) OK code is modified, we stopped using NULL on that column. In a few days we will see if this was the cause. Thanks for the useful info eveyrone! Helped a lot! Attila Wind http://www.linkedin.com/in/attilaw M

Re: tombstones - however there are no deletes

l columns? or just clustering key cols? Because if for all cols (which would make sense maybe to me more) then we found the possible reason.. :-) As we do have an Integer coulmn there which is actually NULL often (and so far in all cases)  Attila Wind http://www.linkedin.com/in/attilaw Mobil

tombstones - however there are no deletes

es however we are handling them same fashion... ok counter tables work differently but still interesting to me why those never generated things like this thanks! -- Attila Wind http://www.linkedin.com/in/attilaw Mobile: +49 176 43556932

Re: relation btw LWTs and RF

of "consistency level" / different phases of LWT very well. Yesterday I was searching / reading at least 15 different articles + docs - none of them answered my questions (and I just had more and more as progressing with reading) entirely - this one is a nice one! cheers Attila

Re: relation btw LWTs and RF

Ah yeah forgot to mention - I am using Cassandra 4.0-alpha4 Attila Wind http://www.linkedin.com/in/attilaw Mobile: +49 176 43556932 26.06.2020 08:06 keltezéssel, Attila Wind írta: Hey guys, Recently I ran into an interesting situation (by trying to add optimistic locking strategy to one

relation btw LWTs and RF

eries with ReplicationFactor = 2 with tolerating 1 node is down (out of that 2 replicas)" ? Thanks! -- Attila Wind http://www.linkedin.com/in/attilaw Mobile: +49 176 43556932

Re: IN OPERATOR VS BATCH QUERY

Hi Sergio, AFAIK you use batches when you want to get "all or nothing" approach from Cassandra. So turning multiple statements into one atomic operation. One very typical use case for this is when you have denormalized data in multiple tables (optimized for different queries) but you need to

Re: Counter table in Cassandra

Hi Garvit, I can not answer your main question but when I read your lines one thing was popping up constantly: "why do you ask this?" So what is the background of this question? Do you see anything smelly? Actually a) I always assumed so naturally there are of course lots of in-parallel

Re: Select in allow filtering stalls whole cluster. How to prevent such behavior?

data fully mirrored into a test cluster. So running those queries on test system is possible. Plus If for whatever reason we really really need to run such a query in Prod I can simply instruct them test query like this in the test system for sure cheers Attila Wind http://www.linkedin.com/in

Re: Select in allow filtering stalls whole cluster. How to prevent such behavior?

... thanks! Attila Wind http://www.linkedin.com/in/attilaw Mobile: +36 31 7811355 On 2019. 05. 23. 11:42, shalom sagges wrote: a) Interesting... But only in case you do not provide partitioning key right? (so IN() is for partitioning key?) I think you should ask yourself a different question

Re: CassKop : a Cassandra operator for Kubernetes developped by Orange

do I miss? ps.: maybe Orange and sky-uk/cassandra-operator guys should cooperate..?? Others are clearly building business around it cheers Attila Wind http://www.linkedin.com/in/attilaw Mobile: +36 31 7811355 On 2019. 05. 24. 20:36, John Sanda wrote: There is also https://github.com/sky-uk

Re: Select in allow filtering stalls whole cluster. How to prevent such behavior?

using ALLOW FILTERING, you are doing something like a full table scan in a relational database. There is a lot of information on the internet regarding this subject such as https://www.instaclustr.com/apache-cassandra-scalability-allow-filtering-partition-keys/ Hope this helps. Regards, On

Re: Select in allow filtering stalls whole cluster. How to prevent such behavior?

Still does not explain or justify "all 8 nodes to halt and unresponsiveness to external requests" behavior... Even if servers are busy with the request seriously becoming non-responsive...? cheers Attila Wind http://www.linkedin.com/in/attilaw Mobile: +36 31 7811355 On 2019.