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

Amazon Aurora vs CockroachDB comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Amazon Aurora
Ranking in Relational Databases Tools
10th
Average Rating
8.2
Reviews Sentiment
6.5
Number of Reviews
12
Ranking in other categories
No ranking in other categories
CockroachDB
Ranking in Relational Databases Tools
11th
Average Rating
8.0
Reviews Sentiment
7.7
Number of Reviews
12
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of December 2024, in the Relational Databases Tools category, the mindshare of Amazon Aurora is 3.6%, down from 4.3% compared to the previous year. The mindshare of CockroachDB is 3.1%, up from 2.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
 

Featured Reviews

Rajitha Jatothu - PeerSpot reviewer
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.
Antonio Tringali - PeerSpot reviewer
Open source with extensive documentation and a University for training
I am a freelancer. A client of mine wanted a solution that would allow them to scale yet not abandon the familiar PostgreSQL front-end (and rewrite a part of their source code). Scalability aside, CockroachDB is a fine way forward from PostgreSQL and is not changing the client source code part of the system. If you are lucky and you do not use newer features from recent versions of PostgreSQL or PostgreSQL extensions, it's fine. There are nice-to-have features for big organizations like regional tables. At the moment, my client simply does not use these. However, the serverless offer from CockroachDB is reacting well as data grows.

Quotes from Members

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

Pros

"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 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 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."
"We had better control over the parameters that we could tweak in terms of intermediate storage and better indexing capabilities."
"The provision of custom read and write endpoints eliminates the need for managing a separate proxy load balancer."
"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."
"Aurora is a key pillar for us, offering performance and availability."
"Aurora's features that I find the most beneficial include its database backup strategy, performance options, and input-output operations."
"The availability and the easy to use feature is the most valuable. The documentation is also good."
"The most valuable features of the solution are its resiliency features and the geo-partitioning capabilities."
"The best feature of CockroachDB is the ability to keep the nodes in different locations."
"I use CockroachDB to test big data samples and to create the best structure for databases. We have four users and required 10 people for deployment and maintenance."
"The subset of SQL that my client is using is completely supported."
"CockroachDB is highly reliable."
"The product has valuable security features."
"The most valuable feature is that CockroachDB is a distributed database, which can deploy nodes running in different regions."
 

Cons

"The pricing could improve. It should be reduced."
"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."
"It would have been helpful if they had provided some benchmarking numbers."
"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."
"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."
"The product's distributed query process for MySQL needs improvement."
"The product must improve its disaster recovery features."
"The platform could be more extensible."
"The closer they can make CockroachDB to being completely compatible with Postgres, the better. It's almost compatible, but not completely. If it was, it would be nice to just be able to use Postgres libraries without any fiddling."
"CockroachDB needs to improve store processes."
"Cockroach does not support all types of protocols. I need to improve it myself to support a CouchDB on my network."
"I would like CockroachDB to have more compatibility with PostgreSQL, especially with the connection string and technical integrations."
"We are looking for more features to support distributed high availability and geo-partitioning."
"I think the engine itself could be improved. If you miss a partition key, it should be able to be modeled. This is where AI could be really helpful. For example, if a user is from Australia, the system should know to look for their data there first instead of searching in the US or another continent."
 

Pricing and Cost Advice

"The tool’s pricing depends on the instance type. For cost optimization purposes, we use the result instance category."
"It is an expensive solution."
"I would rate the pricing a six out of ten, with ten being expensive."
"The price could be lower compared to its competitors."
"There is no need to buy a license for the product. We can pay as per the use case."
"It is quite expensive."
"The platform is affordable even for the enterprise version. It provides value for investment in terms of performance."
"The pricing is good but can be made cheaper. I would rate the pricing a five out of ten."
"The solution's pricing is not cheap. However, the good thing is that customers are willing to pay for it if they want it."
"The product's price depends on the user's company and the contract model they enter into with CockroachDB. Depending on the contract model one enters into with CockroachDB, the product may or may not be expensive."
"I've used CockroachDB at a small scale on the free accounts because we are only testing."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
824,053 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
28%
Computer Software Company
14%
Government
5%
Manufacturing Company
5%
Financial Services Firm
40%
Computer Software Company
14%
Retailer
5%
Manufacturing Company
4%
 

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?
While the setup cost of Aurora is not explicitly discussed, managing cloud pricing effectively is key to understanding overall expenditures. There is a preference to reduce costs per hour to encour...
What needs improvement with Amazon Aurora?
Aurora’s finance aspects could be improved, particularly in reducing the per-hour use cost. This would help more users accept Aurora. I also faced challenges due to the static memory provisioning s...
What do you like most about CockroachDB?
The subset of SQL that my client is using is completely supported.
What needs improvement with CockroachDB?
I would like CockroachDB to have more compatibility with PostgreSQL, especially with the connection string and technical integrations.
What is your primary use case for CockroachDB?
I am studying how to deploy CockroachDB and YugaByteDB, and learning some basic information about them. I am testing these databases as part of my school application to find a suitable database for...
 

Comparisons

 

Overview

 

Sample Customers

Dow Jones, Arizona State University, Verizon, Capital One, United Nations, Nielsen, Autodesk, Fanduel
Baidu, Kindred, Tierion, Heroic Labs, Gorgias
Find out what your peers are saying about Amazon Aurora vs. CockroachDB and other solutions. Updated: December 2024.
824,053 professionals have used our research since 2012.