SingleStore

SingleStore
Formerly MemSQL

Customer Verified
Top Rated
Score 9.3 out of 10
Top Rated
SingleStore

Overview

What is SingleStore?

SingleStore aims to deliver the world’s fastest distributed SQL database for data-intensive applications: SingleStoreDB, which combines transactional + analytical workloads in a single platform.
Read more

Recent Reviews

SingleStore and its Advantages

9 out of 10
March 26, 2022
Real-time Analytics and Reporting can be best used in cases as Single Store is very much efficient on faster and complex query processing. …
Continue reading
Read all reviews

How SingleStore Differs From Its Competitors

Consolidation

We use singlestoreDB for our products backend<br>We use it to store our user data as well the data on which we perform data quality checks with our ML algorithms.<br>By doing this we saved the cost of maintaining different database systems for our products data and the user input data on which we …
Continue reading

Consolidation

SingleStore I would say is easy to scale, deploy, and a future-ready database and I would recommend this to each and everyone in the DevOps community as it has got great capabilities to get deployed on the cloud and connect to your resources on the cloud makes it outstanding and a database for the …
Continue reading

Consolidation

I am very satisfied with SingleStore, it has met these objectives as announced, data management has become very easy with
Continue reading

Real-Time Analytics

This is one of the key features of SingleStore because of its performance gathering insights from data enables organization to have a better understanding of their customers, and have real time prediction.
Continue reading

Scalability

Implementing real-time dashboards was a challenge for us before. SingleStore has made it very easy to implement real-time dashboards and deal with data that changes very frequently.
Continue reading

Real-Time Analytics

Fast query and real time analytics certainly have a positive impact on user/customer satisfaction, but predictive analytics are achieved through ML models.
Continue reading

Scalability

We have increased our license size over time and have increased our cluster both through vertical as well as horizontal scaling. When we know there is going to be peak traffic, we have also increased sizes proactively just for a couple of days. Because more CPUs usually result in higher …
Continue reading

Scalability

Not much comment here: MemSQL can scale horizontally effectively, but with more of an in-memory model it is more expensive, so again I'd recommend scaling it for high performance (both latency and data freshness) cases.
Continue reading

Scalability

Scaling wasn't easy in MemSQL. It improved recently. We are mainly using it to bring in more and more data without affecting performance.
Continue reading

Scalability

The performance of SingleStore enables us to hit our SLAs for our customers in terms of reporting performance. Our old reporting platform would take minutes to return large reports whereas SingleStore can complete the reports in a matter of seconds.
Continue reading

Real-Time Analytics

It helps us our DBA team. It allows them to bring better service to developers.
In addition, it saves them time and as a developer, I am receiving responses from them in faster than we worked only with MySQL.
And I can see that DBA answers to developers contain (most of the time) great solutions
Continue reading

Scalability

If I will be honest, I am not familiar with MemSQL hardware but most of our features approved by our DBA team. Which means that memSQL provides an easily scalable DB.
Continue reading

Real-Time Analytics

SingleStores supports HTAP, making it possible to use databases as a source and for analytics at the same time without things like locking, etc. Our CRM, HR and sales database are now optimized to run in the HTAP mode in SingleStore. This saves us a lot of copying and/or recreating new databases …
Continue reading

Scalability

By default, the setup is already configured for high availability. By expanding, we just need to add the so-called leafs. Adding a leaf (server) can be done via scripts to ensure a fast and simple way to add more capacity.
Continue reading

Real-Time Analytics

Doing things (ingest + query) faster makes possible to test out scenarios faster and have an enhanced user experience. That is not possible with other technologies and the business is impacted because it cannot make timely decisions with slow insights
Continue reading

Scalability

Doing BI with [SingleStore (formerly MemSQL)] is incredibly satisfying. The core component of an analytics system is the database. [SingleStore] performs so well that our customers are able to think about new use cases which cannot be done with their legacy and traditional systems.
Continue reading

Real-Time Analytics

When using SingleStore [(formerly MemSQL)] for building back office apps which have dashboards in it you will find that you can query hundreds of rows without even noticing, so deep diving, drilling down into data will be a real satisfying experience for the final user. Creating predictive …
Continue reading

Scalability

