SingleStore Reviews

Singlestore 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.

It'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.

Single store basically is a mem-sql. Its comes with concept of shard key, partition and many more unique features that stand this out to any other relational databases. Its give a perfect SQL editor and faster query execution for sharding concept. Its store the data in either rows store or columns store based on the data set. The ease of exporting data from exiting My sql database and loading it into single store is very impressive it’s provided different kind of data loading concepts like data pipe like bloc file loading etc.

Some time the connection of the GUI database tools such as my sql workbench having some issues it’s required some additional configuration for it its a little headache for user.Dashboard part bit confusing its content lots pf details other then that its perfect performance wise and feather wise i can say.

It has faster query result in RDBMS platform along with high availability with the possibilities of loading data from different sources with real time data support. It has unique ingest capability to do parallel ingest of data from different sources with distributed and partition feature with M-S architecture. This standout SingleStore from others.

I believe it should have better User interface to support dynamic query creation along with that if it provide powerful Data virtualization options that would be nice.

I 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.

The 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...

Read more

- 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!

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.

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

I really can't think of much here. I advise MemSQL to accelerate adding features to the MemSQL studio

I 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.

The 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.

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.

Super 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.

I 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.

Supersonic is a great description. Thank you. Have you tried MemSQL Studio, the web-based SQL editor and cluster monitor?

The performance of this db its is amazing. The team assigned to our project did a great work by migrating a huge system in a short period of time

Since it is a new system that we are implementing as of now...I do not have "dislike".

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.

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.

So glad you're getting such exceptional performance.

You can seamlessly join both row and columnar tables and query across it

Deployment script is bit challenging and need more custom works

good product with good core competencies - scalable SQL database designed for transactional and analytical workloads, consistency durability etc

Performance challenges for in-Memory Database.

fastest in memory database. We have observed that it is very fast with queries,

should be able to keep more data in memory and do not break.

Performance is good and it is a relational database

support is limited. there are not too many tutorial/forum etc.

Fast query processing and child agg and master agg works super

Memsql ops does not work real time some times.

- horizontally scalable relational database - huge performance win comparing to on-prem alternatives - easy to setup on k8s - easy to connect to kafka

- cross data center replication requires manual intervention on failover

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.

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)

Performance and fairly easy to understand.

None actually. But sometimes support tickets take some time to be resolved but apart from that everything is great.

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.

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.

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?

If 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.

No Support for directly reading out of S3 files.

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?

When synchronizing permissions to child aggregators, only non-root users are affected. It has real-time processing features, and a child aggregator can be set as master if necessary.

If a leaf fails it takes the Matser Aggregator 10 seconds to promote the slave partitions from paired leaf.

Ease of use Ease of troubleshooting and upgrading Supporting

We have had issues with Aggregators/Leafs failing over

I'm so glad you've had such a positive experience with support.

fast, reliable, stable, works perfect on Linux replication is fast and too easy to set up :)

geez ... I really don't know. I am really thinking of something I don't like but nothing comes to mind. I have been doing administration for ... a few good years now.

Similar to existing RDBMS Supports join In Box implementation with Spark Salable & manageable with memSQL ops

Security Features Consistency Overflow on Disk

fast response, perfect for real time apps

documentation 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.