--- description: Review of SingleStore Software: system overview, features, price and cost information. Get free demos and compare to similar programs on Software Advice New Zealand. image: https://gdm-localsites-assets-gfprod.imgix.net/images/software_advice/og_logo-55146305bbe7b450bea05c18e9be9c9a.png title: SingleStore | Reviews, Pricing & Demos - SoftwareAdvice NZ --- Breadcrumb: [Home](/) > [Data Management Software](/directory/4230/data-management/software) > [SingleStore](/software/142744/memsql) # SingleStore Canonical: https://www.softwareadvice.co.nz/software/142744/memsql Page: 1 / 3\ Next: [Next page](https://www.softwareadvice.co.nz/software/142744/memsql?page=2) > 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. > > Verdict: Rated **4.5/5** by 39 users. Top-rated for **Likelihood to recommend**. ----- ## Quick Stats & Ratings | Metric | Rating | Detail | | **Overall** | **4.5/5** | 39 Reviews | | Ease of Use | 4.5/5 | Based on overall reviews | | Customer Support | 4.3/5 | Based on overall reviews | | Value for Money | 4.2/5 | Based on overall reviews | | Features | 4.5/5 | Based on overall reviews | | Recommendation percentage | 90% | (9/10 Likelihood to recommend) | ## About the vendor - **Company**: SingleStore - **Location**: San Francisco, US - **Founded**: 2011 ## Commercial Context - **Pricing model**: (Free version available) (Free Trial) - **Pricing Details**: Contact SingleStore for pricing details. - **Target Audience**: 51–200, 201–500, 501–1,000, 1,001–5,000, 5,001–10,000, 10,000+ - **Deployment & Platforms**: Cloud, SaaS, Web-based, Mac (Desktop), Windows (Desktop), Windows (On-Premise), Linux (On-Premise) - **Supported Languages**: English - **Available Countries**: United States ## Features - Access Controls/Permissions - Audit Trail - Authentication - Backup and Recovery - Data Analysis Tools - Data Dictionary Management - Data Discovery - Data Integration - Data Migration - Data Replication - Data Security - Data Storage Management - Data Virtualization - Data Warehousing - Database Conversion - High Volume Processing - Master Data Management - Monitoring - Multiple Programming Languages Supported - Performance Analysis ## Support Options - 24/7 (Live rep) - Chat ## Category - [Data Management Software](https://www.softwareadvice.co.nz/directory/4230/data-management/software) ## Related Categories - [Data Management Software](https://www.softwareadvice.co.nz/directory/4230/data-management/software) - [Generative AI Tools](https://www.softwareadvice.co.nz/directory/4616/generative-ai/software) - [Big Data Software](https://www.softwareadvice.co.nz/directory/3299/big-data/software) - [Database Software](https://www.softwareadvice.co.nz/directory/4512/database-management-systems/software) ## Alternatives 1. [Google Cloud](https://www.softwareadvice.co.nz/software/172144/google-cloud-platform) — 4.7/5 (2262 reviews) 2. [Snowflake](https://www.softwareadvice.co.nz/software/419926/snowflake) — 4.7/5 (96 reviews) 3. [Oracle Database](https://www.softwareadvice.co.nz/software/148636/oracle-database-cloud) — 4.6/5 (471 reviews) 4. [Atlantic.Net Cloud Platform](https://www.softwareadvice.co.nz/software/346368/atlantic-net-cloud-platform) — 5.0/5 (24 reviews) 5. [Amazon EC2](https://www.softwareadvice.co.nz/software/390324/amazon-ec2) — 4.7/5 (173 reviews) ## Reviews ### "MemSQL distributed DBMS" — 4.0/5 > **Verified Reviewer** | *12 October 2019* | Education Management | Recommendation rating: 9.0/10 > > **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 > > hardware are needed according to cluster requirements ----- ### "Best in memory SQL offering available" — 5.0/5 > **Joel** | *4 October 2019* | Oil & Energy | Recommendation rating: 10.0/10 > > **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) > > 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. ----- ### "Good inMemory DB but not great Customer Support" — 4.0/5 > **udayakumar** | *11 September 2019* | Retail | Recommendation rating: 7.0/10 > > **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. > > Overall we like the products but some important features are lacking. ----- ### "Best Distributed RDBMS Ever\!" — 5.0/5 > **Ahmad** | *18 October 2019* | Government Administration | Recommendation rating: 10.0/10 > > **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 > > 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 ----- ### "Great replacement for Hadoop for a fraction of the cost" — 4.0/5 > **Kai** | *9 October 2019* | Marketing & Advertising | Recommendation rating: 9.0/10 > > **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. > > 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. ----- Page: 1 / 3\ Next: [Next page](https://www.softwareadvice.co.nz/software/142744/memsql?page=2) ## Links - [View on SoftwareAdvice](https://www.softwareadvice.co.nz/software/142744/memsql) ## This page is available in the following languages | Locale | URL | | en | | | en-AU | | | en-GB | | | en-IE | | | en-NZ | | ----- ## Structured Data