Re: storage engine series

Nice! This sounds awesome, Jon. On Mon, Apr 29, 2024 at 6:25 PM Jon Haddad wrote: > Hey everyone, > > I'm doing a 4 week YouTube series on the C* storage engine. My first > video was last week where I gave an overview into some of the storage > engine internals [1]. > > The next 3 weeks are

Re: Upgrade from C* 3 to C* 4 per datacenter

Just a heads-up, but there have been issues (at least one) reported when upgrading a multi-DC cluster from 3.x to 4.x when the cluster uses node-to-node SSL/TLS encryption. This is largely attributed to the fact that the secure port in 4.x changes to 9142, whereas in 3.x it continues to run on

Re: Cassandra 5 & Support for JDK 17

Hello Sean, Cassandra 5.0 is indeed intended to run on Java 17. In fact, I just tried running 5.0-alpha , and it does indeed run on Java 17.0.8. There is a Jira ticket out there for tracking Java 17 issues with 5.0: CASSANDRA-16895

Re: Reads not returning data after adding node

e the racks. I just asked that question on this list and the answer was > that adding the new nodes as rack4, rack5 and rack6 is fine. They are all > on separate physical racks. Is that ok? > > On Mon, Apr 3, 2023 at 5:16 PM Aaron Ploetz wrote: > >> The time it takes to stream data

Re: Reads not returning data after adding node

The time it takes to stream data off of a node varies by network, cloud region, and other factors. So it's not unheard of for it to take a bit to finish. Just thought I'd mention that auto_bootstrap is true by default. So if you're not setting it, the node should bootstrap as long as it's not a

Accord and elector selection

Under the premise of an Accord transaction, how does replica/elector selection happen? Does it choose replicas based on the partition keys? Or is there another way? Thanks! Aaron

Re: Cleanup

So if I remember right, setting compaction_throughput_per_mb to zero effectively disables throttling, which means cleanup and compaction will run as fast as the instance will allow. For normal use, I'd recommend capping that at 8 or 16. Aaron On Thu, Feb 16, 2023 at 9:43 AM Marc Hoppins

Re: [DISCUSS] Formation of Apache Cassandra Publicity & Marketing Group

> > We are going to have our first gathering next Wednesday at 8AM PT I'd like to help out, too, if you wouldn't mind forwarding that meeting on to me. Thanks, Aaron

Re: Denylisting with a composite partition key

everything is working. Thanks again, Cheng! Aaron On Fri, Oct 21, 2022 at 9:48 AM Aaron Ploetz wrote: > Awesome. Thank you, Cheng! I’ll give this a shot and let you know. > > Thanks, > > Aaron > > > On Oct 21, 2022, at 12:45 AM, Cheng Wang wrote: > >  > Hi

Re: Denylisting with a composite partition key

literal-works-but-textasbinary-does-not > > So... the short answer is, I get back my previous answer. My apologies! It's > not recommended to directly insert rows into the > system_distributed.partition_denylist table.You'd better go with the JMX > interface since it will go to

Re: Denylisting with a composite partition key

will enable for the rest of three > @Jordan > West maybe you can confirm for that? But it's > better to enable for all just to be safe. > I will play by my side and get back to you soon about the composite keys. > > Thanks > Cheng > > On Wed, Oct 19, 2022 at 1:42 PM Aa

Re: Denylisting with a composite partition key

Just checking, but for this to work, do I have to mess with these settings in the YAML at all? partition_denylist_enabled: true denylist_reads_enabled: true They're commented out by default. Thanks, Aaron On Mon, Oct 17, 2022 at 4:53 PM Aaron Ploetz wrote: > Thanks for the h

Re: Denylisting with a composite partition key

20single%20quotation%20mark >> . >> >> and then you can verify the insert by doing >> >> cqlsh> select ks_name, table_name, blobAsText(key) from >> system_distributed.partition_denylist; >> >> >> ks_name | table_name | system.blobastext

Denylisting with a composite partition key

I have this table definition: CREATE TABLE stackoverflow.weather_sensor_data ( city text, month int, recorded_time timestamp, temp float, PRIMARY KEY ((city, month), recorded_time) ) WITH CLUSTERING ORDER BY (recorded_time DESC) Sample data looks like this: > SELECT * FROM

Apache Cassandra(R) Corner podcast - Call for guests

Just wanted to reach out to the folks on this list. The Apache Cassandra Corner® podcast is all about sharing and discussing some of the great use cases out there, as well as the infrastructure engineering which happens around it. If you are using or supporting Apache Cassandra®, I'd love to

The Apache Cassandra(R) Corner Podcast

How does open source marketing work and how does it help the Apache Cassandra® project? Listen in as Constantia's Melissa Logan and I talk about open source, Cassandra, and the Data on Kubernetes community. https://anchor.fm/cassandra-corner/episodes/ep5---Melissa-Logan-Constantia-e1kgp40 The

Re: Guardrails in Cassandra 4.1 Alpha

n't applied to system tables, so it > would still allow filtering on the system.local and system_views.settings > tables, but not in stackoverflow.movies. > > I hope this helps. > > On Thu, 23 Jun 2022 at 19:51, Aaron Ploetz wrote: > >> So I'm trying to test out the guardr

