SingleStore Helios
SingleStoreExternal reviews
121 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Most Powerful and fastest Database
What do you like best about the product?
MemSQL helps in powering our complex applications by quickly analyzing and processing large datasets in the database. It can easily handle massive queries and provide quick processing and response. The process of storing and retrieval is pretty fast and it can easily process complex queries in seconds.
What do you dislike about the product?
MemSQL utilizes huge physical resources of the instances in case of processing large datasets and it can be an issue if auto-scaling isn't configured.
What problems is the product solving and how is that benefiting you?
We were able to perform and process large datasets and queries very quickly and efficiently. With the help of MemSQL, we were able to process millions of records in a second and deliver maximum performance. It has helped us process data quickly and efficiently than other databases.
Checked - One solution for Streaming Analytics on Big Data
What do you like best about the product?
- 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!
- 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!
What do you dislike about the product?
In 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.
What problems is the product solving and how is that benefiting you?
Problem of streaming analytics on high-velocity, high volume data sets with sub-second API responses.
This product elegantly solves the problem.
This product elegantly solves the problem.
Recommendations to others considering the product:
They offer a free trial, definitely try - you will not be disappointed with what you see.
Incredibly fast performance for dashboards!
What do you like best about the product?
We have had excellent luck with ingest rates and the ability to do lightning fast counts and other general math on time based data sets. If you are already familiar with SQL you will have little trouble utilizing this platform. Although we have had few occasions to use it, paid support was quite responsive and helped us correct issues quickly. Toolset allows for quick builds and deployments and services have been stable over significant periods of uptime. MemSQL Ops dashboard also allows for at-a-glace view to determine if your cluster is generally healthy.
What do you dislike about the product?
Although I have heard of some people have positive results, I would like to implement autoscaling with the ability to increase licensing cost only for the time a cluster is scaled. I will soon be looking into MemSQL's Helios product to see if that is a reasonable path forward for us.
What problems is the product solving and how is that benefiting you?
MemSQL provides the backend for our realtime dashboard and alerts system. MySQL compatibility makes it easy to import/export data to other databases when needed.
Recommendations to others considering the product:
For our use case of doing math on time series data MemSQL has been a great success; if you are running basic SELECT statements and expect raw data in your results we didn't see as much of a speed increase but the ease of setting up a HA cluster is a definite bonus even then.
Work with Memsql everyday for our platform in Kenshoo
What do you like best about the product?
The speed of queries, Kafka stream support, the easy to learn - syntax same as Mysql.
Your support is great, answer quickly on ticket.
Your support is great, answer quickly on ticket.
What do you dislike about the product?
First query run time (compilation time), not easy and clear how to analyze/improve slow query.
What problems is the product solving and how is that benefiting you?
Slow queries in Mysql.
Memsql allow us to run all queries with no limitation on every scale of data.
Memsql allow us to run all queries with no limitation on every scale of data.
Scale and speed!
What do you like best about the product?
I love how we can get scale and speed out of this database technology. We have loaded data in volumes that have historically stopped other database technologies in their tracks. We also have integrated the Memsql with our data visualization software which streamlines our reporting channels.
What do you dislike about the product?
I don't have any complaints at this point.
What problems is the product solving and how is that benefiting you?
Creating and maintaining secure databases at scale for our company. We have found that we don't need to ask if the database can handle the volume when using memsql.
Recommendations to others considering the product:
Take the time to learn what is available specifically to MemSQL. The documentation available is incredibly helpful when making a determination about what we can do with MemSQL. It has been an invaluable piece of the puzzle for us when bringing junior developers online and up to speed about how things work with MemSQL.
Easy to set up - super fast to use
What do you like best about the product?
The best thing about memsql is the speed at which queries are run - add kafka pipelines for your ETL process and everything data related becomes much easier.
What do you dislike about the product?
Nothing really - everything runs pretty smooth and the support provided is great.
What problems is the product solving and how is that benefiting you?
Our primary BI tool is Tableau - before we implemented MemSQL, we were connecting Tableau to MSSQL Server and running reports off there - however, the performance was extremely slow especially when querying large chunks of data. With Mem, we can query as much data as we need with little to no impact on performance time.
Amazing Performance of MemSQL
What do you like best about the product?
Amazing performance of MemSQL both for reads and writes.
No blocking sessions.
Non blocking indexes.
Excellent performance for Dashboards, mobile applications, warehouses, data science, realtime reporting performance.
No blocking sessions.
Non blocking indexes.
Excellent performance for Dashboards, mobile applications, warehouses, data science, realtime reporting performance.
What do you dislike about the product?
Central monitoring not available.
Indexes are built on start up and if there are too many indexes it takes more time.
Indexes are built on start up and if there are too many indexes it takes more time.
What problems is the product solving and how is that benefiting you?
Data Science, OLAP Reporting using Tableau, BOBJ.
Recommendations to others considering the product:
High Speed normal SQL Database compared to other products in the market like Document / Key Store database which is difficult to understand. Apart from that, this also supports Document storage.
Simple to deploy and operate in modern micro service architecture
What do you like best about the product?
Simple to deploy, administer and operate with the highest performance to fulfill client requests. Fits well into the microservice and container-based application with the reliability you can count on. Capable to scale with the application demand. Easy to administer with the centralized tool and reactive web UI.
What do you dislike about the product?
The backup and restoration can be a bit challenging. Simultaneous extraction of the back up can be a challenge with large scale deployment. lack of logging on deployment failures which are related to environmental factors. Requirements on internet access make it difficult to deploy in a closed network environment.
What problems is the product solving and how is that benefiting you?
Increase in operation performance.
Fast and Furious
What do you like best about the product?
Having worked on the database for a quite a good time, I believe it is really going to be standing with its flag high. Its really fast, wonderful optimization, lots of flexibility and overall is very agile to git into the needs of small to large enterprises.
What do you dislike about the product?
At present not many bloggers or its own forum which can really help the developers and architects for a quick resolution. Mostly relying on MYSQL posts to get the resolution.
What problems is the product solving and how is that benefiting you?
We are currently dealing with changing the existing solution of Wealth management on Sybase to MemSQL. Their primary problems is the scalability and the performance. We have realized both benefits at this stage and nearing to production implementation.
Recommendations to others considering the product:
I would suggest them, if they have the below problems then they should start engaging the MemSQL and go ahead with a POC and see by themselves rather than just relying on feed backs and comments. The range of issues could be:
1) Scalability
2) Real Time integration
3) Real Time Datawarehousing
4) Highly performing BI Platform.
5) Structured and unstructured data handling
7) SLA breaches in Webservices
to name a few which could be the trigger points.
1) Scalability
2) Real Time integration
3) Real Time Datawarehousing
4) Highly performing BI Platform.
5) Structured and unstructured data handling
7) SLA breaches in Webservices
to name a few which could be the trigger points.
Experience with MemSQL
What do you like best about the product?
MemSQL provided super fast performance of both writes and .reads
What do you dislike about the product?
There is nothing in particular that i do not like
What problems is the product solving and how is that benefiting you?
None
showing 41 - 50