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.
MemSQL is a tool in the In-Memory Databases category of a tech stack.
Who uses MemSQL?
14 companies reportedly use MemSQL in their tech stacks, including AppsFlyer, Zynga, and Shutterstock.
55 developers on StackShare have stated that they use MemSQL.
MySQL, Google Compute Engine, Redash, QlikView, and Alooma are some of the popular tools that integrate with MemSQL. Here's a list of all 7 tools that integrate with MemSQL.
Pros of MemSQL
- ANSI SQL Support
- Fully-distributed Joins
- Compiled Queries
- ACID Compliance
- In-Memory Tables
- On-Disk Tables
- Massively Parallel Execution
- Lock Free Data Structures
- JSON Support
- High Availability
- Online Backup and Restore
- Online Replication
MemSQL Alternatives & Comparisons
What are some alternatives to MemSQL?
See all alternatives
VoltDB is a fundamental redesign of the RDBMS that provides unparalleled performance and scalability on bare-metal, virtualized and cloud infrastructures. VoltDB is a modern in-memory architecture that supports both SQL + Java with data durability and fault tolerance.
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.
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.
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.
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.