Now with the use of SingleStore [(formerly MemSQL)] we can handle spikes in user transactions, in our industry we need to handle this spikes seamless, we’re not knowing when a merchant is going to launch a promotion or super deal which is going to increase the volume of transactions. Performance …
Continue reading

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of SingleStore, and make your voice heard!

Return to navigation

Pricing

View all pricing

OnDemand

$0.69

Cloud
per hour

Entry-level set up fee?

  • Setup fee optional
For the latest information on pricing, visithttp://www.memsql.com/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services
Return to navigation

Product Demos

SingleStore: The World's Fastest Database for Data-Intensive Applications
02:12
[r]evolution 2022: Main Keynote Session
52:28
[r]evolution 2022: ITDM & Business Leader Breakout Session
59:27
[r]evolution 2022: Developers & Engineers Breakout Session
01:00:12
Big Data Journey: Unifying and Modernizing Databases With Imperva and SingleStore
12:05
Return to navigation

Product Details

What is SingleStore?

The world’s leading brands rely on data to make the right business decisions, to deliver exceptional customer experiences, and to stay ahead of the competition. This reliance on data brings with it a need for simplicity, speed, and scale. SingleStore aims to deliver the world’s fastest distributed SQL database for data-intensive applications: SingleStoreDB. By combining transactional + analytical workloads, the vendor states that SingleStore eliminates performance bottlenecks and unnecessary data movement to support constantly growing, demanding workloads. Customers spanning every vertical, including many Fortune 500/Global 2000/Inc.5000 brands, choose SingleStore to unleash the power of their data and supercharge real-time data experiences for their customers.

SingleStore Videos

The World's Fastest Database for Data-Intensive Applications
The Real-Time Revolutionorld's Fastest Database for Data-Intensive Applications
Data-Intensive Applications in Action
Building a Database for Real-Time Applications
A Customer's Big Data Journey From One to Many Products Under a Single Platform

SingleStore Integrations

SingleStore Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsLinux
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

SingleStore aims to deliver the world’s fastest distributed SQL database for data-intensive applications: SingleStoreDB, which combines transactional + analytical workloads in a single platform.

Oracle Database, Microsoft SQL Server, and MongoDB are common alternatives for SingleStore.

Reviewers rate Performance highest, with a score of 9.6.

The most common users of SingleStore are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews

(1-25 of 25)
Companies can't remove reviews or game the system. Here's why
Rex Elardo | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
I was doing some data engineering for this one client, and I thought that migration would take up to two weeks. In the end, thanks to Single store I was able to get everything done in less than an hour! The learning curve was incredibly easy, and incredibly well documented!
  • Speed
  • documentation
  • efficiency
  • I would love an SDK
  • A CLI would be cool
  • Beyond that, the nodes work great! I was confused at first but then understood how each plan is different
If you have a massive database, then Singlestore is perfect for you! You can save lots of time on many projects, get everything faster :)
However, if you database is relatively small (under 1GB) then the value that SingleStore provides may not be there for you. Yes, even 1GB can take 15 minutes to upload sometimes but that is not awful.
Score 10 out of 10
Vetted Review
Verified User
It's our main data store. SingleStore replaced MySQL, PostgreSQL, Redis and Elasticsearch. It's being used for OLAP, OLTP, search and cache at the same time.
SingleStore has seriously decreased our infrastructure complexity, allowing us to move faster and with more confidence.
It has also allowed us to decrease infrastructure cost.
  • Mixing OLAP and OLTP in the same cluster
  • Support and customer success team really is great
  • OLAP performance
  • Predictable performance scaling with cluster resources
  • **Much** better monitoring
  • Alerting
  • Smaller clusters offerings
  • More granular scaling
  • Better search features
  • Multi language support for search
  • Slow query visibility and analysis in real production workload
It has transformed into my go to database software. The only scenario in which I wouldn't use or recommend it, is if their base managed cluster is too expensive and I don't want to managed it myself
Score 9 out of 10
Vetted Review
Verified User
We use singlestoreDB as our landing storage for our product. Our product provides insights in data and quality of data. For that we require fast ingestion feom sources like S3, GCS and Azure Blob. We extensively use singlestoreDB's PIPELINE function for ingesting data into SingleStoreDB. We ran our ML algorithms on the data stored on singlestoreDB. Which gave us really good results and helped optimize our algorithms by using some of its inbuilt features
  • Data ingestion from object stores
  • Storing data in row and columnar store
  • Data ingestion from S3 to singlestoreDB takes 6secs for 550K records with 30 columns
  • Data ingestion from JDBC sources
  • More robust and easy to use Integration with tools like spark
  • More options for setting up and doing PoC with singlestoreDB
