MemSQL logo
MemSQL logo

MemSQL

By MemSQL

Certified enterprise ready

Cloud-native, operational database built for SPEED, SCALE and SQL. 10X the performance at 1/3rd the cost of traditional database providers.

*Requires OpenShift to install

Software version

7.1

Type

Operator

A distributed, highly-scalable SQL database that can run anywhere. We deliver maximum performance for transactional and analytical workloads with familiar relational models. 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.

Streaming and Batch Data Ingestion

Real-time parallel data ingestion from cloud data sources such as Kafka, Spark, S3, file systems and object stores.

Latency-Free Analytics

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

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

Easily Deploy Clusters Anywhere

A fully cloud-native database that supports on-premise and multi-cloud/hybrid cloud architectures.

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.

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.

Pricing summary

Plans starting at

View all pricing options

Annual subscription based on per node deployment

Node defined as up to 32 GB RAM or up to 8 CPUs

Install and run MemSQL on-premises or in the cloud, anywhere you run Linux

Additional resources

Want more product information? Explore detailed information about using this product and where to find additional help.

Reviews

Read what others are saying about this product in our review section.

Showing 1-5 of 60

  • Sujay K.

    Sujay K.

    Senior Manager, Data Engineering - Data & AI at Malwarebytes

    Verified Current User
    Review source: Organic
    Verified Current User
    Review source: Organic
    (0)Dec 27, 2019

    "Checked - One solution for Streaming Analytics on Big Data"

    What do you like best?

    - Super simple, we implemented the whole of our customer-facing streaming analytics data store in a 2-day hackathon - Natively integrates with AWS & other services (we are a multi-petabyte S3 shop with huge Kafka clusters) - Since most of it is SQL, anyone can hit the ground running in no-time, an ultra-low barrier to entry - We saw a sub-second response on a test case with 1000 concurrent heavy API calls (scanning billions of rows across many tables + window functions etc) along with applying RBAC functionalities on the fly - Incredibly fast out of the box, basic performance tuning will suffice 95% of use cases - Fantastic partners to work with, super helpful, we have access to their core engineering team, +100 on Customer engagement!

    What do you dislike?

    In my humble opinion, it solved a very unique hard problem for us elegantly (without having to compromise on any architectural or data principles). Problem of streaming analytics on high-velocity high volume data sets with sub-second API responses can be a handful. For me, this along with other use-cases they mention is their core strength. So anything beyond these capabilities is a "Nice to have" for me. Their roadmap covers most of what the community is asking - hot back-up's, better UI, modelling etc.

    Recommendations to others considering the product:

    They offer a free trial, definitely try - you will not be disappointed with what you see.

    What problems are you solving with the product? What benefits have you realized?

    Problem of streaming analytics on high-velocity, high volume data sets with sub-second API responses. This product elegantly solves the problem.

  • DF

    Daniel F.

    Verified Current User
    Review source: Organic
    Verified Current User
    Review source: Organic
    (0)Oct 08, 2019

    "Incredibly fast performance for dashboards!"

    What do you like best?

    We have had excellent luck with ingest rates and the ability to do lightning fast counts and other general math on time based data sets. If you are already familiar with SQL you will have little trouble utilizing this platform. Although we have had few occasions to use it, paid support was quite responsive and helped us correct issues quickly. Toolset allows for quick builds and deployments and services have been stable over significant periods of uptime. MemSQL Ops dashboard also allows for at-a-glace view to determine if your cluster is generally healthy.

    What do you dislike?

    Although I have heard of some people have positive results, I would like to implement autoscaling with the ability to increase licensing cost only for the time a cluster is scaled. I will soon be looking into MemSQL's Helios product to see if that is a reasonable path forward for us.

    Recommendations to others considering the product:

    For our use case of doing math on time series data MemSQL has been a great success; if you are running basic SELECT statements and expect raw data in your results we didn't see as much of a speed increase but the ease of setting up a HA cluster is a definite bonus even then.

    What problems are you solving with the product? What benefits have you realized?

    MemSQL provides the backend for our realtime dashboard and alerts system. MySQL compatibility makes it easy to import/export data to other databases when needed.

  • Mohammad Sufiyan A.

    Mohammad Sufiyan A.

    Sr. Manager Fiserv/Manager at RBC

    Verified Current User
    Review source: Invitation from G2 on behalf of a vendor or affiliate
    Verified Current User
    Review source: Invitation from G2 on behalf of a vendor or affiliate
    (0)Sep 10, 2019

    "Fast and Furious"

    What do you like best?

    Having worked on the database for a quite a good time, I believe it is really going to be standing with its flag high. Its really fast, wonderful optimization, lots of flexibility and overall is very agile to git into the needs of small to large enterprises.

    What do you dislike?

    At present not many bloggers or its own forum which can really help the developers and architects for a quick resolution. Mostly relying on MYSQL posts to get the resolution.

    Recommendations to others considering the product:

    I would suggest them, if they have the below problems then they should start engaging the MemSQL and go ahead with a POC and see by themselves rather than just relying on feed backs and comments. The range of issues could be: 1) Scalability 2) Real Time integration 3) Real Time Datawarehousing 4) Highly performing BI Platform. 5) Structured and unstructured data handling 7) SLA breaches in Webservices to name a few which could be the trigger points.

    What problems are you solving with the product? What benefits have you realized?

    We are currently dealing with changing the existing solution of Wealth management on Sybase to MemSQL. Their primary problems is the scalability and the performance. We have realized both benefits at this stage and nearing to production implementation.

  • SV

    Sourabh V.

    Review source: Invitation from G2 on behalf of a vendor or affiliate
    Review source: Invitation from G2 on behalf of a vendor or affiliate
    (0)Sep 12, 2019

    "MemSQL - Faster Than Fast !!"

    What do you like best?

    I started using memsql last year and found that it is really quite easy to learn and work with MemSQL and unlike other databases you don't need extensive administrator activities to admin the memsql cluster and database per say. Apart from that when you start working with memsql, you can very well observe that the data storage and retrieval is quite fast and doesn't matter how many joins and complexities are involved in the queries, the query results are pretty fast. I also like the feature of memsql that the same DB system can be used for OLTP and OLAP purpose as well.

    What do you dislike?

    Many a times few things behave unique and different in memsql because of the settings of system variables which are set for the database, so user/developer needs to be aware of those variables. Example - Data truncation and data types conversion happen implicitly and provides different output depending on the system variables settings.

    Recommendations to others considering the product:

    Not really at this time except that one needs to be pretty sure about the requirements that anyone have about what they are looking for because MemSQL provides both row store and column store engine and they both are for different purpose.

    What problems are you solving with the product? What benefits have you realized?

    As an OLTP system which can be used for processing High transactions per second as the existing system was unable to handle the large amount of read and write transactions. All those writes were redirected to MemSQL for faster processing.

  • WP

    Walt P.

    Review source: Invitation from G2 on behalf of a vendor or affiliate
    Review source: Invitation from G2 on behalf of a vendor or affiliate
    (0)Sep 11, 2019

    "Scale and speed!"

    What do you like best?

    I love how we can get scale and speed out of this database technology. We have loaded data in volumes that have historically stopped other database technologies in their tracks. We also have integrated the Memsql with our data visualization software which streamlines our reporting channels.

    What do you dislike?

    I don't have any complaints at this point.

    Recommendations to others considering the product:

    Take the time to learn what is available specifically to MemSQL. The documentation available is incredibly helpful when making a determination about what we can do with MemSQL. It has been an invaluable piece of the puzzle for us when bringing junior developers online and up to speed about how things work with MemSQL.

    What problems are you solving with the product? What benefits have you realized?

    Creating and maintaining secure databases at scale for our company. We have found that we don't need to ask if the database can handle the volume when using memsql.