MemSQL is a scalable SQL database designed for transactional and analytical workloads that demand performance, consistency, and durability.The Database of NowTMcan 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.
Request a quote
MemSQL offers a free tier for clusters up to 4 nodes (not including Aggregator nodes) and up to 128 GB Memory Capacity. 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.
Download MemSQL for Free
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.
Book a Demo
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.