Home

/

Database Software

/

SingleStore

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.
Overview
Reviews
SingleStore

SingleStore 2026: Benefits, Features & Pricing

On this page
  • Overview
  • User Interface
  • Popular Alternatives
  • Pricing and Plans
  • Features
  • User Reviews
  • Popular Comparisons

Overview

SingleStore
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.

Wondering if SingleStore is right for your organization?

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

Software Advice Logo

SingleStore User Interface

0
0
1
2
3
4
5

SingleStore Pricing and Plans

Free Trial
Free Version

Basic

Pricing available upon request

No plan information available

    Advisor Get Price CTA Image

    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

    5

    59%

    4

    36%

    3

    5%

    2

    0%

    1

    0%

    Secondary Ratings

    Ease of Use

    4.5

    Value for money

    4.2

    Customer support

    4.3

    Functionality

    4.5

    VR
    Verified
    Reviewer

    Education Management

    501-1000 employees

    Used daily for less than 12 months

    Review source

    Reviewed October 2019

    MemSQL distributed DBMS

    4

    hardware are needed according to cluster requirements

    Ratings Breakdown

    3
    Ease of use
    4
    Value for money
    5
    Customer support
    5
    Functionality
    icon
    Pros:
    faster and scalable .. it runs as a distributed cluster thats why it is faster
    Cons:
    it is not free ...and not popular among users although it is useful

    Read More

    JN
    Joel N.

    Verified reviewer

    Oil & Energy

    5001-10000 employees

    Used daily for more than 2 years

    Review source

    Reviewed October 2019

    Best in memory SQL offering available

    5

    MemSQL has helped us enable significant business value through a simplified data lake system. Large amounts of IOT data (trillions of rows) can be queried in milliseconds. In addition business databases with processes (running on similar hardware) that took hours to run and now running sub-second on MemSQL. The path to get to where we are was not easy, but MemSQL was alongside us all the way.

    Ratings Breakdown

    5
    Ease of use
    5
    Value for money
    5
    Customer support
    5
    Functionality
    icon
    Pros:
    1. Amazing Performance. 2. ANSI and PL SQL compatibility. Enables easy transition from traditional databases to MemSQL. 3. Highly and easily Scalable 4. Easy to setup, easy to work with. 5. Great support.
    Cons:
    Lack of Incremental backups, No Failback of replications. Lack of transaction logging. Lack of recoverable snapshots. (All these are near term upcoming features in MemSQL though)

    Reasons for choosing SingleStore

    Simple, Legacy compatible, performance

    Reasons for switching to SingleStore

    Performance

    Read More

    us
    udayakumar s.

    Verified reviewer

    Retail

    10000+ employees

    Used daily for more than 2 years

    Review source

    Reviewed September 2019

    Good inMemory DB but not great Customer Support

    4

    Overall we like the products but some important features are lacking.

    Ratings Breakdown

    5
    Ease of use
    3
    Value for money
    2
    Customer support
    4
    Functionality
    icon
    Pros:
    I like the way how it solves both being an In-memroy DB and Relational at the same time .. most of the In-Memory products are not relational. Query Response time are good.
    Cons:
    Not Good customer support, Even for PROD-Sev1 issues it's difficult to get on-call representative support. Lacking Two way DB replication for DataCenters.

    Reasons for choosing SingleStore

    Being and In-memory Relational DB.

    Reasons for switching to SingleStore

    Need of In Memory Relational DB

    Vendor Response

    I'd love to learn more about your support experience and escalate your concern so we can better serve users in the future. Can you reach out to community@memsql.com so we can learn more?

    Replied October 2019

    Read More

    AQ
    Ahmad Q.

    Verified reviewer

    Government Administration

    11-50 employees

    Used daily for more than 2 years

    Review source

    Reviewed October 2019

    Best Distributed RDBMS Ever!

    5

    So far MemSQL was able to handle all types of workloads we applied to it, executing blazing fast queries against tables with real-time data ingestion. Some of the features we use and are extremely helpful are json support and full-text search, which allowed us to ingest millions of documents every day and run sophisticated dashboards against them

    Ratings Breakdown

    5
    Ease of use
    5
    Value for money
    5
    Customer support
    5
    Functionality
    icon
    Pros:
    1. Lightening speed queries 2. High speed, high throughput, real-time data ingestion and queries. Thanks to the pipelines 3. Scale out very easily with no limit 4. In-memory tables for high OLTP workloads, and on-disk columnar storage for OLAP workloads 5. Short learning curve. drop-in replacement to the famous MySQL DB 6. Full-text search 7. Free edition is available
    Cons:
    I really can't think of much here. I advise MemSQL to accelerate adding features to the MemSQL studio

    Reasons for choosing SingleStore

    Achieved the highest performance, short learning path, familiar syntax, compatibility with almost all products in the market as it support MySQL wire protocol. Cost effective Excellent support team

    Reasons for switching to SingleStore

    1. Performance 2. Maintenance 3. Cost

    Read More

    KS
    Kai S.

    Verified reviewer

    Marketing and Advertising

    1001-5000 employees

    Used daily for more than 2 years

    Review source

    Reviewed October 2019

    Great replacement for Hadoop for a fraction of the cost

    4

    We needed freshly aggregated stats for our realtime bidding logs. Hadoop Hive was taking over 2 hours to perform the aggregation. After migration to MemSQL we were able to aggregate the stats within 20 minutes.

    Ratings Breakdown

    5
    Ease of use
    4
    Value for money
    5
    Customer support
    5
    Functionality
    icon
    Pros:
    Deployment was quick and painless. Works well with existing SQL-based data pipelines. We replaced our expensive and difficult-to-maintain Hadoop cluster with MemSQL and a fraction of the cost.
    Cons:
    There were some stability issues early on with the product, however, the support team was proactive in addressing our issues and providing fixes in later releases. Synchronization with an external MySQL meta-database is not straightforward, and we had to build our own custom synchronization scripts.

    Reasons for switching to SingleStore

    Cost of maintaining a Hadoop cluster with 2 devops engineers.

    Vendor Response

    So glad you're getting such exceptional performance.

    Replied October 2019

    Read More

    ND
    Naveenraj D.

    Verified reviewer

    Telecommunications

    11-50 employees

    Used daily for free trial

    Review source

    Reviewed April 2022

    SingleStore Data Performance

    5

    SingleStore is much useful for Real-Time data Analytic and Reporting feature and that is the key feature we looking towards Relational Database For local testing it is considerable that it consume too much memory consumption and that area is need to be improved to bring best out of it towards developer point of view.

    Ratings Breakdown

    5
    Ease of use
    5
    Value for money
    5
    Customer support
    5
    Functionality
    icon
    Pros:
    It has faster query result in RDBMS platform along with high availability with the possibilities of loading data from different sources with real time data support. It has unique ingest capability to do parallel ingest of data from different sources with distributed and partition feature with M-S architecture. This standout SingleStore from others.
    Cons:
    I believe it should have better User interface to support dynamic query creation along with that if it provide powerful Data virtualization options that would be nice.

    Read More

    IV
    Ivan V.

    Verified reviewer

    Entertainment

    1001-5000 employees

    Used daily for more than 2 years

    Review source

    Reviewed October 2019

    Horizontally scalable relational database

    5

    - online segmentation of users - monitoring - data science

    Ratings Breakdown

    5
    Ease of use
    5
    Value for money
    5
    Customer support
    5
    Functionality
    icon
    Pros:
    - horizontally scalable relational database - huge performance win comparing to on-prem alternatives - easy to setup on k8s - easy to connect to kafka
    Cons:
    - cross data center replication requires manual intervention on failover

    Reasons for choosing SingleStore

    Used by company competitors

    Reasons for switching to SingleStore

    - scalability - performance

    Read More

    SS
    Sanjaya kumar S.

    Verified reviewer

    Computer Software

    51-200 employees

    Used daily for more than 2 years

    Review source

    Reviewed October 2019

    Excellent

    5

    Excellent working with Memsql database. We are within our SLA.

    Ratings Breakdown

    5
    Ease of use
    5
    Value for money
    4
    Customer support
    5
    Functionality
    icon
    Pros:
    Fast query processing and child agg and master agg works super
    Cons:
    Memsql ops does not work real time some times.

    Reasons for choosing SingleStore

    faster query processing result and familiar with mysql client.

    Reasons for switching to SingleStore

    faster query processing result

    Read More

    AA
    Adrian A.

    Verified reviewer

    Financial Services

    201-500 employees

    Used daily for more than 2 years

    Review source

    Reviewed September 2019

    i dont need the gift card :)

    5

    R&D, installation, administration, new features R&D

    Ratings Breakdown

    5
    Ease of use
    5
    Value for money
    5
    Customer support
    5
    Functionality
    icon
    Pros:
    fast, reliable, stable, works perfect on Linux replication is fast and too easy to set up :)
    Cons:
    geez ... I really don't know. I am really thinking of something I don't like but nothing comes to mind. I have been doing administration for ... a few good years now.

    Reasons for choosing SingleStore

    Because the R&D was promising.

    Reasons for switching to SingleStore

    Mangement made me switch.

    Read More

    TY
    Todd Y.

    Verified reviewer

    Information Technology and Services

    201-500 employees

    Used daily for more than 2 years

    Review source

    Reviewed October 2019

    memsql

    4

    good

    Ratings Breakdown

    4
    Ease of use
    2
    Value for money
    3
    Customer support
    4
    Functionality
    icon
    Pros:
    Performance is good and it is a relational database
    Cons:
    support is limited. there are not too many tutorial/forum etc.

    Reasons for choosing SingleStore

    Reputation

    Reasons for switching to SingleStore

    Performance

    Read More

    Showing 1 - 10 of 39 Reviews

    Other Top Recommended Database Software

    Google Cloud
    Google Cloud

    4.7 (2249)

    Recently recommended 0 times

    Airtable
    Airtable

    4.6 (2218)

    Recently recommended 0 times

    MySQL
    MySQL

    4.6 (2093)

    Recently recommended 0 times

    Microsoft SQL Server
    Microsoft SQL Server

    4.6 (1973)

    Recently recommended 0 times

    Advisor Get Price CTA Image

    Stuck Between Options?

    Our experts can help you compare SingleStore with other top options, so you can find the best fit for your needs.

    See what companies are saying about Software Advice