SingleStore 2026: Benefits, Features & Pricing

Software Advice offers objective insights based on verified user reviews and independent product and market research. When our advisors match you to a software provider, we may earn a referral fee.

How Software Advice ensures transparency

Software Advice lists all providers across its website—not just those that pay us—so that users can make informed purchase decisions. Users can talk to our advisors for free to receive software recommendations matching their needs. Software providers pay us for sponsored profiles to reach users interested in their products.

How Software Advice verifies reviews

Software Advice carefully verified over 2 million reviews to bring you authentic software experiences from real users. Our human moderators verify that reviewers are real people and that reviews are authentic. They use leading tech to analyze text quality and to detect plagiarism and generative AI.

Independent research methodology

Researchers at Software Advice use a mix of verified reviews, independent research, and objective methodologies to bring you selection and ranking information you can trust. While we may earn a referral fee when you visit a provider through our links or talk to an advisor, this has no influence on our research or methodology.

Wondering if SingleStore is right for your organization?

Our Database Software selection experts can help you in 15 minutes or less.

On this page

Overview
Pricing and Plans
Features
User Reviews

Overview

SingleStore

4.5

(39)

Pricing

Pricing available upon request

About SingleStore

SingleStore is a database management solution that helps government organizations and enterprises in the financial, media, energy, technology and retail industries leverage artificial intelligence (AI) and machine learning capabilities to handle operational analytics, internet of things (IoT), data ingestion and more. Professionals can handle workloads, back up data to Amazon S3 and utilize various business intelligence tools to perform ad-hoc analysis.

MemSQL allows organizations to analyze data in JavaScript Object Notation (JSON), Structured Query Language (SQL) and other formats. Administrators can configure users' access permissions, maintain an audit trail of internal logs and protect data via TLS encryption. Additionally, it lets managers store and index geographical data using geospatial object types.

MemSQL facilitates integration with various third-party systems such as Oracle, Tableau and more. The product is available for free and on a per-unit or per-node basis. Support is extended via live chat, documentation, email and other online measures.

SingleStore Screenshots

SingleStore Pricing and Plans

Starting price: Connect with an advisor for pricing

Free Trial

Free Version

Basic

Pricing available upon request

No plan information available

Confused about pricing? We've got you covered.

Get a personalized pricing breakdown tailored to your specific needs—no guesswork, no generic estimates.

SingleStore Features

Popular features found in Database
Backup and Recovery
Database Conversion
Data Connectors
Data Migration
Data Replication
Data Virtualization
Multiple Programming Languages Supported
Performance Analysis
Secure Data Storage
More features of SingleStore
Access Controls/Permissions
Audit Trail
Authentication
Data Analysis Tools
Data Dictionary Management
Data Discovery
Data Integration
Data Security
Data Storage Management
Data Warehousing
High Volume Processing
Master Data Management
Monitoring
Predictive Analytics
Real-Time Data
Relational Database Management

SingleStore User Reviews

Overall Rating

4.5

Ratings Breakdown

59%

36%

Secondary Ratings

Ease of Use

4.5

Value for money

4.2

Customer support

4.3

Functionality

4.5

Sujay K.

Verified reviewer

Computer & Network Security

501-1000 employees

Used daily for less than 2 years

Review source

Reviewed December 2019

Checked - One solution for Streaming Analytics on Big Data

Ratings Breakdown

Ease of use

Value for money

Customer support

Functionality

Pros:

- 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!

Cons:

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.

Reasons for choosing SingleStore

All the previous solutions we tried solved either one or few of the challenges in this use-case for us. Memsql covered almost all the focus areas without having to compromise on any architectural or data principles.

Reasons for switching to SingleStore

Brandon V.

Verified reviewer

Utilities

10000+ employees

Used daily for less than 2 years

Review source

Reviewed October 2019

Thoughts on MemSQL

Our primary use case for MemSQL is an enterprise data lake, which will also serve as a staging area for MemSQL data warehouses. They are currently being developed and are not in production yet. We're learning things as we go, but in general, development is going well and we're satisfied with the product.

Ratings Breakdown

Ease of use

Customer support

Functionality

Pros:

I appreciate that MemSQL is a distributed database that runs on commodity hardware and can be scaled out as opposed to some fixed, vendor-maintained appliances like Teradata. Columnstore is a valuable feature.

