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

Aerospike

200
285
+ 1
48
MemSQL

85
184
+ 1
44
Add tool

Aerospike vs MemSQL: What are the differences?

What is Aerospike? Flash-optimized in-memory open source NoSQL database. 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 MemSQL? Database for real-time transactions and analytics. MemSQL converges transactions and analytics for sub-second data processing and reporting. Real-time businesses can build robust applications on a simple and scalable infrastructure that complements and extends existing data pipelines.

Aerospike and MemSQL can be primarily classified as "In-Memory Databases" tools.

Some of the features offered by Aerospike are:

  • 99% of reads/writes complete in under 1 millisecond.
  • Predictable low latency at high throughput – second to none. Read the YCSB Benchmark.
  • The secret sauce? A thousand things done right. Server code in ‘C’ (not Java or Erlang) precisely tuned to avoid context switching and memory copies. Highly parallelized multi-threaded, multi-core, multi-cpu, multi-SSD execution.

On the other hand, MemSQL provides the following key features:

  • ANSI SQL Support
  • Fully-distributed Joins
  • Compiled Queries

Aerospike is an open source tool with 282 GitHub stars and 52 GitHub forks. Here's a link to Aerospike's open source repository on GitHub.

Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Aerospike
Pros of MemSQL
  • 16
    Ram and/or ssd persistence
  • 12
    Easy clustering support
  • 5
    Easy setup
  • 4
    Acid
  • 3
    Petabyte Scale
  • 3
    Scale
  • 3
    Performance better than Redis
  • 2
    Ease of use
  • 9
    Distributed
  • 5
    Realtime
  • 4
    Columnstore
  • 4
    Sql
  • 4
    Concurrent
  • 4
    JSON
  • 3
    Ultra fast
  • 3
    Scalable
  • 2
    Unlimited Storage Database
  • 2
    Pipeline
  • 2
    Mixed workload
  • 2
    Availability Group

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 MemSQL?

MemSQL converges transactions and analytics for sub-second data processing and reporting. Real-time businesses can build robust applications on a simple and scalable infrastructure that complements and extends existing data pipelines.

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

Jobs that mention Aerospike and MemSQL as a desired skillset
LaunchDarkly
Oakland, California, United States
What companies use Aerospike?
What companies use MemSQL?
See which teams inside your own company are using Aerospike or MemSQL.
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 MemSQL?

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

What are some alternatives to Aerospike and MemSQL?
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