My Experience with SingleStore (MemSQL).
December 16, 2024
My Experience with SingleStore (MemSQL).
Score 7 out of 10
Vetted Review
Verified User
Overall Satisfaction with SingleStore
The SingleStore is high-performance, scalable, and real-time analytics on large datasets, particularly for hybrid transactional and analytical processing (HTAP); we had a requirement to handle fast OLTP workloads (e.g., processing transactions, user interactions, etc.). It is a Fast column store database with a Pipeline concept. In our current use case, we do data ingestion directly into the database from external sources like Kafka, S3, and various other data streams with their "data pipeline model." It allows for high-throughput data ingestion without needing separate ETL (Extract, Transform, Load) processes, enabling SingleStore to handle transactional and analytical workloads with minimal latency.
Pros
- Very fast columnar store database.
- Data pipeline model.
- Designed for horizontal scalability across distributed clusters.
Cons
- It does not release a patch to have back porting; it just releases a new version and stops support; it's difficult to keep up to that pace.
- Support engineers lack expertise, but they seem to be improving organically.
- Lacks enterprise CDC capability: Change data capture (CDC) is a process that tracks and records changes made to data in a database and then delivers those changes to other systems in real time.
- For enterprise-level backup & restore capability, we had to implement our model via Velero snapshot backup.
- It's super fast when it comes to columnar databases, so it reduced our time to market in terms of faster transactions.
- Pipelines added lot of flexibility to developers, so it helped reduce time.
- Supported native observability via prometheus etc.
In our use case, we needed a data pipeline model as we had Kafka in place. So we did not have to think of any other columnar database.
It has more APIs and other access methods. It has a multi-version concurrency control (MVCC) Distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storage with patented universal storage to handle transactional and analytical workloads in one table type. You can host it On-Prem.
Do you think SingleStore delivers good value for the price?
Yes
Are you happy with SingleStore's feature set?
Yes
Did SingleStore live up to sales and marketing promises?
Yes
Did implementation of SingleStore go as expected?
Yes
Would you buy SingleStore again?
Yes
Comments
Please log in to join the conversation