singlestoreDB can be used for both staging data and creating marts on which ML algorithms can be run.
The most interesting part is their pipeline function which allows really fast and consistent ingestion of data. And setting up these pipelines is really easy with configurations for sources system creds.
Samiran Mudgalkar | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
The most important use case is to load huge files into a distributed database system within a short span of time without having memory and time complexities. Whenever there is a need of transferring data for ETL during the staging phase and data warehousing stage, the load should be transferred without a lot of resource usage. Especially in the cloud space, the lesser we use the resources, the more cost-effective it is.
  • UI design
  • Perfect SQL editor and faster query execution
  • Ease of pipeline creation for data loads
  • Need to have a place to create an admin user for the first information schema database. Because when we log in, we do not have admin access by default to the system.
  • The state of the pipeline is not available if the currently available load is finished, there is extra work to check if all your files in the current load are complete.
  • The Dashboard can be a bit more simplified than having a lot of details.
1. The one place where it is required the most is, during ETL processing where the resource utilisation is optimized and faster data load is achieved.

2. The places where it is not suited are, when the data load is very low and there is not much difference achieved while execution of data loads.
Ruslan Smirnov | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
SingleStore is perfect for running data analytics workloads due to how easy it is to get data in & out. The performance and ease of use of the product are almost unmatched, which saves us a tremendous amount of time over having to spin up custom RDS instances for data analytics.
  • I was amazed at the ability to connect to the cluster with third-party clients, including native vendor-supplied MySQL command line tools.
  • The ease of exporting data from an existing MySQL database and loading it into SingleStore is impressive.
  • Speed and ease of use. Everything is streamlined for you to hit the ground running with minimal learning curve.
  • The mysqldump file required some manual massaging before it could be ingested. This was expected, and I am surprised how little manual modification is needed, but nonetheless -- this could be improved.
  • Some GUI database tools (such as MySQL Workbench) have trouble connecting and need additional configuration.
Insofar, it seems perfect for data analytics workloads and ad-hoc queries against large datasets. What we particularly like is the ease with which data can be ingested, and the speed/performance of the product. Everything is very streamlined and in one place. I am not sure where it would be inappropriate as I haven't used it long enough, but so far I like everything.
Score 9 out of 10
Vetted Review
Verified User
Real-time Analytics and Reporting can be best used in cases as Single Store is very much efficient on faster and complex query processing. It is extremely fast on data ingestion from many sources (AWS, Azure,GCP, Files etc).
  • Faster query result as Relational Database.
  • High Availability.
  • Load data from one or more data sources.
  • Loads external data in real-time.
  • Distributed and partition feature with master-Slave architecture.
  • Load data from a file that is located on the filesystem.
  • Power up legacy database and support massive workload.
  • MySql Client can access MemSql with same query experience.
  • SingleStore has this unique ingest capability it can do parallel ingest of data from sources like S3, Azure Blob, GCS, Kafka.
  • Can be integration with Tableau for Data Visualization.
  • There should be powerful Data Visualization.
  • There can be a better Query Builder UI.
  • No implicit ordering of results by primary key.
SingleStore is very much recommendable. It has a lot of features like faster complex query execution, ANSI standard MySQL compatibility, high Data availability, and many more. Due to Distributed database architecture, the database can be scaled. It is also much useful for Real-Time data Analytic and Reporting. It powers up the legacy database and supports a massive workload.
Amarpreet Saluja | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
I am a DevOps Engineer and I work on Kubernetes, Cloud, I had a use case where I was working on creating a product that can calculate Kubernetes and cloud costs and represent it in that use case I was supposed to ingest data which was being populated in s3 to my database on which I can run queries, this using SingleStore could have been seem-less as it makes data ingestion from cloud simpler and since it helps running lot vol queries with smaller response time could have helped me lower the latency of my service.
  • Compatibility with S3 and data formats such as Parquet, JSON, and CSV
  • Can be Deployed on a Kubernetes Cluster and can be scaled seamlessly.
  • Great UI and support documentation available to look and work around.
  • Scale out capability
  • Fast data ingestion and queries
  • Can be used to lower the latencies of various services
  • Did not find support for User Defined Functions.
  • It opens a new query result tab and that feels irritating to me personally.
  • Lot of RAM required while running Developer instances locally.
