MemSQLWhat 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.
Key Features
ANSI SQL SupportFully-distributed JoinsCompiled QueriesACID ComplianceIn-Memory TablesOn-Disk TablesMassively Parallel ExecutionLock Free Data StructuresJSON SupportHigh AvailabilityOnline Backup and RestoreOnline Replication
MemSQL Pros & Cons
Pros of MemSQL
- ✓Distributed
- ✓Realtime
- ✓Columnstore
- ✓Concurrent
- ✓JSON
- ✓Sql
- ✓Scalable
- ✓Ultra fast
- ✓Availability Group
- ✓Mixed workload
Cons of MemSQL
No cons listed yet.
MemSQL Alternatives & Comparisons
What are some alternatives to 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.
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.
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.
