Tag: Cassandra

Useful CQLSH Commands for Everyday Use

Cassandra is an open-source NoSQL distributed database used for processing large volumes of data with high availability and scalability.     The CQL shell (cqlsh) allows users to communicate with Cassandra. Using this shell, you can execute Cassandra Query Language…

Read More >

Batch Operations in Apache Cassandra

Batches are one of the most misunderstood features of Apache Cassandra. They rarely improve performance. In fact, while using batches, performance may degrade. To set the stage, let’s take a look at how Cassandra handles individual mutations.   Individual mutations…

Read More >

Change Your system_auth Replication Factor in Cassandra

Cassandra authentication

Occasionally, clients reach out to us with authentication issues when a node is down. While this scenario shouldn’t happen in a high availability database management system (DBMS), it can if you miss a couple of very relevant lines in the…

Read More >

Cassandra for Beginners: Replication

cassandra for beginners

This post is the continuation of the previous post, Cassandra 101: Understanding What Cassandra Is, in which I’ll highlight a series of topics related to Cassandra for beginners.       Replication Factor The replication factor in Cassandra can be…

Read More >

Replacing Nodes in Cassandra

nodes in cassandra

One of the many things to love about Cassandra is how operationally simple it is to add, remove or even replace nodes in a cluster.     Replacing a node in Cassandra is as easy as setting your configuration files…

Read More >

DataOps – Liquibase to Manage Changes in Snowflake

What is this about? Well, as the title implies, I will show how to set up Liquibase to manage changes in Snowflake as part of a DataOps practice. Why? Because I am going deep-dive into DataOps around Snowflake and I’ve…

Read More >

Mitigating the Problems Created by Tombstones

Got too many tombstones? This blog post will talk about how to deal with tombstones once you already have them. For more information about tombstones, check out this post: Examining the Lifecycle of Tombstones in Apache Cassandra. Verifying the presence…

Read More >

How to Perform (UDC) User-Defined Compactions in Cassandra

User-defined compactions allow us to manually select which files should be compacted. This enables us to reclaim space and limit the size of compaction so it can fit into the remaining space. These compactions are relevant only for SizeTieredCompactionStrategy (STCS)…

Read More >

Let’s Deal with High Read Latencies in Cassandra

High latency values may indicate a cluster at the edge of its processing capacity, issues with the data model—such as poor choice of partition key or high levels of tombstones—or issues with the underlying infrastructure. Below are some major reasons…

Read More >

Benefits of Workshop Learning: a Cassandra Workshop Example

At Pythian, we pride ourselves in assisting and empowering our clients. We strive to understand the needs of each customer and to teach customers to make the most of their resources. Experience has shown that the best way to learn…

Read More >
Page 1 of 712345...Last Page »