The No-Limits DatabaseTM

Maximum database performance, scalability, and concurrency for apps & analytical systems

Download Free

How it Works

MemSQL is a distributed, highly-scalable SQL database that can run anywhere. We deliver maximum performance for transactional and analytical workloads with familiar relational data structures.

real-time database

High Speed Ingest

Fast bulk loading or stream ingestion with real-time data pipelines

Memory Optimized Tables

Ultra-low latency for scalable transactions and analytics

Disk Optimized Tables

Fast petabyte scale analytics with columnstore compression

Overview

real-time database
Ingest
Store
Analyze
Deploy

Real-Time Data: Live data from operational applications or web services



Real-Time Data

Apache Kafka and Spark: Streaming data from real-time message and transformation queues



Kafka or
Spark

Historical Data: Import from archive, data lake or block storage sources such as HDFS and Amazon S3

Historical Data

Applications: Embed custom visualizations and reports for analytic applications

Applications

Dashboards: Build dashboards and run ad hoc queries with industry standard business intelligence tools

BI Dashboards

On-Premises: Configure as a private cloud on industry standard hardware

On-Premises

Self Service Cloud: Amazon AWS, Microsoft Azure, Google Cloud Platform

Self Service Cloud

Fully Managed Cloud: Fully managed cloud service on Amazon Web Services or Microsoft Azure

Fully Managed Cloud

MemSQL Pipelines: Real-time ingest from Apache Kafka or Amazon S3 with exactly-once semantics and native management UI



Streaming Ingest

Live Data: Memory optimized tables for analyzing real-time events



Live
Data

Historical Data: Disk optimized tables with up to 10x compression for analyzing historical datasets



Historical
Data

MemSQL is a scalable SQL database that ingests data continuously to perform operational analytics for the front lines of your business. Ingest millions of events per day with ACID transactions while simultaneously analyzing billions of rows of data in relational SQL, JSON, Geospatial, and Full-Text Search formats.


Ready to get started?

Transform your business to Real Time today

Accelerate and Simplify Data Ingestion

real-time data ingest
08:52:01252 msSucceeded164164164
08:52:11336 msSucceeded101101101
08:52:34396 msSucceeded124124124
08:52:26301 msSucceeded290290290
08:52:56312 msSucceeded164164164
08:52:68282 msSucceeded124124124
08:52:13309 msSucceeded116116116
08:52:37310 msSucceeded145145145
08:52:23307 msSucceeded157157157
08:52:81398 msSucceeded183183183

MemSQL delivers ultimate ingestion performance at scale and eliminates costly data integration tools through built-in batch and real-time data pipelines

Programmatic Pipelines

Programmatic Pipelines

Build sophisticated for enrichment operations, eliminating the cost and complexity of ETL tooling
Learn More
Exactly-Once Semantics

Exactly-Once Semantics

Achieve guaranteed message delivery of streaming data for accurate reporting and analysis
Pipelines for Data Lakes

Pipelines for Data Lakes

Continuously ingest data from HDFS and accelerate analytic performance using familiar ANSI SQL
Learn More
Streaming Inputs

Streaming Inputs

Apache Kafka, Apache Spark
Database Inputs

Database Inputs

MySQL, SQL Server, Oracle, Postgres, Teradata, Redshift
Storage Inputs

Storage Inputs

Amazon S3, HDFS

Experience Latency-Free Analytics

low latency

MemSQL lets you achieve ultra fast query response across both live and historical data using familiar ANSI SQL

Sophisticated Insights

Sophisticated Insights

Perform ad hoc analysis with business intelligence tools, run machine learning algorithms for real-time scoring, perform geoanalytic queries in real time
Geospatial Support

Geospatial Support

Store, query, and index geographic data types including polygons and points to support area, distance, location analytics in real-time
JSON Optimized

JSON Optimized

Store and query JSON data as a column-type to efficiently store and analyze multi-attribute objects
Workload Management

Workload Management

Automatically deliver reliable database performance while under high concurrency – to easily support more users and queries
Learn More
Full-Text Search

