SingleStore Valuable Features

Hitesh Kunchakuri - PeerSpot reviewer
Associate Consultant at University of California at Davis

Each time, the user cannot write an SQL query for everything owing to certain time constraints. I feel that things can be done quickly in SingleStore since a written command can auto-generate a SQL query in real-time. The speed of the product is good. The support offered by SingleStore is seamless. SingleStore can be used with multiple software tools.

View full review »
MA
Owner at a consultancy with 1-10 employees

The most valuable features are: 

  • MySQL drop-in solution: MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short. Developers were able to code against MemSQL the same day. They configured MemSQL in Docker and were up and running.
  • MemSQL built-in pipeline: You can connect MemSQL directly to an S3 bucket and it will ingest its data automatically. There is no need to create a lambda function. It just works. You can connect to Kafka, HDS, and other protocols.
  • Support for CTE, Window, Stored Procedures, functions (UDF, Table) are all included. MemSQL is a full-blown database solution. 
  • Replication: A MemSQL cluster can replicate to another cluster. This is a great feature, allowing you to have one cluster that does all the heavy work, and a Replica for reads. 
  • MemSQL supports high concurrency, and scaling horizontally is limitless.
  • I really like the MemSQL portal (portal.memsql.com). Creating more labs is the best way to introduce people to MemSQL.
View full review »
VK
Solution Architect at Wipro Limited

Its in-memory storage, distributed architecture, scalability, and failover mechanisms collectively contribute to its exceptional performance and reliability, especially in demanding transactional environments like online and mobile banking systems. The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms. Even in scenarios where all servers experience downtime, it ensures data safety by maintaining a copy on disk.

View full review »
Buyer's Guide
SingleStore
March 2024
Learn what your peers think about SingleStore. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
Yasin Sarı - PeerSpot reviewer
Senior Data Analyst at a comms service provider with 1,001-5,000 employees

The paramount advantage is the exceptional speed. Another noteworthy aspect of our experience is that, upon its setup, there aren't any issues that necessitate the intervention of a DBA. In terms of performance, it has proven impressive, particularly in handling complex joins without the need for data shortening. It excels in executing complex SQL operations swiftly.

View full review »
RP
Database Administrator at a tech services company with 1-10 employees

It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data. I heard a client processed 3.5 billion records in seven minutes! Their data ingestion is very high, and SingleStore even markets itself as the world's fastest database.

View full review »
Khawaja Shoaib Hamid - PeerSpot reviewer
Regional Sales Manager at Cinergie Digital

The product can automatically reinstall and reconfigure in case of a shutdown. 

View full review »
Ishtiaque Ali - PeerSpot reviewer
Data Analytics Solution Architect at Cinergie Digital

The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines.

View full review »
Buyer's Guide
SingleStore
March 2024
Learn what your peers think about SingleStore. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.