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?
16 companies reportedly use MemSQL in their tech stacks, including AppsFlyer, Zynga, and Shutterstock.
61 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
Unlimited Storage Database
- 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), 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.
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.