Get Started with
The No-Limits DatabaseTM

Operational Analytics
Built to deliver “Insights with an SLA” for apps and analytical systems
Predictive, ML & AI
Effortless operation of models at scale across streaming & historical data
Move to Cloud
Easily shift operational workloads to the cloud at the best price & performance
How MemSQL Works

A Data Platform Purpose-Built for Breakthroughs


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
Amazon Web Services
Amazon Web Services
Microsoft Azure
Microsoft Azure
Google Cloud Platform
Google Cloud Platform
On-Premises
Bare Metal
Bare Metal
Docker
Docker
Kubernetes
Kubernetes

Ingest

Relational
Oracle
Oracle
SQL Server
SQL Server
Postgres
Postgres
Streaming
Apache Kafka
Apache Kafka
Apache Spark
Apache Spark
HDFS
HDFS

Analyze

Query
ANSI SQL
ANSI SQL
JSON
JSON
Geospatial
Geospatial
BI Tool
Tableau
Tableau
Looker
Looker
Zoomdata
Zoomdata
This is a sample of MemSQL integrations. To see how we fit with your systems, please Contact Us

Frequently Asked Questions

MemSQL is a scalable SQL database designed for transactional and analytical workloads that demand performance, consistency, and durability. The no-limits relational database can perform as a transactional system and data warehouse in a single integrated architecture for accelerating legacy data architectures or enabling new data intensive applications.
No. MemSQL utilizes both memory, flash, and spinning disk. MemSQL uniquely accelerates ingest and query performance with memory optimized tables to deliver persistence with full ACID compliance, high availability, and disaster recovery so your data is always accessible.
MemSQL is a next generation, distributed database built from the ground up for maximum performance for transactions and analytics. The MemSQL server includes its own storage engine and SQL-based execution engine built around scalable distributed execution and lock-free data structures. MemSQL and MySQL servers do not share any code, but MemSQL is compatible with MySQL client software. MemSQL uses the same wire protocol as MySQL and supports similar SQL syntax as MySQL for easier compatibility.
MemSQL was designed to support modern data-intensive applications and real-time analytics while being able to be easily used with existing tools, applications, and skills. SQL is a proven, pervasively used language for writing and retrieving data. It provides rich descriptive capabilities that are interoperable with a large ecosystem of tools, is a straightforward skill to find and learn, and provides the easiest and fastest method to perform analytics.
MemSQL is a modern NewSQL database that efficiently manages multiple workloads including transactions and analytics in a single integrated relational SQL architecture. MemSQL gives applications maximum performance for real-time decisions and dynamic experiences. Common applications of MemSQL include IoT analytics, fraud detection, streaming media, portfolio analysis, personalization and recommendations, and other data intensive applications. Enterprises choose MemSQL for predictable performance across queries, data ingest, and demanding user concurrency requirements.
MemSQL can be installed in minutes on any Linux compliant system. We recommend using pre-defined Cloud Formation templates to quickly deploy on AWS EC2 environments. Customers can also deploy MemSQL in single and multi-node clusters. To see all the available installation options, please read our installation documentation.
MemSQL licenses software based on the total number of nodes provisioned. Note that Aggregator nodes are not included in the license cost. Customer installations range from a handful to hundreds of nodes. To give you the most accurate information on price, contact us to discuss your schemas, queries, and tables together.
MemSQL offers a free tier for clusters up to 4 nodes, not including Aggregator nodes. Unlike other database providers, the freely downloadable version of MemSQL is full-featured and includes all the performance, security, and capabilities available in any version of our database. There are no time or deployment restrictions.
An Enterprise subscription comes with 24x7, ticket-based support and unrestricted memory usage (up to the contracted subscription amount) and is unrestricted on the number of nodes used. Updating MemSQL to an Enterprise subscription only requires updating the license key. No migrations or upgrades are required and can be done seamlessly without taking the database offline or impacting your application.
MemSQL supports most MySQL-compatible clients and libraries such ODBC and JDBC drivers from MariaDB and MySQL.
MemSQL supports several ways to ingest data. See more info here.
  • Batch loading API for one time loads
  • Streaming with exactly-once semantics from Apache Kafka, Amazon S3, Azure Blob, HDFS, and Linux filesystems
  • A high-throughput, bi-directional, parallelized MemSQL Spark Connector
MemSQL runs on any commodity hardware system running Linux. It can be deployed on-premises, in any cloud, or as-a-service. This provides complete flexibility for customers to control how they deploy their data analytics infrastructure.
MemSQL scales horizontally on cloud instances or industry-standard hardware, providing high throughput across a wide range of platforms. The distributed system automatically shards data among nodes in a cluster. You can add nodes and redistribute shards (also known as partitions) as needed to scale your workload. For high speed ingestion, MemSQL leverages parallel loading to maximize throughput.

About MemSQL

MemSQL is the No-Limits DatabaseTM for Modern Applications. Run both transactional and analytical workloads at scale with an integrated, familiar, durable SQL database
Learn More