Amazon Aurora vs SingleStore comparison

Read 7 SingleStore reviews

236 Views
190 Comparison Views

100% willing to recommend

Amazon Aurora

Comparison Buyer's Guide

Download the report

Executive Summary

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.

To learn more, read our detailed Relational Databases Tools Report (Updated: February 2025).

Relational Databases Tools

Download the complete report

Helped 838,713 peers since 2012

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 Aurora

Average Rating

8.2

Reviews Sentiment

6.5

Number of Reviews

Ranking in other categories

Relational Databases Tools (9th)

SingleStore

Average Rating

8.8

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

Database as a Service (DBaaS) (7th), Vector Databases (13th)

Mindshare comparison

While both are Databases solutions, they serve different purposes. Amazon Aurora is designed for Relational Databases Tools and holds a mindshare of 3.4%, down 4.3% compared to last year.
SingleStore, on the other hand, focuses on Database as a Service (DBaaS), holds 1.6% mindshare, up 0.8% since last year.

Relational Databases Tools

Database as a Service (DBaaS)

Featured Reviews

Rajitha Jatothu

Aws Devops Engineer at LTIMindtree

Achieve high performance with fault-tolerant and highly available database management

Aurora is a key pillar for us, offering performance and availability. It is faster than RDS and supports multi-region clusters and scalability. One feature we value is Aurora's ability to provide a reader endpoint, allowing applications to connect without tracking replicas. It supports auto-scaling and offers several options for monitoring and optimizing database performance. Aurora's fault tolerance and ability to handle multiple replicas contribute to its reliability and high performance.

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

"Aurora is a key pillar for us, offering performance and availability."

"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 features of Amazon Aurora include the global instance with the global writer endpoint, which allows failovers and instance switches without requiring changes in my code, thanks to the default global Route 53 endpoint."

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

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

"We had better control over the parameters that we could tweak in terms of intermediate storage and better indexing capabilities."

"Amazon Aurora stands out for its ease of use in a managed environment, inbuilt security, continuous backups, numerous read replicas, multi-region automated replication, and seamless integration with other AWS services."

More Amazon Aurora pros

"The product's initial setup phase was pretty straightforward, with no complex processes."

"The paramount advantage is the exceptional speed."

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

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

"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."

Cons

"In Oracle, tools like Veridata allow for comparing databases and certifying data accuracy, even offering repair capabilities, which are missing in Aurora. There should be a similar comparison tool in Aurora."

"The pricing could improve. It should be reduced."

"One of the most valuable features is storage scaling."

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

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

"Room for improvement might be in the UI, integrations, or data working capabilities for better user experience."

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

"I would like to see more AI-related features in future releases."

More Amazon Aurora cons

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

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

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

Pricing and Cost Advice

"There is no need to buy a license for the product. We can pay as per the use case."

"The price could be lower compared to its competitors."

"It is an expensive solution."

"It is quite expensive."

"I would rate the pricing a six out of ten, with ten being expensive."

"The tool’s pricing depends on the instance type. For cost optimization purposes, we use the result instance category."

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

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

See which vendors are best for you

Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.

See recommendations

838,713 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

27%

Computer Software Company

15%

Government

Manufacturing Company

Financial Services Firm

33%

Computer Software Company

13%

Healthcare Company

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Amazon Aurora?

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.

What is your experience regarding pricing and costs for Amazon Aurora?

AWS is costlier than self-managed solutions, but this includes the managed service experience. Their pricing is fair and reflects the managed service and additional features AWS offers.

What needs improvement with Amazon Aurora?

AWS RDS doesn't provide an option to apply one-off patches, which can be critical for business due to unexpected product bugs. While self-managed systems allow immediate patch application, RDS has ...

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

SQL Server vs Amazon Aurora

Comparisons

Compared 38% of the time

Oracle Database vs Amazon Aurora

Compared 24% of the time

MariaDB vs Amazon Aurora

Compared 9% of the time

SAP HANA vs Amazon Aurora

Compared 6% of the time

More Amazon Aurora Competitors

ClickHouse vs SingleStore

Compared 12% of the time

Chroma vs SingleStore

Compared 7% of the time

SQL Server vs SingleStore

Compared 7% of the time

Teradata vs SingleStore

Compared 7% of the time

MongoDB vs SingleStore

Compared 6% of the time

More SingleStore Competitors

Product Reports

Amazon Aurora

Download Amazon Aurora product report

Download SingleStore product report

Overview

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases.

Amazon Aurora is up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. It provides the security, availability, and reliability of commercial databases at 1/10th the cost. Amazon Aurora is fully managed by Amazon Relational Database Service (RDS), which automates time-consuming administration tasks like hardware provisioning, database setup, patching, and backups.

Amazon Aurora features a distributed, fault-tolerant, self-healing storage system that auto-scales up to 64TB per database instance. It delivers high performance and availability with up to 15 low-latency read replicas, point-in-time recovery, continuous backup to Amazon S3, and replication across three Availability Zones (AZs).

Visit the Amazon RDS Management Console to create your first Aurora database instance and start migrating your MySQL and PostgreSQL databases.

Amazon Web Services (AWS)

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

Dow Jones, Arizona State University, Verizon, Capital One, United Nations, Nielsen, Autodesk, Fanduel

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.

Relational Databases Tools