Guardrails in Cassandra 4.1 Alpha

So I'm trying to test out the guardrails in 4.1-alpha. I've set allow_filtering_enabled: false, but it doesn't seem to care (I can still use it). > SELECT release_version FROM system.local; release_version - 4.1-alpha1-SNAPSHOT (1 rows) > SELECT * FROM

new Cassandra Corner episode w/ Patrick McFadin

Nothing to see here...because well, it's a podcast, right? But I did get to spend some time with Patrick McFadin discussing our favorite database - Apache Cassandra! Listen in as we talk a little about the early days of Cassandra as well as the new, upcoming Cassandra 4.1 release.

Re: Topology vs RackDC

Agree with Paulo on this one. If you're running a cluster on K8s, in the cloud, or under some other conditions in which IPs change, the cassandra-topology.properties file is going to quickly become a burden. Especially if that cluster has more than just a few nodes. Increasing your cluster from

Re: The "Cassandra Corner" podcast

he source of the page, > and it shows this: > > title="The Cassandra Corner" > href="https://anchor.fm/s/99c5e268/podcast/rss;/> > > … which leads to a 404. Thanks. > > - Max > > On Jun 1, 2022, at 6:55 am, Aaron Ploetz wrote: > >

The "Cassandra Corner" podcast

-corner/episodes/ep1---Lakhan-Samani-Authorizer-e1j10hv This podcast is intended to highlight cool use cases for Cassandra and the folks in the Apache Cassandra community who implement them. If you would like to be a guest on the podcast, please reach out to me. Thanks everyone, Aaron

Re: Cassandra tarball install and systemd

> I am starting Cassandra with $CASSANDRA_HOME/bin/cassandra When starting Cassandra, it accepts a PID file location with the -p flag: $CASSANDRA_HOME/bin/cassandra -p /var/run/cassandra/cassandra.pid Start Cassandra with that, and then the PID file will be there. Assuming of course, that the

Re: update cassandra.yaml file on number of cluster nodes

When I was at Target, we had a lot of success with Rundeck. It was a quick way to push out changes to hundreds of clusters. https://www.rundeck.com/open-source On Mon, Oct 18, 2021 at 12:19 PM Yakir Gibraltar wrote: > We manage via Puppet: https://github.com/voxpupuli/puppet-cassandra > > On

Re: Vulnerability in libthrift library (CVE-2019-0205)

In reading the Jira ticket, I see this line: "a server or client may run into an endless loop *when fed with specific input data.*" That seems to suggest that if the cassandra.yaml contains start_rpc: false, you should be ok. On Mon, Oct 4, 2021 at 8:12 PM rammohan ganapavarapu <

Re: Use NetworkTopologyStrategy for single data center and add data centers later

Yes, you absolutely can (and should) use NetworkTopologyStrategy with a single data center. In fact, I would argue that SimpleStrategy should almost never be used. But that's just me. Thanks, Aaron On Sat, Dec 19, 2020 at 3:21 AM Manu Chadha wrote: > Is it possible to use

Re: Cassandra timeout during read query

Deepak, Can you reply with: 1) The query you are trying to run. 2) The table definition (PRIMARY KEY, specifically). 3) Maybe a little description of what the table is designed to do. 4) How much data you're expecting returned (both # of rows and data size). Thanks, Aaron On Mon, Sep 14,

Re: Cassandra crashes when using offheap_objects for memtable_allocation_type

primary key ((partition_key, clustering_key)) Also, this primary key definition does not define a partitioning key and a clustering key. It defines a *composite* partition key. If you want it to instantiate both a partition and clustering key, get rid of one set of parens. primary key

Re: Cassandra crashes when using offheap_objects for memtable_allocation_type

I would try running it with memtable_offheap_space_in_mb at the default for sure, but definitely lower than 8GB. With 32GB of RAM, you're already allocating half of that for your heap, and then halving the remainder for off heap memtables. What's left may not be enough for the OS, etc. Giving

Re: Cassandra didn't order data according to clustering order

It also helps to think about it with the token values of the partition key in place. Assume I have a table "users_by_dept" keyed like this: PRIMARY KEY ((department),username). Querying that table with the token function on the partition key looks like this: SELECT

Re: Openstack and Cassandra

Shalom, We (Target) have been challenged by our management team to leverage OpenStack whenever possible, and that includes Cassandra. I was against it at first, but we have done some stress testing with it and had application teams try it out. So far, there haven't been any issues. A good use

Re: Question about hector api documentation

I used to be surprised that people still ask about Hector here; and that questions here on Hector always seem to mirror new Hector questions on Stack Overflow. The problem (I think), is that places like Edureka! are still charging people $300 for a Cassandra training class, where they still

Re: Detect Repair is finish

active streams for you: while true; do date; diff (nodetool -h localhost netstats) (sleep 5 nodetool -h localhost netstats); done Hope this helps, Aaron Ploetz On Mon, Jun 22, 2015 at 8:40 AM, Jean Tremblay jean.tremb...@zen-innovations.com wrote: Hi, What is the best way to see