Scylla Blog

Stay up to date with recent news and updates on our Users Blog, and get under the hood on our Developers Blog.

Jan24

Scylla SSTable 3.0 Can Decrease File Sizes 50% or More

Scylla SSTable 3.0 Can Decrease File Sizes 50% or More

Scylla Open Source 3.0 ships with a new format for on-disk representation, SSTable 3.0. In this article, we will discuss some of the benefits that emerge from the adoption of this format and the scenarios in which they apply. We will discuss the differences between the old and new formats, and demonstrate use cases in which the new format has significant advantages, and others where the advantages are much smaller. This is truly a situation of “Your Mileage May Vary.” For example, in one test result below, we were able to show a 53% reduction in table size. Other use […]

Read full article

Jan10

JSON Support in Scylla

JSON in Scylla

Beginning with version 2.3, Scylla Open Source supports the Javascript Object Notation (JSON) format. That includes inserting JSON documents, retrieving data in JSON and providing helper functions to transform native CQL types into JSON and vice versa. Also note that schemas are still enforced for all operations — one cannot just insert random JSON documents into a table. The new API is simply a convenient way of working with JSON without having to convert everything back and forth client-side. JSON support consists of CQL statements and functions, described here, one by one, with examples. You can use the following code […]

Read full article

Nov1

More Efficient Range Scan Paging with Scylla 3.0

More Efficient Range Scan Paging with Scylla 3.0

In a previous blog post we examined how Scylla’s paging works, explained the problems with it and introduced the new stateful paging in Scylla 2.2 that solves these problems for singular partition queries by making paging stateful. In this second blog post we are going to look into how stateful paging was extended to support range-scans as well in Scylla Open Source 3.0. We were able to increase the throughput of range scans by 30% and how we also significantly reduced the amount of data read from the disk by 39% and the amount of disk operations by 73%. A […]

Read full article

Sep11

Large Partitions Support in Scylla 2.3 and Beyond

Large partitions, although supported by Scylla, are also well known for causing performance issues. Fortunately, release 2.3 comes with a helping hand for discovering and investigating large partitions present in a cluster — system.large_partitions table. Large partitions CQL, as a data modeling language, aims towards very good readability and hiding unneeded implementation details from users. As a result, sometimes it’s not clear why a very simple data model suffers from unexpected performance problems. One of the potential suspects might be large partitions. Our blog entry on large partitions contains a detailed explanation on why coping with large partitions is important. […]

Read full article

Sep5

CERN on Real-Time Processing of Big Data with Scylla

CERN real-time process of big data with Scylla graphic

In June, Miguel Martinez Pedreira, Software engineer at CERN on the ALICE project, and Glauber Costa, VP of Field Engineering at ScyllaDB, teamed up to do a computing seminar to discuss real-time processing of big data with ScyllaDB, examining how Scylla helped the ALICE experiment with their AliEn Global File Catalogue use case. CERN uses the world’s largest and most complex scientific instruments to study the basic constituents of matter – the fundamental particles. The instruments used at CERN are purpose-built particle accelerators and detectors. Accelerators boost beams of particles to high energies before the beams collide with each other or with […]

Read full article

Aug28

A Beginner’s Guide to Scylla Fault Tolerance

When choosing a database, it’s important that it is highly available and can scale. In this post, we will go over Scylla’s highly-available architecture.

Read full article

Aug23

Introducing the First Annual Scylla User Awards

Nominations are now open for the first-annual Scylla User Awards. Nominate your company and we’ll send you a Scylla hoodie!

Read full article

Aug16

Enhancements to Scylla’s Filtering Implementation

In this post we discuss the enhanced filtering support coming in Scylla 2.4 and compare it to the recommended alternatives and their performance.

Read full article

Aug14

Improvements to Scylla Streaming Performance

In this blog post, we will take a closer look at how Scylla streaming works in detail and how Scylla 2.4’s new streaming improves streaming bandwidth by 240% and reduces the time it takes to perform a “rebuild” operation by 70%.

Read full article

Aug9

The Cost of Containerization for Your Scylla

docker

This article will shed light on the performance penalties of running Scylla on Docker and discuss the tuning steps to solve them.

Read full article

Subscribe to Our Blog