Score 10 out of 10
Vetted Review
Verified User
the product currently is excellent, it deserves 10/10, just the fact of processing more than 1 million records in a few seconds, whatever in the import of the data or the requests, it is already a great advantage, that we the developers we never dreamed of that. I'm telling you about my experience, no vacuum, because I've had nightmares with large databases, and we have to play right and left to optimize response time It is really amazing. I've never in my life worked on such a fast database
  • super fast
  • execute complex query
  • the use of several types of database
  • availablity
  • sclability
  • open many SQL Editor in same time
  • wizard for object creation (table, view, procedure...)
  • link table from other database
It can be used on any need for data treatment:
• Development
• data analysis
• migration preparation
• for data processing•......
Santhosh Yamsani | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
I'd be using SingleStore as the POC Database so as to handle data ingestion and analysis of data with a big volume of E-Learning Data. We process the data for different tenants and provide recommendations based on the processing.
  • Handing and processing Json data types fastly ( Actually I worked on it particularly )
  • It is fast and reliable
  • Pay as you use. This is quite a good feature for the customers who have load only during peak hours and doesn't have load during non-peak hours.
  • It is easy to access and can be accessed from anywhere without VPN issues as it is a cloud-based solution.
  • It is very user friendly and all options are easily navigatable.
  • Errors are easily understandable if we go wrong anywhere while doing our operations
  • Fast retrieving and reading data with JSON Formats.
Pros: 1. It is easy to access and can be accessed from anywhere without VPN issues as it is a cloud-based solution. 2. Errors are easily understandable if we go wrong anywhere while doing our operations. 3. It is very user-friendly and all options are easily navigatable. Cons: We should have templates for pulling data from different sources so that we can directly use those templates and change the names in source names and we can easily import data from different sources
Anant Sirohi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
I'd be using SingleStore as the primary Database so as to handle real-time ingestion and analysis of data with big volume. The existing data model is working on processing batch data which is not much efficient and fast. I'll be ingesting the data from Kafka and because of the great compatibility of SingleStore with Kafka, I'll be using it to build reports on the top of the data.
  • super fast data ingestion and queries
  • commonly used formats such as csv, json and parquet are well supported
  • MySQL engine allowing the customers also to work easily
  • minimum administration needed
  • support team is quick and helpful
  • Every time i run a new query, it opens a new query result tab
  • Lot of RAM required while running Developer instances locally
  • limited information on the running queries
It would be really fast for OLTP workloads as compared to MySQL and can be used in this use case. While working on large datasets, I've experienced that SingleStore has much faster processing capabilities and is highly recommended in such scenarios.
Score 9 out of 10
Vetted Review
Verified User
SingleStore is super easy to implement and use. You can deploy a cluster in a matter of clicks. The UI is very intuitive, and everything is easy to configure even for a new user. The look and feel are very similar to any relational DB workbench. The source configuration is very easy. Other than the good HCI, the query engine is very fast and responsive, computes huge datasets, and delivers results in seconds. Compared to MySQL, it is fast, robust, and has a good IDE. I would definitely recommend it.
  • Responsive and intuitive UI.
  • Query engine is very fast.
  • Very easy to deploy clusters and use the database.
  • Execution plan can be shown when the query is running so that the user might get information of their running queries and where to optimize them
For making up heterogenous source connections, SingleStore is very helpful since it is very easy to configure data sources. Also, in the case of large datasets, the processing capabilities of SingleStore are much faster as compared to MySQL, both being relational databases.
Score 10 out of 10
Vetted Review
Verified User
I would use SingleStore databases on e-commerce websites where loads of data are being generated, and where you need a fast data collection to analyze user behaviors and provide real time recommendation.
  • Fast on intense data load
  • Few clicks away to have the environment setup
  • Easiness/speed to load data from different pipelines
  • Great speed on running complex queries
  • SQL Editor opens a new result tab on every query run
  • Consumption of RAM memory through browser if you have many queries
