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

Apache Ignite

67
107
+ 1
19
MemSQL

63
135
+ 1
18
Add tool

Apache Ignite vs MemSQL: What are the differences?

Apache Ignite: An open-source distributed database, caching and processing platform *. It is a memory-centric distributed database, caching, and processing platform for transactional, analytical, and streaming workloads delivering in-memory speeds at petabyte scale; *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.

Apache Ignite and MemSQL belong to "In-Memory Databases" category of the tech stack.

Some of the features offered by Apache Ignite are:

  • Memory-Centric Storage
  • Distributed SQL
  • Distributed Key-Value

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

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

Apache Ignite is an open source tool with 2.67K GitHub stars and 1.3K GitHub forks. Here's a link to Apache Ignite's open source repository on GitHub.

According to the StackShare community, MemSQL has a broader approval, being mentioned in 10 company stacks & 16 developers stacks; compared to Apache Ignite, which is listed in 4 company stacks and 4 developer stacks.

Get Advice from developers at your company using Private StackShare. Sign up for Private StackShare.
Learn More
Pros of Apache Ignite
Pros of MemSQL
  • 3
    Written in java. runs on jvm
  • 3
    Free
  • 2
    Load balancing
  • 2
    High Avaliability
  • 2
    Rest interface
  • 2
    Sql query support in cluster wide
  • 1
    Multiple client language support
  • 1
    Better Documentation
  • 1
    Distributed compute
  • 1
    Distributed Locking
  • 1
    Easy to use
  • 5
    Distributed
  • 3
    Realtime
  • 2
    Sql
  • 2
    JSON
  • 2
    Concurrent
  • 2
    Columnstore
  • 1
    Scalable
  • 1
    Ultra fast

Sign up to add or upvote prosMake informed product decisions

Sign up to add or upvote consMake informed product decisions

No Stats
- No public GitHub repository available -

What is Apache Ignite?

It is a memory-centric distributed database, caching, and processing platform for transactional, analytical, and streaming workloads delivering in-memory speeds at petabyte scale

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!

What companies use Apache Ignite?
What companies use MemSQL?
See which teams inside your own company are using Apache Ignite or MemSQL.
Sign up for Private StackShareLearn More

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

What tools integrate with Apache Ignite?
What tools integrate with MemSQL?

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

What are some alternatives to Apache Ignite and MemSQL?
Redis
Redis is an open source, BSD licensed, advanced key-value store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted sets.
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
Hazelcast
With its various distributed data structures, distributed caching capabilities, elastic nature, memcache support, integration with Spring and Hibernate and more importantly with so many happy users, Hazelcast is feature-rich, enterprise-ready and developer-friendly in-memory data grid solution.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
Apache Spark
Spark is a fast and general processing engine compatible with Hadoop data. It can run in Hadoop clusters through YARN or Spark's standalone mode, and it can process data in HDFS, HBase, Cassandra, Hive, and any Hadoop InputFormat. It is designed to perform both batch processing (similar to MapReduce) and new workloads like streaming, interactive queries, and machine learning.
See all alternatives