Full-Text Search

Deliver fast, scalable full text-search applications with keyword-based and regular query conditions in a single SQL statement
Learn More
Multi-Statement Transactions

Multi-Statement Transactions

Multi-statement transactions allow a set of DML statements to be combined into a single transaction
Compiled Queries

Compiled Queries

Repeat queries are compiled into low level machine code to deliver record breaking response for analytic queries
Fully Distributed Joins

Fully Distributed Joins

Scale out fully distributed JOINs across any table and column for simple efficient query access

Improve Reliability with Durable Data

Our highly-scalable, distributed system balances data and queries across a cluster of cloud instances or commodity hardware for maximum performance, concurrency, and availability

Distributed Storage

Distributed Storage

Store and process data across clusters of machines for maximize resilience and performance leveraging memory and disk infrastructure
Big Data Capacity

Big Data Capacity

Store petabytes of data on low cost disk and cloud storage for archive requirements while maintaining instant retrieval for fast deep analysis
Massivelly Parallel

Massivelly Parallel

Scale out shared nothing architecture provides a robust parallel execution engine for read and write queries delivering ultra-fast performance
Full Durability to Disk

Full Durability to Disk

Write transactions directly to disk or write to memory with full data persistence and archiving
In-Memory or On-Disk Tables

In-Memory or On-Disk Tables

Use memory for transactional workloads and cleanup while using disk for historical data and analysis
Compressed On-Disk Tables

Compressed On-Disk Tables

Column store disk compression optimizes resources for storing up to petabytes of data

Ready to get started?

Transform your business to Real Time today

Simple to Setup and Configure with Built-in Monitoring

Powerful management tooling accelerates deployment, backups, and administration tasks. MemSQL Studio provides an intuitive monitoring interface to quickly diagnose and assist query performance tuning.

Monitor Performance and Capacity

Monitor Performance and Capacity

Quickly see and diagnose query performance bottlenecks and compute resources to ensure optimal performance and availability
API Driven Deployment

API Driven Deployment

Accelerate and simplify cluster deployment and configurations with API driven commands
Enable High Availability

Enable High Availability

MemSQL holds a redundant copy of data to protect against data loss. Online replication ensures data consistency
Scalable Multi-Tenancy

Scalable Multi-Tenancy

Deliver thousands of multi-tenant database instances for cloud applications, delivering premium data isolation and performance with minimal resources
Learn More
Cluster Management

Cluster Management

Automate and simplify common tasks including starting, stopping, restoring, backing up clusters
Backup and Scaling

Backup and Scaling

Manage data replication, backup including to cloud stores and quickly restore without impacting application performance or going offline
Cross Data Center Replication

Cross Data Center Replication

Synchronize one cluster with another over a broad network connection
Tool Interoperability

Tool Interoperability

Seamlessly plug-in with existing devops tooling and cloud formation templates

Comprehensive Security for Your Most Sensitive Data

MemSQL meets or exceeds data security requirements, including managing the most classified data, without compromising database performance. Easily manage how users and roles access data to support workloads in complex organizations and regulated environments.

Role-Based Access Control (RBAC)

Role-Based Access Control (RBAC)

Efficiently manage simple or robust security configurations by user role and group while maintaining maximum performance
Auditing

Auditing

Database logging writes all activities to a secure external location to support information security tasks such as tracking user access.
Authentication

Authentication

Manage existing account access with PAM (Pluggable Authentication Module) and SAML authentication support

Compatibility with Your Existing Systems

Leverage the MySQL wire protocol or JDBC/ODBC interface to integrate MemSQL with the most popular data services and software tools. Deploy anywhere including on-premises or any cloud for ultimate infrastructure flexibility.

Deploy
Cloud
On-Premises
Bare Metal
Bare Metal
Docker
Docker
VMWare
VMWare

What MemSQL Customers are Saying

Gartner gathered this feedback from MemSQL customers as part of a third-party study.
Learn more about Customer Success Stories.