Maximum performance and scalability in one.
December 15, 2020

Maximum performance and scalability in one.

Jacob Ortega | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SingleStore (formerly MemSQL)

Right now we’re using [SingleStore (formerly MemSQL)] in the whole core platform, we were looking for a database that could handle a huge amount of transactions at the same time without loosing any and have the reliability of writing and storing the records fast so other services can use the data for finalizing the transactions. Also we were aiming to have a product which could be used as a storage solution for Data Scientists and our back office platform.
  • The fastest speed for querying compared with traditional relational database
  • Support JSON and full text search which can be used by API’s
  • Nearly zero admin tasks once it’s running
  • You can use it’s data streaming pipeline with Kafka
  • It doesn’t provide redistribution when you reach the maximum node capacity
  • The Graphical Interface could have a revamp, it’s a little bit laggy
  • You cannot run it local so development should be made always using cloud instances
  • We decrease response times for our users
  • A best experience for our compliance team
  • The overall performance of the core was improved which means less resources for micro services are needed
I guess the main difference is how the memory is used for stacking and storing data until it reaches the final destination, the performance is awesome compared with others and when you have a real time business with a certain complexity. The development team would be more familiarized with the SQL environment and there’s practically a zero learning curve, when you compare this with other data bases you’re going to find that there’s a huge saving in time and money.
When using SingleStore [(formerly MemSQL)] for building back office apps which have dashboards in it you will find that you can query hundreds of rows without even noticing, so deep diving, drilling down into data will be a real satisfying experience for the final user. Creating predictive analytics its easy because you can have a lot of data queried and ingested into the models and in nearly real time you’re finding the answer for example to give a user / visitor an excellent next best offer.
Now with the use of SingleStore [(formerly MemSQL)] we can handle spikes in user transactions, in our industry we need to handle this spikes seamless, we’re not knowing when a merchant is going to launch a promotion or super deal which is going to increase the volume of transactions. Performance sometimes is everything you need to have a happy customer.

Do you think SingleStore (formerly MemSQL) delivers good value for the price?

Yes

Are you happy with SingleStore (formerly MemSQL)'s feature set?

Yes

Did SingleStore (formerly MemSQL) live up to sales and marketing promises?

Yes

Did implementation of SingleStore (formerly MemSQL) go as expected?

Yes

Would you buy SingleStore (formerly MemSQL) again?

Yes

I think SingleStore [(formerly MemSQL)] should be used in every modern system which needs an analytical tool provided with the database, where performance matters and when you need fast scaling. The database is going to use a lot of resources so if the scenario is cost sensitive then perhaps is not the best solution in terms of infrastructure.