Cons:

The product is not fully mature. Although it uses the MySQL protocol, it does not always work with MySQL-compliant products. Some administrative functions such as incremental, point-in-time, and object-specific backups and restore are lacking. MemSQL is making progress in these areas, but it still has room to grow.

Reasons for choosing SingleStore

We considered NoSQL products such as Hadoop, but we wanted to leverage our existing SQL skillset.

Reasons for switching to SingleStore

We're not making a full switch and retiring Teradata immediately, but we're going to use it less and MemSQL more. We've had frustrations with developing and supporting Teradata. We prefer MemSQL's DR replication and included columnstore functionality, for example.

Vendor Response

Thanks for your feedback. We work hard every day to close any feature gaps between MemSQL and the older, legacy databases. Incremental Backup lands in version 7.0, and point-in-time restore is being actively developed, and is slated to land next year.

Replied October 2019

Verified

Reviewer

Information Technology and Services

10000+ employees

Used weekly for less than 12 months

Review source

Reviewed August 2022

Single store database features and performance.

I have worked with a project that based out of single store its holds like huge amounts of data and giving top notch performance for analysis and loading or transmission of data from one database to single store.

Ratings Breakdown

Ease of use

Value for money

Customer support

Functionality

Pros:

Single store basically is a mem-sql. Its comes with concept of shard key, partition and many more unique features that stand this out to any other relational databases. Its give a perfect SQL editor and faster query execution for sharding concept. Its store the data in either rows store or columns store based on the data set. The ease of exporting data from exiting My sql database and loading it into single store is very impressive it’s provided different kind of data loading concepts like data pipe like bloc file loading etc.

Cons:

Some time the connection of the GUI database tools such as my sql workbench having some issues it’s required some additional configuration for it its a little headache for user.Dashboard part bit confusing its content lots pf details other then that its perfect performance wise and feather wise i can say.

MOHAMMAD SUFIYAN A.

Verified reviewer

Information Technology and Services

10000+ employees

Used daily for less than 12 months

Review source

Reviewed October 2019

SUPERSONIC DB - SUPERB

I'll rate it at a full star. Having worked with almost all the databases, I can simply say it aces every database that I worked. The Transformation capabilities in LOAD command is something I have not seen anywhere which helps a lot along with capturing errors and rejects in the LOAD command.

Ratings Breakdown

Ease of use

Value for money

Customer support

Functionality

Pros:

Super fast and would have give a fair bit of competition to CONCORD Aircraft:). But seriously it is the Database of the new generation with huge potential for both On Premise and Cloud. High compatibility, resilience, scalability are some superb features to work on with it. Highly recommended to any Organization wanting to get rid of the Old fashioned drag on DBs.

Cons:

I don't have any particular dislikes, but would love to see its own Client interface, inbuilt Data Modelling capabilities and a superb front end which can help potentially any Developers or Programmers to start the development from Day 1. Secondly I would also like to see a proper Blogging web portal to help developers resolve their queries, issues faster.

Reasons for switching to SingleStore

Very expensive, developers find it hard to learn and also the scalability is not at par which I have see it with MEMSQL.

Vendor Response

Supersonic is a great description. Thank you. Have you tried MemSQL Studio, the web-based SQL editor and cluster monitor?

Replied October 2019

Manisha S.

Verified reviewer

Retail

10000+ employees

Used daily for more than 2 years

Review source

Reviewed September 2019

Very fast

Ratings Breakdown

Ease of use

Value for money

Customer support

Functionality

Pros:

fast response, perfect for real time apps

Cons:

documentation isnot too clear about what sits in memory and what on disk. even though all our tables were made to reside on disk, we were getting lots of usage alerts, took for ever to resolve.

Reasons for switching to SingleStore

Faster reads and aggs and ability to query on rolling index

Nir L.

Verified reviewer

Information Technology and Services

51-200 employees

Used daily for less than 12 months

Review source

Reviewed September 2023

Strong, robust and fast database engine

We are using SingleStore as our main database engine both for online transaction processing (OLTP) and for data warehousing. It has proved to be a robust database engine with great performance and many useful features.

Ratings Breakdown

Ease of use

Value for money

Customer support

Functionality

Pros:

