Robust, Fast, and Scalable Database Solution
We are using SingleStore database as our main database in both production and non-production workloads. We are using both memory-based …
Starting at $0.69 per hour
View PricingOverview
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.
Recent Reviews
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
VP R&D, DevOps, and Products
Zoomd Technologies (Information Technology & Services, 51-200 employees)
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
Product Details
- About
- Integrations
- Competitors
- Tech Details
- Downloadables
- FAQs
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
- Amazon S3 (Simple Storage Service)
- Data Virtuality Pipes
- Zoomdata
- a Logi Analytics company
SingleStore Competitors
SingleStore Technical Details
| Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Linux |
| Mobile Application | No |
| Supported Countries | Global |
| Supported Languages | English |
SingleStore Downloadables
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.
Reviewers rate Performance highest, with a score of 9.8.
The most common users of SingleStore are from Small Businesses (1-50 employees).
Comparisons
Compare with
Reviews and Ratings
(89)Attribute Ratings
Reviews
(1-4 of 4)Companies can't remove reviews or game the system. Here's why
January 31, 2023
Stellar performance and amazing tech support
We use SingleStore to manage a large and complex analytical workload for multiple financial customers. SingleStore is the database behind our real-time user interface. SingleStore also hosts our dashboards that display a mixture of data computed dynamically at the time of display and pre-computed values generated when data is ingested. Our software allows users to track the performance of retirement plans, and to compare data across plans. Many of these operations are data-intensive and we've been able to roll out many new and often compute-hungry features since switching to SingleStore two years ago.
- Technical support is stellar -- far above and beyond anything I've experienced with any other company.
- When we compared SingleStore to other databases two years ago, we found SingleStore performance to be far superior.
- Pipeline data ingestion is exceptionally fast.
- The ability to combine transactional and analytical workloads without compromising performance is very impressive.
- Although backups are robust, better support for incremental backups would be nice to have.
- Support for IPv6 in the firewall settings for the cloud-based product would be useful.
- An interface for scheduling maintenance in the cloud-based product would be a great improvement, though I hear that's coming soon.
- Our data management costs are much lower with SingleStore.
- Our ability to roll out new (and often data-intensive) features is better with SingleStore.
- Great tech support and system management by SingleStore means that we do not need to dedicate an employee (or part of any employee) to running the database.
- Our software runs faster now that we use SingleStore.
SingleStore handles all our data. But this was also true of our previous provider because all our data is relational. However, we are considering some future features that might take advantage of SingleStore's ability to handle unstructured data, JSON columns, and so forth. One feature that we like about SingleStore is how easy it is to run queries across multiple databases. This was far from straightforward with our previous provider.
We looked at Microsoft Azure SQL, MariaDB, Vertica, and RedShift. Our criteria were cost and performance. We also needed compatibility with the Azure cloud as this is where our other systems were running. This was in 2020. After approximately three months of evaluation, we chose SingleStore. SijgleStore was also very supportive during the transition from our old provider to their environment.
7
We are mostly a company of engineers: development and QA. We also have product managers who use SingleStore.
We have no one in-house who needs to support SingleStore. We chose SingleStore because they do such a great job of removing the need for us to support the database cluster.
- Interactive user interface for our customers.
- Dashboards for our customers.
- Rapid data ingestion.
- We've been able to roll out some highly data intensive product features. It's a big win for our customers.
- We might use SingleStore's ability to host unstructured data, and to use JSON columns.
Yes
SingleStore replaced Azure SQL. We found SingleStore to have better performance and to be much less expensive.
- Price
- Product Features
- Product Usability
- Other
The main driver of our move to SingleStore was cost. SingleStore is very cost effective.
We'd do the same again: identify some possible solutions, load data to evaluate them, pick one or two that seem promising, port some of our code to them and do a deeper eval. SingleStore worked closely with us to help make the technical implementation relatively easy. This worked out well for us.
- Implemented in-house
Yes
First we evaluated SingleStore and other systems. Then we ported our queries to SingleStore. Then we moved one customer to SingleStore, followed later by our other customers.
Change management was a small part of the implementation and was well-handled
The biggest change was that our queries and stored procedures were written for Microsoft SQL Server. It was not an onerous task to port them over, but it needed to be done.
- We were using too many temp tables in our old code. Switched to 100% CTEs in the new code and SingleStore performance really took off!
- No Training
I watched some of SingleStore's online videos, which are very good. We also had two SingleStore people working closely with us to ensure that things went smoothly. We're just a small company so we were impressed to get such personal service.
We find the level of support in the standard product to be excellent.
No
There have been several occasions when tech support has pro-actively alerted us to something requiring attention, usually something that we would never have noticed.
- Code development is very consistent.
- Performance is predictable (and good).
- The hosted solution removes the need for an in-house person to manage the system.
- We integrated our own system (we are a software company)
All we needed to do was to port our queries and stored procedures from the Microsoft SQL Server flavor of SQL to the MySQL flavor that SingleStore uses. We have a lot of queries and stored procedures so this was a significant task, but it went smoothly.
- File import/export
- ETL tools
Work with the engineers that SingleStore assigns to help you.
We have tech support whenever we need it, 24/7, and a brief monthly meeting to make sure things are going smoothly. But we did not need to negotiate this -- it seems to be just the standard way that SingleStore treats its customers.
SingleStore is very engaged with us as a customer. There is no special way that we need to deal with SingleStore because they are very easy to deal with.
Yes
The upgrade went smoothly. There may have been a few seconds of downtime but we picked a time when our customers were unlikely to be using our system so I can't be sure that the system went down at all. There were no unexpected impacts of the upgrade.
- We got a new feature -- point in time recovery.
- The ability to schedule our own maintenance windows.
- Autoscaling of the cluster later this year.
No
No
March 16, 2022
SingleStore and multiple advantages
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
- Results driven product
- Cost effective
- satisfaction of the decision-makers
- lower operational complexity
I am very satisfied with SingleStore, it has met these objectives as announced, data management has become very easy with
first and important advantages is super fast, the million of data can be treated on Seconds
1
Software Engineer
1
Software Engineer
- Statistics
- Data treatment for Migration
Not Sure
- Price
- Product Features
- Prior Experience with the Product
October 25, 2021
SingleStore is the fastest database ever tested by us
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.
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.
- Increased customer satisfaction.
- Increased possibilities.
- Increased user engagement.
We have tested various SQL databases including SQL Server, PostgreSQL and MySQL (in different flavors) and SingleStore is easily 20x faster than any of them; depending on the query we have even seen 100x improvements for analytics queries. An analytical query on Aurora MySQL that takes 40s to run runs in <100ms on SingleStore without changes to query.
Fast query and real time analytics certainly have a positive impact on user/customer satisfaction, but predictive analytics are achieved through ML models.
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 concurrency, SingleStore can easily scale by just adding more CPUs to the cluster.
3000
Users from all functions you SingleStore, but not directly but as users of applications that heavily depend on SingleStore.
5
Our in-house people that support the SingleStore operations have an IT background. Skills required are:
- Basic Linux command line skills.
- Basic SQL skills.
- Infrastructure skills (setting up servers and firewalls).
- Analytics.
- Self-service.
- Business intelligence.
August 02, 2016
SingleStore DB (formerly MemSQL) backup Spark
SingleStore DB (formerly MemSQL) is used as a persistent storage solution for Spark. We use SingleStore DB (formerly MemSQL) spark connector (Scala code) to bridge two techs. I am leading projects of using spark and SingleStore DB (formerly MemSQL) to process life science data. It solved the spark storage issue.
- Faster query speed than traditional SQL database.
- It con server in the pipeline to deal with streaming data with Kafka, spark streaming and SingleStore DB (formerly MemSQL).
- It is very scalable.
- Better tuning of SingleStore DB (formerly MemSQL) performance on Scale-up server
- SingleStore DB (formerly MemSQL) connection between spark failed when more than around 48 partitions data processing
- Provide faster python API for invoking SingleStore DB (formerly MemSQL)
- It offers me solution to solve spark storage problem.
- It adds more complexity of my application since multiple tech softwares are involved.
- More types of bugs will be encountered when doing streamliner, including hardware connection.
I have tried using CSV as a back-end storage, yet I/O is very heavy, direct transit from spark to SingleStore DB (formerly MemSQL) in memory really beats.