Amazon RDS vs SingleStore comparison

Read 7 SingleStore reviews

252 Views
196 Comparison Views

100% willing to recommend

Amazon RDS

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Aug 12, 2024

Amazon RDS and SingleStore are leading database management solutions. SingleStore seems to have the upper hand due to its superior performance and better value despite its higher cost.

Features: Amazon RDS is noted for its automated backups, scalability, and integration with other AWS services. SingleStore offers high performance, real-time analytics, and support for various data types.

Room for Improvement: Amazon RDS users suggest improvements in query optimization, cost management, and support response time. SingleStore users see room for improvement in documentation, ease of use, and cost-related transparency.

Ease of Deployment and Customer Service: Amazon RDS has a straightforward deployment with AWS services but might have slower support response times. SingleStore provides a seamless deployment experience with responsive customer service.

Pricing and ROI: Amazon RDS is seen as cost-effective with good ROI but sometimes incurs unexpected costs. SingleStore, though more expensive, delivers substantial ROI through performance benefits.

To learn more, read our detailed Amazon RDS vs. SingleStore Report (Updated: December 2024).

Amazon RDS vs. SingleStore

December 2024

Download the complete report

Helped 824,053 peers since 2012

Categories and Ranking

Amazon RDS

Ranking in Database as a Service (DBaaS)

2nd

Average Rating

8.4

Reviews Sentiment

8.0

Number of Reviews

Ranking in other categories

No ranking in other categories

SingleStore

Ranking in Database as a Service (DBaaS)

7th

Average Rating

8.8

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

Vector Databases (13th)

Mindshare comparison

As of December 2024, in the Database as a Service (DBaaS) category, the mindshare of Amazon RDS is 25.9%, down from 28.4% compared to the previous year. The mindshare of SingleStore is 1.3%, up from 0.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Database as a Service (DBaaS)

Featured Reviews

Udhay Prakash Pethakamsetty

Data Engineer Manager at Capgemini

Provides excellent authentication, authorization, integration, data protection, and autoscaling features

The product should support new databases. RocketDB is written in C++. It is useful when we work with Kafka. The product should support more databases and not just the standard four to five databases. It will help the users to explore new avenues and not be confined to the standard ones. The tool provides automatic backup, but the recovery is slow if something goes wrong. We need to wait for some time. If a failure happens, recovery takes some time. Meanwhile, we lose business. It would be great if it happens much faster. The cross-region replication settings are very complex. We need to do careful planning.

Read full review

Hitesh Kunchakuri

Associate Consultant at University of California at Davis

A reasonably priced product that offers good speed and seamless support

Currently, I can't think of any areas that require improvement because SingleStore was recently launched in the market. The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings. The current SingleStore model provides output based on the RANK function. If a user searches for a liquor bottle, then with all the data the product has, it will search for the liquor bottle in the data, and based on a match, the product has an algorithm to rank the product because of which the paragraph that has the best match will be ranked as a 100, the next one as 99, following which the next product will be ranked as 98 and so on. The output from the solution will fetch you all the 100 products that are available in a store, but sometimes a user might require a product with a 97 or 98 percent match from the DB, meaning the product doesn't always work to provide a 100 percent match, an area I feel that can be optimized in the product. Currently, SingleStore's features are excellent as it can read documents, images, and everything. The product works seamlessly for me.

Read full review

Quotes from Members

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

Pros

"The product solved our DevOps and admin problems."

"The solution's customer service is excellent."

"Amazon RDS fulfills PCI requirements, which is a valuable feature for us."

"It is very easy to set up initially."

"The tool is very easy to use and configure."

"I found it to be a stable solution."

"The solution is good for on-premise deployments."

"It significantly reduces database management overhead."

More Amazon RDS pros

"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'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."

"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 product can automatically reinstall and reconfigure in case of a shutdown."

Cons

"Some of the features will not be there. For example, some on-premises things we want to set up will not be supported there. There are some challenges that they are fixing."

"If we do not keep track of our costs, we might face some problems."

"The solution's version upgrade and performance could be improved."

"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."

"It would be helpful if they made it easier to migrate from an existing on-premises solution to the cloud-based service."

"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."

"The Performance Monitor they have is a little clanky, at least in regards to the UI."

"Amazon has a policy of automatically restarting the server every seven days."

More Amazon RDS cons

"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."

"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."

"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."

"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."

"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."

Pricing and Cost Advice

"By using a combination of Reserve Instances and On-Demand pricing, you can reduce the cost."

"The product is expensive."

"The cost depends on the kind of instance we use."

"AWS is becoming pretty expensive because cheap or absolutely free services have become paid services. Amazon RDS is not an expensive product, but Amazon's ecosystem is becoming increasingly expensive."

"It is less expensive than SQL Server. We pay based on the usage on a monthly basis."

"The solution is fairly priced."

"The price of Amazon RDS is expensive."

"The price could be better."

More Amazon RDS pricing and cost advice

"I would advise users to try the free 128GB version."

"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."

"SingleStore is a bit expensive."

"They have two main options: cloud installation and bare-metal installation, each with different pricing models."

"The price of the product is okay compared to the other available solutions in the market. SingleStore is a reasonably priced product, considering the functions it offers."

"The product's licensing is not expensive. It is comparable."

See which vendors are best for you

Use our free recommendation engine to learn which Database as a Service (DBaaS) solutions are best for your needs.

See recommendations

824,053 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

14%

Computer Software Company

13%

University

Manufacturing Company

Financial Services Firm

30%

Computer Software Company

14%

Manufacturing Company

Healthcare Company

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 is your experience regarding pricing and costs for Amazon RDS?

I find the pricing of Amazon RDS fair, as AWS operates on a pay-for-what-you-use model. Auto scalability helps handle varying demand, making it cost-efficient without overprovisioning resources.

What needs improvement with Amazon RDS?

For improvements, Amazon RDS could work on more features for multi-availability zone deployment to enhance higher availability, and on simplifying migration for those transitioning from on-premises...

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...

MongoDB Atlas vs Amazon RDS

Comparisons

Compared 31% of the time

Google Cloud SQL vs Amazon RDS

Compared 23% of the time

Microsoft Azure SQL Database vs Amazon RDS

Compared 18% of the time

Oracle Database as a Service vs Amazon RDS

Compared 16% of the time

IBM Db2 on Cloud vs Amazon RDS

Compared 1% of the time

More Amazon RDS Competitors

ClickHouse vs SingleStore

Compared 11% of the time

Teradata vs SingleStore

Compared 8% of the time

Chroma vs SingleStore

Compared 7% of the time

SQL Server vs SingleStore

Compared 7% of the time

More SingleStore Competitors

Product Reports

Download Amazon RDS product report

Amazon RDS

December 2024

Download SingleStore product report

November 2024

Also Known As

RDS

No data available

Learn More

Amazon Web Services (AWS)

Video not available

Overview

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, resizeable capacity for an industry-standard relational database and manages common database administration tasks.

SingleStore enables organizations to scale from one to one million customers, handling SQL, JSON, full text and vector workloads — all in one unified platform.

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.