Item: SingleStore
Rating: 9
Author: Verified User

Overall Satisfaction with SingleStore

Use Cases and Deployment Scope

SingleStore is being used for concurrent high performance reporting powering Tableau BOBJ PowerBI and conventional .net and java pages. It is also being used for real time reporting with data loaded from OLTP systems using GoldenGate, Kafka and Spark. SingleStore is being used in Sales, Finance, Supply Chain, Inventory Management, Marketing, Servicing and Logistics reporting.

Pros and Cons

Pros

Powering multiple dashboards on a single screen within short span of time
Real time reporting for IOT devices
Warehouse queries powering dashboards which suffers due to concurrency in Warehouse Database Systems

Cons

Auto failover to DR Site
Eventual Consistency
Point in time recovery
Robust Monitoring

Return on Investment

Lower operational complexity - Installation and maintenance is pretty easy
Object scale when used can compete with Traditional Warehouse Systems like Teradata, Netezza, Greenplum
Adds lot of value to the business like couple of operations which never worked in traditional DBMS including HANA, Oracle In Memory, SQL Server In Memory just flew in SingleStore

Performance

SingleStore Performance is excellent and concurrency that it supports is amazing compared to other DB technologies. It scales out pretty well by adding leaf nodes as the data grows. Pipelines are the strongest feature of SingleStore, which eliminates writing manual code to ingest data from Kafka, S3, and Hadoop systems, and it does that parallelly.

Consolidation

SingleStore is still not that effective as the name suggests. It needs a robust point in time recovery solution like Oracle, Postgres or SQL Server and cannot do with Flashback like feature with Snapshots taken at regular interval for replacing conventional DBMS.

It also does not possess auto failover feature that an OLTP system needs.

KAI is a great feature for NoSQL with compatibility to Mongo Client. But it is still not widely used especially on premises to replace Mongo Workload. The infra needed for a Mongo to SingleStore for a replacement is different.

SingleStore does not support Eventual Consistency like Cassandra to replace Cassandra Workload unlike the competitors CockroachDB (SQL)and AeroSpike (NoSQL).

SingleStore although supports Lucene, is still not able to takeup ElasticSearch workload. A comprehensive demo and marketing is needed on how to replace Elastic.

SingleStore supports Vector and it is doing good in that. But does not support Graph like Neo4J or TigerGraph. Geospatial is supported.

Alternatives Considered

Tanzu Data Services (Greenplum, GemFire, RabbitMQ and Tanzu SQL)

Greenplum is good in handling very large amount of data. Concurrency in Greenplum was a major problem. Features available in SingleStore like Pipelines and in memory features are not available in Greenplum.

Gemfire was not scaling well like SingleStore. Support of both Greenplum and Gemfire was not good. Product team did not help us much like the ones in SingleStore who helped us getting started on our first cluster very fast.

Key Insights

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?

I wasn't involved with the selection/purchase process

Did implementation of SingleStore go as expected?

Yes

Would you buy SingleStore again?

Yes

Other Software Used

Tanzu Data Services (Greenplum, GemFire, RabbitMQ, Tanzu SQL), MongoDB, Apache Cassandra

Likelihood to Recommend

SingleStore is well suited for warehouse dashboards used at executive level. There is no latency due to concurrency and the performance is terrific compared to SingleNode traditional databases.

High speed data ingestion powering IOT and other workload which also needs high speed seeks.

SingleStore support as well as Marketing team is excellent. They are always with you to troubleshoot until we achieve a fix.

Where SingleStore lacks is in OLTP systems where there is no capability of PITR. It is more like Flashback. Monitoring is still not robust, they provide exporter that can be used in Prometheus for alerting, but no monitoring rules are directly provided by SingleStore. Grafana prebuilt dashboard is provided which is good.

Comments

Please log in to join the conversation

SingleStore - 10+ years of Experience