SingleStore as the backbone for our data analytics platform.
May 16, 2021
SingleStore as the backbone for our data analytics platform.
Score 9 out of 10
Vetted Review
Overall Satisfaction with SingleStore (formerly MemSQL)
SingleStore as the backbone for our Data Analytics platform
With SingleStore, we are able to replace multiple other databases and started migrating from on-premise to SAAS. As SingleStore provides both scenarios, the migration to the cloud will be a smart and simple one. We now use SingleStore for our data and analytics environment. As we now can use the pipelines towards our data lakes and send data via procedures into our tables, we have achieved the next step in our data management by adding additional metadata during the ingestion. Using text search and the geospatial functions adds more functionality than we had before in our previous databases. The performance and scalability are beyond our expectations.
With SingleStore, we are able to replace multiple other databases and started migrating from on-premise to SAAS. As SingleStore provides both scenarios, the migration to the cloud will be a smart and simple one. We now use SingleStore for our data and analytics environment. As we now can use the pipelines towards our data lakes and send data via procedures into our tables, we have achieved the next step in our data management by adding additional metadata during the ingestion. Using text search and the geospatial functions adds more functionality than we had before in our previous databases. The performance and scalability are beyond our expectations.
- The scenario to migrate on-premise and scale up to the cloud as a SAAS.
- Using HTAP means we can now use our database for transactions and analytics.
- The main language is similar to MYSQL, so our organization has already the knowledge to master the system.
- The SingleStore academy is a good program to support our organization to master the environment.
Pros
- Performance on large sets of data for analytics.
- Row based and column based can be used and mixed.
- Time series, geo spatial and text search function to add to our platform.
- Scalability, so we can continue to deliver the same performance.
Cons
- Does not yet support foreign keys.
- As the overall performance and functionality were expanded, we are able to deliver our data much faster than before, which increases the demand for data.
- Metadata is available in the platform by default, like metadata on the pipelines. Also, the information schema has lots of metadata, making it easy to load our assets to the data catalog.
- Azure Synapse Analytics (Azure SQL Data Warehouse) and Azure SQL Database
We need a flexible way to start the transformation on-premise and then move to the cloud. The lack of functionality and the easy way to scale out in multiple environments makes SingleStore the better choice.
SingleStores supports HTAP, making it possible to use databases as a source and for analytics at the same time without things like locking, etc. Our CRM, HR and sales database are now optimized to run in the HTAP mode in SingleStore. This saves us a lot of copying and/or recreating new databases with different data models. With the pipelines functionality, we are able to ingest data from our data lakes, to enrich our own data.
By default, the setup is already configured for high availability. By expanding, we just need to add the so-called leafs. Adding a leaf (server) can be done via scripts to ensure a fast and simple way to add more capacity.
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