SingleStore environment is easy to adapt, it is extremely fast on collecting data from different sources (AWS, GCP or Azure), provides monitoring of activities and easy use multiple databases. It is good for analytical and recommendation based scenarios, and provides fast results on complex queries. In SingleStore platform queries execution open new tab result for each run, which makes it difficult to navigate over the results.
Anmol Maitra | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
  • Very easy to configure the SingleStore database.
  • Loading data was extremely easy and super fast. I loaded millions of records and it took a few seconds.
  • SingleStore seems to be an ideal database for real-time dashboards.
  • Not too many issues. Only one aggregate function I ran in the database took more than a minute to run, otherwise, performance on queries for millions of records was great.
I have worked on government projects where data is being updated frequently and data needs to be presented on a real-time basis on the dashboard for coordination, etc. SingleStore would be the most appropriate database for this use case.
Score 10 out of 10
Vetted Review
Verified User
We are using SingleStore as our primary analytics database within our own platform (called "Pulse"). The Pulse platform is used primarily in Siemens internally, but is also available to enterprises outside of Siemens.
We offer end to end reporting & analytics services and use SingleStore to power our dashboards and reports.
  • Performance.
  • SQL-interface.
  • Relational online analytical processing (ROLAP).
  • SQL completeness (e.g. triggers).
  • Performance tuning insides.
We have not found an analytical database faster than SingleStore. While our data volume per project is usually below 100 million rows, we expect reporting and analytics queries to be executed within 100ms so that dashboard users can interactively work with their data. So if you are looking for a truly fast analytical database, SingleStore is the right database to use (even though it is also crazy fast for OLTP workloads, but that is not our use case).
Score 9 out of 10
Vetted Review
Verified User
We use MemSQL for a particular slice of our OLAP use cases: client-facing UI dashboards that have solid query latency and data freshness requirements (generally 4 9s under 2 seconds, although we try to get under 1, and data replication and recalculation in under a second), and on small to medium size data sets (10s of GB for fact data, GBs or 10s of GBs of dimension data). It is currently owned by a data platform team that supports client-facing use cases from a number of product teams.
  • Data replication.
  • Joins.
  • Small data set processing in memory.
  • User defined functions.
  • Providing optimization options.
MemSQL is well suited for low latency, high data freshness use cases. It can scale significantly, although its in-memory usage does mean the cost of scaling to data size is higher, so I believe for very large data sets (double-triple digit TBs) where less performance (latency/freshness) is needed it may not be worth the cost. We've currently limited its usage to cases where the performance needs are very high.
Elad Gindi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
We are proud to say that SKAI is a data company and our main asset is our data. My department handles the Measurements data and other incoming data sources. SingleStore is used across the organization to do real-time calculations, supply fast loading grids and store massive amounts of data. In our department, users needed to configure pre-hand MetaData for the calculations that they are basing their decision on. Our nightly batches used to work extremely hard and waste valuable time and resources to make this data available the next day (while storing it both in raw form and aggregated) and any changes required a rerun of the batch. Today the clients can configure, change and get their aggregated data in almost real-time, while the data is being stored in SingleStore only in its raw form. It allowed us to add more calculations and more data and use fewer resources on our server-side and the added bonus is that our clients love it!
  • Real-time calculation.
  • Massive data storage.
  • Real-time updates and integration.
  • Scaling up (adding memory) takes a lot of time.
  • Real-time information about lags is limited.
If you need real-time calculation and reduce DB lags in production it's ideal.

If you're looking only for storage, I would pass.
Score 10 out of 10
Vetted Review
Verified User
We use SingleStore's managed solution as a data warehouse for the analytical analysis of quality metrics. We ingest data from Kafka and build reports on top of the data to inform our customers about various scenarios. We use hosted business intelligence tools to analyze data and answer both specific as well as open-ended questions that our customers may have.
  • Ingesting data from kafka at very high rates.
  • Easy to understand performance characteristics.
  • Hosted solution is bulletproof and always up.
  • Programming languages for ingest logic.
  • Ability to run in our own cloud accounts to save transit costs.
To get up and running quickly with a highly scalable and trusted database that can ingest data at high rates while still providing adequate query performance. We have found great use of MemSQL in heavy write, light read, and never update situations. I would strongly recommend SingleStore in that scenario.
August 10, 2021

Great product

