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 one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support."
"SKIP LOCKED is a valuable feature."
"MySQL is a light database. It's not very complex. It's easy to develop, easy to maintain, and easy to back up and restore."
"What I've been most pleased with is the cost point, performance, and ease of use."
"This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge."
"The tool is open-source and there is no cost involved in its use."
"It was easy to install."
"MySQL gives us all of the critical features that we need in a database, but without the costs."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The paramount advantage is the exceptional speed."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"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."
"Could use some additional JSON query support in the solution."
"The manuals or documentation could be better."
"The performance, stability, and security are areas with shortcomings in MySQL, where improvements are required."
"I would like to see the automatic backup feature in the solution as well. Data is very important and we need to preserve it in a safe place. It would be good if MySQL can back up the data automatically."
"The documentation is pretty weak and should be improved."
"Even for the best database, we always want the database to perform much better, so we wish MySQL would be much better, in terms of performance."
"We want to continue using MySQL but it merged with Oracle and the scalage changed."
"MySQL could introduce more indexing strategies."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"We don't get good discounts in Pakistan."
"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."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
MySQL is ranked 1st in Open Source Databases with 142 reviews while SingleStore is ranked 7th 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.