Try our new research platform with insights from 80,000+ expert users

Amazon RDS vs SingleStore comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Aug 12, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Amazon RDS
Ranking in Database as a Service (DBaaS)
2nd
Average Rating
8.2
Reviews Sentiment
7.7
Number of Reviews
54
Ranking in other categories
No ranking in other categories
SingleStore
Ranking in Database as a Service (DBaaS)
11th
Average Rating
8.8
Reviews Sentiment
7.4
Number of Reviews
6
Ranking in other categories
Vector Databases (15th)
 

Mindshare comparison

As of May 2025, in the Database as a Service (DBaaS) category, the mindshare of Amazon RDS is 24.7%, down from 27.7% compared to the previous year. The mindshare of SingleStore is 1.7%, up from 0.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database as a Service (DBaaS)
 

Featured Reviews

Samuel Ebite - PeerSpot reviewer
Ensure high availability with robust encryption and seamless backups
Amazon RDS provides data encryption using services like KMS, crucial for securing high-sensitive data and meeting compliance requirements such as HIPAA or PCI DSS. The best practices we've employed with RDS help design a well-architected framework, encompassing security, encryption, scalability with multi-availability zone deployment, and operational excellence with automated backups. RDS features, such as reserved instances, storage auto-scaling, monitoring with technologies like CloudWatch, and proxies, contribute to cost optimization. The solution enhances security with IAM authentication and offers high availability to end users.
Yasin Sarı - PeerSpot reviewer
High-speed data processing, seamless scalability, and excellent high availability making it an optimal choice for those prioritizing performance and efficiency in a database solution
There's a noteworthy consideration when it comes to collecting massive amounts of data. It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks. Attempting to use it for direct extraction, for instance, might lead to memory-related challenges. While MySQL version five might lack extensive SQL capabilities, SingleStore also has its constraints, requiring simpler SQL writing. This becomes evident when seeking advanced functionalities like window functions or JSON functions, where SingleStore doesn't offer an extensive toolkit, necessitating a more straightforward approach to SQL.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The solution’s scalability, usability, and availability are valuable to us."
"The product's initial setup phase is totally easy."
"I use Amazon RDS to store and manage data securely. It helps me retrieve information and gain insights from the data that comes in for my business or specific applications."
"The solution is scalable and can be configured with AWS Secrets Manager."
"It is easy to use, flexible, and powerful."
"Amazon RDS is lightweight and flexible."
"It handles large-scale data migrations perfectly. Amazon RDS's performance is quite good. Charges are incurred after you utilize the service"
"I recommend RDS because it makes your life super easy."
"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."
"The paramount advantage is the exceptional speed."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
 

Cons

"The solution is a bit expensive."
"Technical support could be better."
"The solution's connectivity and response logs could be improved."
"There are some advanced monitoring queries that we cannot execute because Amazon doesn't give admin privileges to the end users."
"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."
"A lot of the features are disabled by default. The solution should enable more features. I understand this could cause challenges to management for many clients using RDS, however."
"The only thing that needs improvement would be the pricing of the solution."
"The Amazon RDS engine could provide features for additional databases, such as Db2. It could also provide support for other databases, such as NoSQL databases, DynamoDB, and Apache Cassandra. They could all stay under one hood."
"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."
"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."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"Having the ability to migrate servers using a single command would be extremely beneficial."
 

Pricing and Cost Advice

"Amazon RDS is cheaper compared to other tools."
"The price of Amazon RDS is reasonable."
"The solution's pricing needs improvement."
"Licensing fees are paid on an annual basis."
"The prices for different regions are different."
"It is less expensive than SQL Server. We pay based on the usage on a monthly basis."
"The substantial initial credit and cost-effectiveness make Amazon an attractive option."
"Amazon RDS is an expensive solution."
"I would advise users to try the free 128GB version."
"The product's licensing is not expensive. It is comparable."
"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."
"They have two main options: cloud installation and bare-metal installation, each with different pricing models."
"SingleStore is a bit expensive."
report
Use our free recommendation engine to learn which Database as a Service (DBaaS) solutions are best for your needs.
850,834 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
15%
Financial Services Firm
14%
University
6%
Manufacturing Company
6%
Financial Services Firm
34%
Computer Software Company
12%
Manufacturing Company
5%
University
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Amazon RDS?
The product's installation phase is easy.
What needs improvement with Amazon RDS?
One key improvement would be adding support for multi-storage paradigms, including columnar support, as seen in TiDB. The serverless support with Aurora could also be enhanced. Additionally, having...
What do you like most about SingleStore DB?
The paramount advantage is the exceptional speed.
What is your experience regarding pricing and costs for SingleStore DB?
Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure. While building an on-premise cluster incurs an initial cost for servers with ample RAM...
What needs improvement with SingleStore DB?
There's a noteworthy consideration when it comes to collecting massive amounts of data. It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation...
 

Comparisons

 

Also Known As

RDS
No data available
 

Overview

 

Sample Customers

Edmodo
6Sense, ADNOC, Adobe, Akamai, CARFAX, Cigna, Cisco, Comcast, DBS Bank, Dell, Dentsu, EY, FirstEnergy, GE, Goldman Sachs, Heap, Hulu, IMAX, Kakao, Kroger, LG, LiveRamp, Lumana, NBC, OpenDialog, Outreach, Palo Alto Networks, PicPay, RBC, Samsung, Siemens, SiriusXM, SK Telecom, SKAI, Sony, State Street Financial, STC, SunRun, TATA, Thorn, and ZoomInfo.
Find out what your peers are saying about Amazon RDS vs. SingleStore and other solutions. Updated: April 2025.
850,834 professionals have used our research since 2012.
OSZAR »