Frequently Asked Questions
To learn more about MemSQL, try running it today.Download Free
What is MemSQL?
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.
Is everything in Memory?
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.
What is the relationship between MemSQL and MySQL?
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.
Why is MemSQL based on SQL?
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.
When is MemSQL a good choice?
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.
How does MemSQL compare to Oracle?
How easy is it to install MemSQL?
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.
Let us go through your use case and give you a customized quote.Request a Quote
How much does MemSQL cost?
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.
What is included in the free version of MemSQL?
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.
What is included in the Enterprise Subscription?
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.
Integrations & Deployments
MemSQL is ANSI SQL compliant and MySQL wire protocol compatible, making it easy to connect with existing tools.
How do I connect with MemSQL?
MemSQL supports most MySQL-compatible clients and libraries such ODBC and JDBC drivers from MariaDB and MySQL.
What data sources does MemSQL work with?
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
Where can MemSQL be deployed?
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.
How does MemSQL scale?
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.