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

Amazon Aurora vs Citus Data comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Amazon Aurora
Ranking in Relational Databases Tools
10th
Average Rating
8.2
Number of Reviews
9
Ranking in other categories
No ranking in other categories
Citus Data
Ranking in Relational Databases Tools
21st
Average Rating
8.0
Number of Reviews
3
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Relational Databases Tools category, the mindshare of Amazon Aurora is 3.7%, down from 4.3% compared to the previous year. The mindshare of Citus Data is 1.7%, up from 1.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
 

Featured Reviews

Julius Mboya - PeerSpot reviewer
Aug 14, 2024
Offers features for day-to-day management of large-scale databases
There should be constant changes, which can be challenging to keep up with annually. The UAE evolves rapidly, and after just a two-month break, you might find that things have shifted around. It would be helpful to have a more structured way of introducing these changes. I like how Microsoft does it with Patch, where you know to expect updates regularly. If AWS implemented something similar, the update pattern would be more predictable. The only database issue we encountered was when we were using a read replica for both read and write operations. This sometimes caused the database to be slow, likely because the read queries weren’t optimized. However, the issue was resolved once we split the read and write operations into separate replicas, and everything has been smooth since then.
Arucy Lionel - PeerSpot reviewer
Nov 20, 2023
Efficiently handles high-traffic scenarios and compatible with PostgreSQL extensions, offering flexibility in database management
There are many areas of improvement , especially in terms of DDL query routing. Even though it's masterless, DDL queries need to be sent to the coordinator node. Also, setting up a multi-node environment could be more straightforward. Currently, setting up a multi-node environment is challenging. It's a bit tricky. Installation on each PostgreSQL node can lead to communication issues between nodes. An automatic rebalancing feature would be a significant improvement. Currently, I have to manually command the rebalance. It would be more convenient if it was rebalanced automatically. The dashboard and monitoring capabilities are good, but it would be helpful to have an integrated availability dashboard.

Quotes from Members

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

Pros

"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."
"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."
"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."
"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."
"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."
"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."
"You can use Citus Data to write complex scripts. I like its version upgrades and disaster recovery as well."
"Its distributed processing capabilities are a standout feature. It requires minimal changes to get up and running if you already have a system on PostgreSQL. Citus can run in its natural state."
"It's very straightforward to implement the solution. It took us two days to set up everything."
 

Cons

"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."
"The pricing could improve. It should be reduced."
"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."
"The product's distributed query process for MySQL needs improvement."
"While Amazon Aurora meets your current scaling and storage needs, there is room for improvement in cryptography and scalability compared to other databases."
"It would have been helpful if they had provided some benchmarking numbers."
"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."
"Citus Data needs to improve its stability. Do not consider this product if you have the budget. It is still developing and has a lot of issues."
"More features in monitoring and the reporting could make it better."
"There are many areas of improvement , especially in terms of DDL query routing. Even though it's masterless, DDL queries need to be sent to the coordinator node. Also, setting up a multi-node environment could be more straightforward."
 

Pricing and Cost Advice

"It is quite expensive."
"I would rate the pricing a six out of ten, with ten being expensive."
"It is an expensive solution."
"The price could be lower compared to its competitors."
"The tool’s pricing depends on the instance type. For cost optimization purposes, we use the result instance category."
"There is no need to buy a license for the product. We can pay as per the use case."
"Citus Data is an open-source product."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
815,209 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
27%
Computer Software Company
15%
Government
5%
Manufacturing Company
4%
Computer Software Company
18%
Financial Services Firm
11%
Manufacturing Company
11%
Comms Service Provider
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

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 needs improvement with Amazon Aurora?
There should be constant changes, which can be challenging to keep up with annually. The UAE evolves rapidly, and after just a two-month break, you might find that things have shifted around. It wo...
What do you like most about Citus Data?
You can use Citus Data to write complex scripts. I like its version upgrades and disaster recovery as well.
What needs improvement with Citus Data?
Citus Data needs to improve its stability. Do not consider this product if you have the budget. It is still developing and has a lot of issues.
 

Comparisons

 

Overview

 

Sample Customers

Dow Jones, Arizona State University, Verizon, Capital One, United Nations, Nielsen, Autodesk, Fanduel
Cloud Flare, Agari, Mix Rank, Heap
Find out what your peers are saying about Amazon Aurora vs. Citus Data and other solutions. Updated: October 2024.
815,209 professionals have used our research since 2012.