Score 9 out of 10
Vetted Review
Verified User
We worked with MySQL and needed a faster solution that it will be easy to integrate with.
Right now, MemSQL is our main DB and serve all of our customers.
We are transferring data with MemSQL pipelines.
In addition we are collaborating multi DBs into clusters. It is very comfortable instead of MySQL
  • Query time
  • Very easy to MySQL customers to work with
  • Easy to transfer data from other data sources
  • IN operator at where clause
  • Multi key index at columnstore
  • Enable to run cross clusters query
1. If your code is written on top of SQL, it very easy to make to work with MemSQL.
2. If you need to improve your queries performance.
3. If your you don't need to create a lot of tables at online flow (means to create a table for another query).
Score 9 out of 10
Vetted Review
Reseller
SingleStore as the backbone for our Data Analytics platform

With SingleStore, we are able to replace multiple other databases and started migrating from on-premise to SAAS. As SingleStore provides both scenarios, the migration to the cloud will be a smart and simple one. We now use SingleStore for our data and analytics environment. As we now can use the pipelines towards our data lakes and send data via procedures into our tables, we have achieved the next step in our data management by adding additional metadata during the ingestion. Using text search and the geospatial functions adds more functionality than we had before in our previous databases. The performance and scalability are beyond our expectations.

  • The scenario to migrate on-premise and scale up to the cloud as a SAAS.
  • Using HTAP means we can now use our database for transactions and analytics.
  • The main language is similar to MYSQL, so our organization has already the knowledge to master the system.
  • The SingleStore academy is a good program to support our organization to master the environment.
  • Performance on large sets of data for analytics.
  • Row based and column based can be used and mixed.
  • Time series, geo spatial and text search function to add to our platform.
  • Scalability, so we can continue to deliver the same performance.
  • Does not yet support foreign keys.
Migrating existing databases to one instance, accelerate and scale-out existing data warehouses/analytics platforms. Replace HIVE for SingleStore, which will boost your overall performance and support your data management. Get ready for the cloud by using it on-premise, your own cloud/data center, or as a SAAS. The functionality is the same and migrating will be smooth.
Diego Montúfar | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
We build Data Warehousing solutions for our customers and provide consulting and resell license. [SingleStore (formerly MemSQL)] is a powerful technology which allows to solve most of the toughest data challenges within an organization. Its speed and flexibility makes it a key player in an organization's data innovation.
  • OLAP workloads
  • Fast query responses
  • Multiple use cases in one single database
  • Does not provide adequate support for data discovery apps, i.e. Power BI.
  • It would be great to have a native load balancing component for dealing with aggregator failure. Otherwise having a Child Aggregator becomes optional since not all the customers can afford an external balancing solution and does not feel confortable with switching between aggregators manually.
  • They used to have certifications and training in development and administration. That is very important to have, since other competitors does provide access to those sort of things and although they have free tutorials/videos, that doesn't provide an in-depth understanding.
[SingleStore (formerly MemSQL)] is not good for replacing a complete transactional legacy systems. Migration could be very painful.
It's highly recommended for BI and Analytics use cases though
Jacob Ortega | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Right now we’re using [SingleStore (formerly MemSQL)] in the whole core platform, we were looking for a database that could handle a huge amount of transactions at the same time without loosing any and have the reliability of writing and storing the records fast so other services can use the data for finalizing the transactions. Also we were aiming to have a product which could be used as a storage solution for Data Scientists and our back office platform.
  • The fastest speed for querying compared with traditional relational database
  • Support JSON and full text search which can be used by API’s
  • Nearly zero admin tasks once it’s running
  • You can use it’s data streaming pipeline with Kafka
  • It doesn’t provide redistribution when you reach the maximum node capacity
  • The Graphical Interface could have a revamp, it’s a little bit laggy
  • You cannot run it local so development should be made always using cloud instances
I think SingleStore [(formerly MemSQL)] should be used in every modern system which needs an analytical tool provided with the database, where performance matters and when you need fast scaling. The database is going to use a lot of resources so if the scenario is cost sensitive then perhaps is not the best solution in terms of infrastructure.
Darrin Thompson | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
We use it to power a custom reporting and analytics solution as part of a larger product offering we sell. It has low enough latency to power impressive dashboards for our end users.

  • Processes large amounts of data with very low latency.
  • The support department is fantastic.
  • The developer experience is lacking. Running developer instances locally requires a lot of RAM.
Low latency analytics or dashboards based on large numbers of records.

