We performed a comparison between Amazon Aurora and SingleStore based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."The most valuable feature is that the maintainability is offloaded to the service provider. I don't have to maintain a database or do any administrative tasks, which comes in handy."
"We had better control over the parameters that we could tweak in terms of intermediate storage and better indexing capabilities."
"The most valuable feature is the ability to do multiple-read and single-write. These are the kinds of features that we were interested in, and Aurora takes care of that natively."
"The most valuable feature of Amazon Aurora is SQL standardization, it doesn't have its own syntax which is good. It has a lot of hands-off self-management type of activities, such as log rolling and auto-scaling."
"Aurora's compatibility with MySQL or PostgreSQL benefited our database management. The migration from on-premise MySQL to Aurora was similar, so we didn't need to change our source code."
"The provision of custom read and write endpoints eliminates the need for managing a separate proxy load balancer."
"The solution’s scalability is good since we don’t need to take a maintenance window during unpredictable workloads. I like the solution’s behind-the-scenes happenings. It is a great feature."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"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 ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The paramount advantage is the exceptional speed."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The pricing could improve. It should be reduced."
"It would have been helpful if they had provided some benchmarking numbers."
"There is improvement needed to have more developer focus. Additionally, it would be helpful to have a stand-alone solution outside of Amazon. Amazon has a tendency to favor developing web-based clients, which may not always provide the fastest or most responsive solution as desired."
"I would like to see more AI-related features in future releases."
"It is a bit costly. The features are quite good, and I wouldn't say it requires any technical improvements. But from a cost perspective, some clients wouldn't go for Aurora because of that."
"The product's distributed query process for MySQL needs improvement."
"I would like to see performance insights on the database based on the queries. Currently, we use SolarWinds as the monitoring tool. I would like to leverage SolarWinds’ performance insights in AWS services. SolarWinds gives larger insights when we run performance issues."
"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."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"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."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
Amazon Aurora is ranked 11th in Relational Databases Tools with 7 reviews while SingleStore is ranked 6th in Database as a Service with 7 reviews. Amazon Aurora is rated 7.8, while SingleStore is rated 8.8. The top reviewer of Amazon Aurora writes "Easy-to-manage platform with a valuable auto-scaling feature ". On the other hand, the top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". Amazon Aurora is most compared with SQL Server, Oracle Database, MariaDB and CockroachDB, whereas SingleStore is most compared with SQL Server, MySQL, Teradata, CockroachDB and Oracle Database.
We monitor all Relational Databases Tools 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.
