Need advice about which tool to choose?Ask the StackShare community!

Aerospike

199
283
+ 1
48
ScyllaDB

131
182
+ 1
8
Add tool

Aerospike vs Scylla: What are the differences?

Aerospike vs. Scylla: Key Differences

Introduction

Aerospike and Scylla are both highly scalable NoSQL databases used for big data applications. While both offer high performance and low-latency data storage, they have key differences that distinguish them from each other.

  1. Data Model: Aerospike uses a key-value data model, where each record is identified by a unique key and contains a set of bins (name-value pairs). On the other hand, Scylla is based on the Apache Cassandra data model, using a wide-column data model where data is organized into rows, columns, and column families. This allows Scylla to handle complex and dynamic data with a flexible schema.

  2. Consistency Model: Aerospike provides strong consistency by default, ensuring that all replicas in a cluster are updated before acknowledging a write operation. In contrast, Scylla, like Cassandra, adopts a tunable consistency model that allows users to choose the level of consistency required for each operation. This allows for better trade-offs between latency and consistency based on specific application needs.

  3. Distribution Strategy: Aerospike distributes data using a data replication strategy called "replication factor," where each record is replicated on multiple nodes. This ensures high availability and fault tolerance. On the other hand, Scylla uses a consistent hashing algorithm to distribute data across a cluster using virtual nodes. This allows for better load balancing and automatic data redistribution when nodes are added or removed from the cluster.

  4. Query Language: Aerospike uses a SQL-like query language called Aerospike Query Language (AQL) to perform queries and aggregations on data. It offers a powerful set of functionalities for data manipulation. In contrast, Scylla uses Cassandra Query Language (CQL), which is based on SQL but also offers additional features specific to Cassandra's data model, such as wide-column support and secondary indexes.

  5. Write Path Optimization: Aerospike optimizes the write path by storing data in memory and persisting it to disk asynchronously. This allows for extremely fast write operations and high throughput. Scylla, on the other hand, utilizes a log-structured merge (LSM) tree data structure to optimize write operations. It writes data sequentially to disk, minimizing disk I/O and enabling efficient compaction and recovery processes.

  6. Community Support and Adoption: Aerospike has a dedicated and active community, with a strong focus on high-performance and low-latency use cases. Scylla, on the other hand, has gained significant traction among the developer community due to its compatibility with Apache Cassandra and its ability to handle large-scale workloads with low latencies.

In summary, Aerospike and Scylla differ in terms of their data models, consistency models, distribution strategies, query languages, write path optimization, and community support. These differences highlight the unique strengths and use cases of each database, allowing developers to choose the one that best suits their specific requirements.

Advice on Aerospike and ScyllaDB
Vinay Mehta
Needs advice
on
CassandraCassandra
and
ScyllaDBScyllaDB

The problem I have is - we need to process & change(update/insert) 55M Data every 2 min and this updated data to be available for Rest API for Filtering / Selection. Response time for Rest API should be less than 1 sec.

The most important factors for me are processing and storing time of 2 min. There need to be 2 views of Data One is for Selection & 2. Changed data.

See more
Replies (4)
Recommends
on
ScyllaDBScyllaDB

Scylla can handle 1M/s events with a simple data model quite easily. The api to query is CQL, we have REST api but that's for control/monitoring

See more
Alex Peake
Recommends
on
CassandraCassandra

Cassandra is quite capable of the task, in a highly available way, given appropriate scaling of the system. Remember that updates are only inserts, and that efficient retrieval is only by key (which can be a complex key). Talking of keys, make sure that the keys are well distributed.

See more
Recommends
on
ScyllaDBScyllaDB

By 55M do you mean 55 million entity changes per 2 minutes? It is relatively high, means almost 460k per second. If I had to choose between Scylla or Cassandra, I would opt for Scylla as it is promising better performance for simple operations. However, maybe it would be worth to consider yet another alternative technology. Take into consideration required consistency, reliability and high availability and you may realize that there are more suitable once. Rest API should not be the main driver, because you can always develop the API yourself, if not supported by given technology.

See more
Pankaj Soni
Chief Technical Officer at Software Joint · | 2 upvotes · 145K views
Recommends
on
CassandraCassandra

i love syclla for pet projects however it's license which is based on server model is an issue. thus i recommend cassandra

See more
Decisions about Aerospike and ScyllaDB
Tom Klein

The Gentlent Tech Team made lots of updates within the past year. The biggest one being our database:

We decided to migrate our #PostgreSQL -based database systems to a custom implementation of #Cassandra . This allows us to integrate our product data perfectly in a system that just makes sense. High availability and scalability are supported out of the box.

See more
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Aerospike
Pros of ScyllaDB
  • 16
    Ram and/or ssd persistence
  • 12
    Easy clustering support
  • 5
    Easy setup
  • 4
    Acid
  • 3
    Scale
  • 3
    Performance better than Redis
  • 3
    Petabyte Scale
  • 2
    Ease of use
  • 2
    Replication
  • 1
    Fewer nodes
  • 1
    Distributed
  • 1
    Scale up
  • 1
    High availability
  • 1
    Written in C++
  • 1
    High performance

Sign up to add or upvote prosMake informed product decisions

- No public GitHub repository available -

What is Aerospike?

Aerospike is an open-source, modern database built from the ground up to push the limits of flash storage, processors and networks. It was designed to operate with predictable low latency at high throughput with uncompromising reliability – both high availability and ACID guarantees.

What is ScyllaDB?

ScyllaDB is the database for data-intensive apps that require high performance and low latency. It enables teams to harness the ever-increasing computing power of modern infrastructures – eliminating barriers to scale as data grows.

Need advice about which tool to choose?Ask the StackShare community!

What companies use Aerospike?
What companies use ScyllaDB?
See which teams inside your own company are using Aerospike or ScyllaDB.
Sign up for StackShare EnterpriseLearn More

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with Aerospike?
What tools integrate with ScyllaDB?

Sign up to get full access to all the tool integrationsMake informed product decisions

What are some alternatives to Aerospike and ScyllaDB?
Redis
Redis is an open source (BSD licensed), in-memory data structure store, used as a database, cache, and message broker. Redis provides data structures such as strings, hashes, lists, sets, sorted sets with range queries, bitmaps, hyperloglogs, geospatial indexes, and streams.
Riak
Riak is a distributed database designed to deliver maximum data availability by distributing data across multiple servers. As long as your client can reach one Riak server, it should be able to write data. In most failure scenarios, the data you want to read should be available, although it may not be the most up-to-date version of that data.
Cassandra
Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.
Elasticsearch
Elasticsearch is a distributed, RESTful search and analytics engine capable of storing data and searching it in near real time. Elasticsearch, Kibana, Beats and Logstash are the Elastic Stack (sometimes called the ELK Stack).
Tarantool
It is designed to give you the flexibility, scalability, and performance that you want, as well as the reliability and manageability that you need in mission-critical applications
See all alternatives