Singlestore is a very strong relational database management system which produces very good results in terms of speed and robustness. It have many unique features that make it a good system for data consumption and processing. It is also API -compatible with MySQL dialect so you can use mysql-targeted tools to query data on SingleStore.

Cons:

It's not the cheapest engine you could get but generally, in terms of cost-value ratio, I feel it's a good match. Also, backup on a self-hosted solution is not always easy to implement since it needs to backup large amounts of data.

Verified

Reviewer

Information Technology and Services

Self-Employed

Used monthly for free trial

Review source

Reviewed April 2022

A review of few features requested by SingleStore

Note: This review was incentivized by SingleStore. I was paid to test few features, such as: Kafka integration, Ingestion and migration features. I was requested to write an honest review here after few hours and a 1 hour seminar. Therefore I do not have any significant experience with the tool, and this is like a newcomer's first experience review.

Ratings Breakdown

Ease of use

Customer support

Functionality

Pros:

I loved the simplicity in general. It was easy to use the guides, and to follow the documentations I encountered. In some cases I dug a bit deeper just to try to find some mistakes, but for example the password is not displayed if I request the system to echo back the Kafka connection details I set up. It could have been a security issue, but they were obviously aware of this and they made sure it is not possible. The specific things I liked is the ingestion speed is lightning fast. And to set up a Kafka linked table (real time message data in a table!) is as easy as it can possibly be.

Cons:

The support. The chat is although quick and efficient, I had no issue to explain that I want a copy of the "Replicate" tool, to do similar actions that was shown on a video. The agent confirmed he understood correctly what I said, and that he needs to escalate this as I was a trial user. But of course given I was hired by them they will probably make an exception. But I was shocked that a week later I got a very generic reply and a link to an unrelated page. Like only the higher topic was understood, and all my request to have a copy of the Replicate tool was lost. I reported my disappointment towards SingleStore, and after all they are working on improving this mow. It is uncomfortable to leave this story here but necessary to understand I believe that with Support you can have hiccups and you might need to repeat yourself.

Verified

Reviewer

Financial Services

10000+ employees

Used daily for more than 2 years

Review source

Reviewed September 2019

MemSQL : Needs Time to Mature

This is a good software but needs to mature more for an enterprise level

Ratings Breakdown

Ease of use

Value for money

Customer support

Functionality

Pros:

Similar to existing RDBMS Supports join In Box implementation with Spark Salable & manageable with memSQL ops

Cons:

Security Features Consistency Overflow on Disk

Reasons for choosing SingleStore

Cost & future roadmap

Reasons for switching to SingleStore

Scalability & Growing Cost

Shane T.

Verified reviewer

Computer Software

5001-10000 employees

Used daily for less than 12 months

Review source

Reviewed September 2019

MemSQL-6 Administrator Training

MemSQL solves our DBMS need for fast updates to storage, alert on comp nodes and IP delivery.

Ratings Breakdown

Ease of use

Value for money

Customer support

Functionality

Pros:

When synchronizing permissions to child aggregators, only non-root users are affected. It has real-time processing features, and a child aggregator can be set as master if necessary.

Cons:

If a leaf fails it takes the Matser Aggregator 10 seconds to promote the slave partitions from paired leaf.

Syed Muneeb H.

Verified reviewer

Information Technology and Services

1001-5000 employees

Used weekly for less than 6 months

Review source

Reviewed April 2022

Delivers more than expected!

The overall experience is super awesome! I would highly recommend this product for all sorts of data processing and analytical needs. The business problem that I face on day to day basis is the need for processing tons of data in minimal time to optimize the overall ETL operations and make the data available for further analysis to carry out necessary business-critical decisions. Therefore, I always feel the need to use a product that is not only easy to configure and use but also super-efficient in handling huge data volumes. Since we are progressing towards a more dynamic environment, I think we should be able to make a more robust and adaptable system that would allow systematic or data changes easy to build and configure.

Ratings Breakdown

Ease of use

Value for money

Customer support

Functionality

Pros:

Easy to configure and use. And on top of it, is the efficiency in which the SingleStorm delivers the results and displays the output.

Cons:

Using SingleStorm is super easy. I have not found any shortcomings in the platform yet.

Showing 1 - 10 of 39 Reviews

See All Reviews