We performed a comparison between Amazon RDS and SingleStore based on real PeerSpot user reviews.
Find out in this report how the two Database as a Service solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The solution's customer service is excellent."
"It is very easy to set up initially."
"Amazon RDS is a scalable solution."
"Amazon RDS is lightweight and flexible."
"It is easy to use, flexible, and powerful."
"The most valuable aspect of Amazon RDS is it is on the cloud."
"The solution has unique features like backup and recovery, and snapshots. It upgrades automatically. The solution offers easy analytics concerning performance metrics. Its reliability and scalability are very good. The tool's most valuable features are disaster recovery, high availability and scalability."
"The product solved our DevOps and admin problems."
"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."
"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 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."
"Currently, we are using Fargate. Instead of that, we are planning to use EC2 instances, but we are facing some problems, and we are unable to enable NAT gateway for Elastic Load Balancer. When we enable auto-scaling, the instance count increases, and we get IP addresses dynamically. We need to whitelist the IPs of these instances, but there is no option to whitelist those IPs in Amazon RDS. We need one static IP that we can assign to ELB so that we can whitelist this IP."
"Amazon RDS needs to have an overall dashboard where I can view all the tables in the form of pie charts and Gantt charts. The deployment is complex, and we would like to see automated scripts. It needs to incorporate performance insights."
"I like using Amazon RDS because it offers quick operations for me. However, there are times when understanding how to use some of the services can be challenging, even with documentation. If I could add a feature, I'd improve navigation for related services."
"It would be better if it integrated seamlessly with Microsoft products. Our clients use the Microsoft Tally application server. We already tried to create a reputation from, for example, an on-premises environment from our client to Amazon RDS using Microsoft Tally server, and we couldn't do that because we didn't have a strong user in RDS. We couldn't create a reputation from an on-premises environment from the Microsoft Tally server to RDS. I think that it would be a good implementation, and it would help us with this case."
"The product should support new databases."
"They should add a feature for manual SQL patching in RDS."
"It would be helpful if they made it easier to migrate from an existing on-premises solution to the cloud-based service."
"AWS support is decent, but it's not as good as before. Sometimes, we get junior staff who are unable to answer our questions. It also depends on the support team you get. Support based in Europe and Australia is better than US support. For example, European support is quick to deliver the right answer. US support handles routine maintenance issues, and it's mostly junior staff who don't know the product well."
"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."
"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."
"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."
Amazon RDS is ranked 1st in Database as a Service with 45 reviews while SingleStore is ranked 6th in Database as a Service with 7 reviews. Amazon RDS is rated 8.4, while SingleStore is rated 8.8. The top reviewer of Amazon RDS writes "Provides excellent authentication, authorization, integration, data protection, and autoscaling features". On the other hand, the top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". Amazon RDS is most compared with MongoDB Atlas, Google Cloud SQL, SQL Azure, Oracle Database as a Service and IBM Db2 on Cloud, whereas SingleStore is most compared with SQL Server, MySQL, Teradata, CockroachDB and Cloudera Distribution for Hadoop. See our Amazon RDS vs. SingleStore report.
See our list of best Database as a Service vendors.
We monitor all Database as a Service 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.