We performed a comparison between MySQL and SingleStore based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, Firebird and others in Open Source Databases."The solution helps us perform with our databases and extract data."
"It's a mature solution that's been around for decades."
"It is pretty simple to use and I don't have anything really bad to say about it."
"It creates a unified view of the entire architecture and performance factor, helping to manage the network more easily."
"The relations in the database, the dynamic workflow, and the ability to connect with all columns. It's useful for e-commerce."
"The easy access to the data and the ability to sort the data with multiple methods are very valuable features."
"What I really like about MySQL is the opportunity to search for information and organize it any way I like."
"The tool is open-source and there is no cost involved in its use."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"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."
"The paramount advantage is the exceptional speed."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"This solution needs to be improved when it comes to working with desktop applications on the developer side."
"The interface could be improved."
"The solution could improve the monitoring. At the present time, you need to use third-party monitoring solutions."
"It could be a little bit simpler to use."
"Security is a concern. MySQL could have better security features."
"While utilizing a comparable algorithm, is noted to be sensitive, especially when configuring the inner device."
"Improvements to MySQL depend on the specific use case. For example, in my scenario, I frequently need to maintain and store data, which can then be utilized to generate reports. On the other hand, others may suggest incorporating a feature that allows for easier visualization of the data, such as what is available in Power BI or other similar tools."
"There should be more tools to manage the on-premises version and more automation features."
"We don't get good discounts in Pakistan."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
MySQL is ranked 1st in Open Source Databases with 142 reviews while SingleStore is ranked 6th in Database as a Service with 7 reviews. MySQL is rated 8.2, while SingleStore is rated 8.8. The top reviewer of MySQL writes "Good beginner base but it should have better support for backups". On the other hand, the top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Teradata and SAP HANA, whereas SingleStore is most compared with SQL Server, Teradata, CockroachDB, Oracle Database and Vertica.
We monitor all Open Source Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.