All SingleStore Reviews
1-25 of 26 Reviews
Sort by
Sujay
Verified reviewer
Computer & Network Security, 501-1,000 employees
Used daily for less than 2 years
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
5
CUSTOMER SUPPORT
5
FUNCTIONALITY
5
Reviewed December 2019
Checked - One solution for Streaming Analytics on Big Data
- 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!
CONSIn 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.
Reason 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
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.
Brandon
Utilities, 10,000+ employees
Used daily for less than 2 years
OVERALL RATING:
4
EASE OF USE
4
CUSTOMER SUPPORT
5
FUNCTIONALITY
4
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.
PROSI 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.
CONSThe 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.
Reason 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
Anonymous
10,000+ employees
Used daily for more than 2 years
OVERALL RATING:
3
EASE OF USE
4
VALUE FOR MONEY
1
CUSTOMER SUPPORT
2
FUNCTIONALITY
3
Reviewed September 2019
MemSQL : Needs Time to Mature
This is a good software but needs to mature more for an enterprise level
PROSSimilar to existing RDBMS Supports join In Box implementation with Spark Salable & manageable with memSQL ops
CONSSecurity Features Consistency Overflow on Disk
Reason for choosing SingleStore
Cost & future roadmap
Reasons for switching to SingleStore
Scalability & Growing Cost
MOHAMMAD SUFIYAN
Information Technology and Services, 10,000+ employees
Used daily for less than 12 months
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
5
CUSTOMER SUPPORT
5
FUNCTIONALITY
5
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.
PROSSuper 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.
CONSI 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
Retail, 10,000+ employees
Used daily for more than 2 years
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
4
CUSTOMER SUPPORT
4
FUNCTIONALITY
4
Reviewed September 2019
Very fast
fast response, perfect for real time apps
CONSdocumentation 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
Joel
Oil & Energy, 5,001-10,000 employees
Used daily for more than 2 years
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
5
CUSTOMER SUPPORT
5
FUNCTIONALITY
5
Reviewed October 2019
Best in memory SQL offering available
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.
PROS1. 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.
CONSLack 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)
Reason for choosing SingleStore
Simple, Legacy compatible, performance
Reasons for switching to SingleStore
Performance
udayakumar
Retail, 10,000+ employees
Used daily for more than 2 years
OVERALL RATING:
4
EASE OF USE
5
VALUE FOR MONEY
3
CUSTOMER SUPPORT
2
FUNCTIONALITY
4
Reviewed September 2019
Good inMemory DB but not great Customer Support
Overall we like the products but some important features are lacking.
PROSI 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.
CONSNot Good customer support, Even for PROD-Sev1 issues it's difficult to get on-call representative support. Lacking Two way DB replication for DataCenters.
Reason 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
Kai
Marketing and Advertising, 1,001-5,000 employees
Used daily for more than 2 years
OVERALL RATING:
4
EASE OF USE
5
VALUE FOR MONEY
4
CUSTOMER SUPPORT
5
FUNCTIONALITY
5
Reviewed October 2019
Great replacement for Hadoop for a fraction of the cost
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.
PROSDeployment 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.
CONSThere 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
Nir
Verified reviewer
Information Technology and Services, 51-200 employees
Used daily for less than 12 months
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
5
CUSTOMER SUPPORT
5
FUNCTIONALITY
5
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.
PROSSinglestore 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.
CONSIt'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.
Anonymous
1 employee
OVERALL RATING:
5
EASE OF USE
5
CUSTOMER SUPPORT
3
FUNCTIONALITY
5
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.
PROSI 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.
CONSThe 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.
Ahmad
Government Administration, 11-50 employees
Used daily for more than 2 years
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
5
CUSTOMER SUPPORT
5
FUNCTIONALITY
5
Reviewed October 2019
Best Distributed RDBMS Ever!
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
PROS1. 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
CONSI really can't think of much here. I advise MemSQL to accelerate adding features to the MemSQL studio
Reason 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
Ivan
Entertainment, 1,001-5,000 employees
Used daily for more than 2 years
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
5
CUSTOMER SUPPORT
5
FUNCTIONALITY
5
Reviewed October 2019
Horizontally scalable relational database
- online segmentation of users - monitoring - data science
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
Reason for choosing SingleStore
Used by company competitors
Reasons for switching to SingleStore
- scalability - performance
Sanjaya kumar
Computer Software, 51-200 employees
Used daily for more than 2 years
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
5
CUSTOMER SUPPORT
4
FUNCTIONALITY
5
Reviewed October 2019
Excellent
Excellent working with Memsql database. We are within our SLA.
PROSFast query processing and child agg and master agg works super
CONSMemsql ops does not work real time some times.
Reason for choosing SingleStore
faster query processing result and familiar with mysql client.
Reasons for switching to SingleStore
faster query processing result
Todd
Information Technology and Services, 201-500 employees
Used daily for more than 2 years
OVERALL RATING:
4
EASE OF USE
4
VALUE FOR MONEY
2
CUSTOMER SUPPORT
3
FUNCTIONALITY
4
Reviewed October 2019
memsql
good
PROSPerformance is good and it is a relational database
CONSsupport is limited. there are not too many tutorial/forum etc.
Reason for choosing SingleStore
Reputation
Reasons for switching to SingleStore
Performance
Tencza
Broadcast Media, 10,000+ employees
Used daily for more than 2 years
OVERALL RATING:
5
EASE OF USE
4
VALUE FOR MONEY
4
CUSTOMER SUPPORT
5
FUNCTIONALITY
4
Reviewed September 2019
Software and Support
We use memsql for our DB solution for cDVR. Your support personal have been very responsive and helped us resolve our issues. Ranging from a SEV1 to a SEV3 issue.
PROSEase of use Ease of troubleshooting and upgrading Supporting
CONSWe have had issues with Aggregators/Leafs failing over
Vendor Response
I'm so glad you've had such a positive experience with support.
Replied October 2019
prasad
Computer Software, 10,000+ employees
Used daily for more than 2 years
OVERALL RATING:
5
EASE OF USE
4
VALUE FOR MONEY
3
CUSTOMER SUPPORT
1
FUNCTIONALITY
3
Reviewed October 2019
Memsql is very good for big data development
it was a excellent experience. We were able to build big data pipelines fast.
PROSfastest in memory database. We have observed that it is very fast with queries,
CONSshould be able to keep more data in memory and do not break.
Praveen
Telecommunications, 10,000+ employees
Used weekly for less than 12 months
OVERALL RATING:
4
EASE OF USE
4
VALUE FOR MONEY
3
CUSTOMER SUPPORT
4
FUNCTIONALITY
4
Reviewed October 2019
Great product. Could be better at performance
Overall experience has been good and with good engineering principles, I'm sure MemSQL can overcome the performance challenges and can be a force to reckon with.
PROSgood product with good core competencies - scalable SQL database designed for transactional and analytical workloads, consistency durability etc
CONSPerformance challenges for in-Memory Database.
Reason for choosing SingleStore
Price points and durability
Jung
Internet, 51-200 employees
Used daily for less than 2 years
OVERALL RATING:
5
EASE OF USE
4
VALUE FOR MONEY
4
CUSTOMER SUPPORT
5
FUNCTIONALITY
5
Reviewed October 2019
Best of the both world, row and col
Performance justifies expensive license cost
PROSYou can seamlessly join both row and columnar tables and query across it
CONSDeployment script is bit challenging and need more custom works
Reason for choosing SingleStore
none of them either failed our read query latency tests, write throughput tests, or went over the cost of legacy solution
Vihari
Computer Software, 11-50 employees
Used daily for less than 12 months
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
5
CUSTOMER SUPPORT
5
FUNCTIONALITY
5
Reviewed September 2019
MemSQL
Amazing learning experience working with MemSQL, user friendly and easy to learn and understand. Made our lives much easier.
PROSPerformance and fairly easy to understand.
CONSNone actually. But sometimes support tickets take some time to be resolved but apart from that everything is great.
Sathwik
Security and Investigations, 501-1,000 employees
Used weekly for less than 12 months
OVERALL RATING:
5
EASE OF USE
4
VALUE FOR MONEY
5
CUSTOMER SUPPORT
5
FUNCTIONALITY
4
Reviewed September 2019
Gets the job done
The on-boarding was very smooth. The sales team is always ready to answer any question you have and they don't hesitate to involve their Engineers if you ask for more technical details.
PROSIf you are looking for something for real time analytics/dashboard this is the go-to option. We tried out lot of other technologies/tools and nothing seemed to be meeting the expectations when it comes to concurrent loads and data latency.
CONSNo Support for directly reading out of S3 files.
Vendor Response
A Quickstart tutorial for pulling data directly out of S3 files is at https://docs.memsql.com/v6.8/concepts/pipelines/s3-pipelines-quickstart/ How can we make this documentation more discoverable?
Replied October 2019
udaneshwara
Financial Services, 10,000+ employees
Used daily for less than 2 years
OVERALL RATING:
4
EASE OF USE
4
VALUE FOR MONEY
4
CUSTOMER SUPPORT
4
FUNCTIONALITY
4
Reviewed October 2019
Excellent and user friendly
Fast Accessing and data fetch and reliable
CONSnone.. don't have any con's as of now...
Anonymous
501-1,000 employees
Used daily for less than 12 months
OVERALL RATING:
4
EASE OF USE
3
VALUE FOR MONEY
4
CUSTOMER SUPPORT
5
FUNCTIONALITY
5
Reviewed October 2019
MemSQL distributed DBMS
hardware are needed according to cluster requirements
PROSfaster and scalable .. it runs as a distributed cluster thats why it is faster
CONSit is not free ...and not popular among users although it is useful
Syed Muneeb
Verified reviewer
Information Technology and Services, 1,001-5,000 employees
Used weekly for less than 6 months
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
5
CUSTOMER SUPPORT
5
FUNCTIONALITY
5
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.
PROSEasy to configure and use. And on top of it, is the efficiency in which the SingleStorm delivers the results and displays the output.
CONSUsing SingleStorm is super easy. I have not found any shortcomings in the platform yet.
Omer
Computer Software, 501-1,000 employees
Used daily for less than 6 months
OVERALL RATING:
4
EASE OF USE
5
CUSTOMER SUPPORT
4
FUNCTIONALITY
4
Reviewed September 2019
Great product
The similarity to mySql and the ocerall quickness of the queries
CONSSlow queries with temp table. Need to change every query in mysql that contain temp table to subQuery.
Vendor Response
I'm so glad you're enjoying the speed of MemSQL. Temp table performance is unexpected. Can you reach out to community@memsql.com so we can learn more about your scenario and help you achieve amazing results here too?
Replied October 2019
Madhuri
Banking, 5,001-10,000 employees
Used daily for less than 6 months
OVERALL RATING:
4
EASE OF USE
4
VALUE FOR MONEY
2
CUSTOMER SUPPORT
4
FUNCTIONALITY
5
Reviewed October 2019
Stream fast and Easy to Maintain.
Fast for large Streaming applications and easy to setup pipelines
PROS1. Ease of Installation 2. Upgrade procedures which support both offline and online. 3. Easy to deploy on to any cloud
CONSThe leaf node is associated with a id which binds it to hardware