Near immediate time from record ingest to availability in large queries.
Score 10 out of 10
Vetted Review
Verified User
We use it to hold and query real estate listings in four states. This is the engine behind our website's and mobile app's main feature - property search. The queries have geospatial criteria. Because of the volume of records and complexity of queries, MemSQL was an obvious choise for it's performance. Now, as SingleStore offers collumnar storage, we can use it for other things like analytics and reporting.
  • Scaling - columnar storage makes it easy to scale without cost or signifigant performance hits
  • Speed - where performance is an issue, we can keep the data in RAM
  • Simplified management - Love MemSQL's web UI to manage clusters
  • I'm fine here - I think Single store is addressing needs (Managablility, Flexible maintenance windows, responsive tech support) nicely
  • I suppose reliability is an issue. I see the few causes behind this get fixed quickly and the platform becomes more dependable as it matures
I recommend where performance at scale is a priority
Very responsive to trouble tickets - Often, I think, the SingleStore's monitoring systems have already alerted the engineers by the time I get around to writing a ticket (about 10 - 20 mins after we see a problem). I feel like things are escalated nicely and SingleStore takes resolving trouble tickets seriously. Also SingleStore follows up after incidents to with a post mortem and actionable takaways to improve the product. Very satisfied here.
The web UI for managing and monitoring clusters is great.
Score 10 out of 10
Vetted Review
Verified User
We use SingleStore DB (formerly MemSQL) to store a real-time feed of all kinds of open source data. The data get full-text indexed, stored in start schema, and instantly ready for analysis. Multiple departments have access to multiple dashboards backed up with SingleStore DB (formerly MemSQL).
  • Ingesting high volume of data in real-time.
  • Excellent query performance (response in milliseconds).
  • Feature rich, json support, full-text search.
  • Minimum administration is needed.
  • Cross-cluster queries
  • SingleStore DB (formerly MemSQL) procedural SQL syntax can be simplified
  • Materialized views
  • Implementing recursion in queries
  • Tag cloud generator from a full-text index
SingleStore DB (formerly MemSQL) is good for a high-volume, real-time data feed, a high number of concurrent queries, and excellent for both OLAP and OLTP workloads. It's not good for unstructured data store.
The support team is very responsive and cooperative. Especially when it comes to urgent tickets or anything that might affect cluster availability. I've contacted the support many times during the past few years, and I never had a complaint about response time or an unresolved issue.
SingleStore DB (formerly MemSQL) covers a wide spectrum of use-cases and provides ANSI-SQL support, MySQL drop-in replacement.
It supports several deployment options--cloud, Helios, on-premise bare-metal or virtualized. Has drivers for many programming languages like Java and Python, for BI tools like Zoomdata and Tableau.
September 12, 2020

Awesome product

Score 9 out of 10
Vetted Review
Verified User
SingleStore DB (formerly MemSQL) is currently being used as the MPP DB for our data lake. We use it to ingest different information from the operational platform in order to enable it for app development and analytics. Using SingleStore DB (formerly MemSQL) allowed us to process a high volume of data since it has scalability by design. Memory management in SingleStore DB (formerly MemSQL) is very efficient and even on an infra level the cluster management is straightforward.
  • High data volume processing.
  • Operational data enablement.
  • Redistribution when a node is full.
  • Split processing data usage from data volume license.
The way SingleStore DB (formerly MemSQL) is designed is that the different table designs (columnstore, rowstore) give SingleStore DB (formerly MemSQL) the ability to accommodate any scenario, but this also depends on whether someone is willing to invest in SingleStore DB (formerly MemSQL) in simple cases, like master data management storage. SingleStore DB (formerly MemSQL) is good for complex event processing, and it may be seen as an over-engineering choice for simple stuff.
The team is always available, responsive, and quite helpful. It is clear by their answers that the support reps are experts in SingleStore DB (formerly MemSQL). They can deliver proper answers and understand the client's environment. I never had an issue that took them long to figure out. They are also ready to walk us through upgrades and have meetings whenever required.
I'm not a data architect so I wouldn't be able to answer this question from that side, but from my perspective, I would say that SingleStore DB (formerly MemSQL) never let us down. We have extremely complex use cases to join different tables with high volumes and the processing power of SingleStore DB (formerly MemSQL) always delivered.
Return to navigation