Author: John Schulz

There are plenty of database migration options out there, and we love working with clients to help them assess and evaluate which one is best for them. Options include: Bare Metal Solution (BMS) PostgreSQL: On Cloud SQL On GCE (Google…

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…

Intro First, let me start by saying I do not hate Cassandra. I love Cassandra. In its place, Cassandra is a powerful tool designed well to scale to millions of operations per second over geographically distributed locations operating in a…

Over the last few months, I have been seeing references to Cassandra 4.0 and some of its new features. When that happens with a technology I am interested in, I go looking for the preview releases to download and test….

Every few months I have a customer come to me with the following concern: my compactions for one of my Cassandra tables are stuck or my repairs fail when referencing one of the nodes in my Cassandra cluster. I take…

Cassandra storage is generally described as a log-structured merge tree (LSM). In general, LSM storage provides great speed in performing writes, updates and deletes over reads. As a general rule, a write in Cassandra is an order of magnitude faster…

I’m sitting here on March 16th, the day before Saint Patties day and I am thinking about what I will need for my trip to Salt Lake City next week. I work for Pythian in the Principal Consulting Group. We are…

Introduction I’ve been working with data in many forms for my entire career. During this time, I have occasionally needed to build or query existing databases to get statistical data. Traditional databases are usually designed to query specific data from…

When I think of Time series databases, my first thoughts go to my own experiences using a relational database to store time series data. The mapping tends to be fairly straight forward. Each row stores data for a single event…

Introduction I have a database server that has these features: High available by design. Can be globally distributed. Allows applications to write to any node anywhere, anytime. Linearly scalable by simply adding more nodes to the cluster. Automatic workload and…