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 creates a unified view of the entire architecture and performance factor, helping to manage the network more easily."
"I like MySQL's feature that helps to automate things."
"Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run."
"It is free, which is probably its most valuable feature. It is a pretty full-featured relational database. It really does everything we need it to do."
"I like MySQL because of its community."
"I am totally satisfied with MySQL."
"I like the JSON stuff."
"MySQL is easy and convenient for me. I don't need to rely on anyone. I can write the code and extract the information. It is fast if you know how to use it. The solution is not expensive, and most of the developers know how to use it. It is easy to create tables. The solution is stable and has good performance. The connection with AWS gives regular updates, which is manual otherwise and a nightmare."
"The paramount advantage is the exceptional speed."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"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."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"There should be more tools to manage the on-premises version and more automation features."
"There should be an arrangement for end-users to get trained to use the tool...Improvement-wise, a graphical interface could be added for new users, eliminating the need to memorize the complex syntax."
"The product is a little bit complex and it is difficult to find sufficient documentation."
"MySQL could introduce more indexing strategies."
"I find the Microsoft solution a bit better. But mostly in terms of the UI layout, I would say. I just find it a little bit more efficient."
"It isn't as reliable as an SQL Server."
"The analytics features are in need of improvement."
"I did the implementation of the solution myself and I used community support. The support from the vendor costs money."
"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."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"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."
"We don't get good discounts in Pakistan."
"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 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.