We performed a comparison between MySQL and SingleStore based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases."It is easy to use."
"MySQL's most significant attribute is its capability to create, modify, and maintain databases. This is crucial and advantageous in procedures, such as SOAR. Therefore, all SQL functions are beneficial to any backend developer or developer who requires data storage."
"Support for enterprise-grade features like clustering, master-slave replication, even Sharding (to some extent) which is an advanced feature."
"The main advantage is the very large user base. This enables users to fix about any issue by answering any question."
"The solution is great for small applications in particular."
"I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures."
"The solution is easy to use."
"One of the best features is this solution is easy to use."
"The paramount advantage is the exceptional speed."
"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 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."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"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."
"It would be helpful if there were a graphical user interface to administer, configure, and tune it."
"I would like to improve the solution’s pricing for licenses."
"The analytics features are in need of improvement."
"Improvements are required in character set support, scalability, and big data sets."
"We want high availability and replication features, which are currently missing in this solution. It would be great if they can provide an in-built replication feature, similar to Oracle RAC, in MySQL."
"They should come up with a better solution than the NDB cluster for better scaling. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution."
"The solution could improve by having better performance and security."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"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."
"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."
"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."
"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 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 SQL Server, whereas SingleStore is most compared with SQL Server, Teradata, Oracle Database, CockroachDB 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.