Amazon Aurora

Score8.9 out of 10

159 Reviews and Ratings

What is Amazon Aurora?

Amazon Aurora is a global-scale relational database service built for the cloud with full MySQL and PostgreSQL compatibility.

Categories & Use Cases

Media

Screenshot of A look inside the RDS console.

Automated backups
Automated backup enabling point-in-time data recovery
Category average: 8.3
Database scalability
Ease of scaling compute or memory resources and storage up or down
Category average: 9
Database security provisions
Provision for database encryption, network isolation, and identity access management
Category average: 8.8

Automatic host deployment
Compute instance replacement in the event of hardware failure
Category average: 7.3
Automatic software patching
Patches applied to database automatically
Category average: 8.7
Monitoring and metrics
Built-in monitoring of multiple operational metrics
Category average: 6.7

Most Frequent Users

Top 3 industries using Amazon Aurora.

Based on HG Insights installation data

View all Reviews

#1 most frequent

Professional, Scientific, and Technical Services

27.1%

1,646 installations of 6,064

#2 most frequent

Information

21.4%

1,295 installations of 6,064

#3 most frequent

Finance and Insurance

13.1%

792 installations of 6,064

Ayush Dutta View profile

Game Developer in Marketing at Itch.io (1-10 employees employees)

Use Cases and Deployment Scope

A perfect and powerful database management system, I received this application from one of my colleagues, after changing from many DBs like one them is MongoDB.
It has a powerful life of taking a huge amounts of data, as for long I have been working with data, I wanted a powerful and well working database system for working efficiently and effectively with my data works, well this application has a cool and powerful chain system for making relationships with various data. I loved it.

Pros

Powerful data handling
Migration facility
Cost effective application

Cons

GUI
Interaction

Return on Investment

Positive: Cost effectiveness
Positive: large data storage
Positive: High security features
Negative: Lacking interactiveness
Negative: Lags when high input is placed.

Alternatives Considered

MongoDB and RavenDB

Other Software Used

RavenDB, MongoDB

Iván García View profile

Consultant in Professional Services at Datum, S.A. (11-50 employees employees)

Use Cases and Deployment Scope

As any company that have to use a database to store information not only for the business data but also for different applications, we decided to use Aurora MySQL to ease the administration and be safe that AWS will handle all patching, updates, backups and maintenance of the database.

Pros

No need to provision storage nor IOPS for the disks
Automatics continuos backups with the possibility to point-in-time restore in new database or backtrack to a point in time in the same database
Increase availability by using Read Replicas and also distributing read capacity using them for queries

Cons

If using Aurora Serverles v2 one thing missing is the possibility to reduce it to 0 ACU

Return on Investment

We have had zero issues on our site related to database availability since using Aurora
The avilability of our site has been 100% during the last year
No more database administration hassell

Other Software Used

Amazon Elastic File System (EFS), Amazon EC2 Auto Scaling, Amazon Elastic Compute Cloud (EC2)

Manthan Dhola View profile

Solutions Architect in Professional Services at BIDAYA TECH (11-50 employees employees)

Use Cases and Deployment Scope

We use Aurora MySQL for the database of Magento 2. This handles the load very fine and is has 100% uptime with low resilience and no packet loss. Moreover we use Aurora for scalability from the Read replicas used for read transactions and scaling the database. The restore in time feature also allows us if we need to restore the database for specific time of the day.

Pros

100% Uptime with no packet losses
Scalability with read replicas
fully managed database
Restore Point in Time
Handel more load than mysql
Parallel Queries supported

Cons

Improve Response time
Add write replica for scaling
database caching

Return on Investment

positive - very fast website thus increasing google ranks
positive - efficient database
negetive - high cost

Alternatives Considered

Azure SQL Database and Google Cloud SQL

Other Software Used

Azure SQL Database, Google Cloud SQL, Oracle Cloud Infrastructure

Brooke Steed View profile

Recruiter in Information Technology at Kavaliro (51-200 employees employees)

Use Cases and Deployment Scope

Our day to day work requires the handling of sensitive information day in and day out. That being said - Security and backups are absolutely crucial to the company's ability to successfully and ethically work. Amazon Aurora provides these services on the front and back end simultaniously while we focus on our objectives.

Pros

Provides continuous backups while other applications are running without causing any interruption in production.
Provides built-in security features i.e. encryption at rest and in-transit, making sure that our data is secure both during storage and transmission.
Allows us to easily monitor the database's performance metrics and analyze them to optimize query performance and identify any potential issues.

Cons

Improve the ability to handle time zone conversions and daylight saving time.
Geospatial data is becoming increasingly important in various applications, and Aurora currently lacks built-in support for geospatial data types and functions.
I think allowing and enchancing schema changes would improve the overall database management experience.

Return on Investment

It has improved application responsiveness, reduced query execution times, and increased customer satisfaction. Faster response times have resulted in higher user engagement and potentially lead to increased revenue.
If an organization operates in a hybrid or multi-cloud environment (like us), data transfer costs between AWS services and other cloud providers could impact the overall ROI.
While Amazon Aurora can provide cost savings over time, the pricing structure should be evaluated against specific workload requirements. Though I don't believe we've entirely recieved our ROI quite yet, we are on a fast track to surpass it drastically.

Judy L. Berglund View profile

Sr Systems Engineer in Engineering at Dell EMC (10,001+ employees employees)

Use Cases and Deployment Scope

Amazon Aurora is characterized by high availability and performance in the cloud that few tools of the same characteristics offer, the cost is initially 10GB for free, but then costs increase but the amount of capacity used, however it can be really low and its use guarantees integrated security, with regular backups and fully protected by the Amazon Aurora system. It's a fully managed system which reduces the workload and automates many daily tasks that would take a lot of time to perform manually. Another important point to take into account is that the tool automatically recovers from any failure, if one of our instances fails the system uses replicas to repair them creating new instances automatically.

Pros

Efficient monitoring of databases such as SQL, etc.
Fully automatic scaling
Fully encrypted backups

Cons

Price
Complex configurations
Technical Support could be better

Return on Investment

Very positive impact, less operator intervention
Scalability is automatic
Overall costs have been reduced due to the automation and HA built into the product
Fully encrypted backups which is very important

Alternatives Considered

Spendview for Snowflake and Teradata Vantage

Other Software Used

Azure Backup, AWS CloudFormation, AWS CodeBuild

Microsoft SQL Server

PostgreSQL

Oracle Database

Amazon Aurora

What is Amazon Aurora?

Categories & Use Cases

Media

Amazon Aurora Key Features

Top Performing Features

Automated backups

Database scalability

Database security provisions

Areas for Improvement

Automatic host deployment

Automatic software patching

Monitoring and metrics

Who Buys & Uses Amazon Aurora

Most Frequent Users

Professional, Scientific, and Technical Services

Information

Finance and Insurance

Most Frequent Users

Small Businesses

Mid-sized Companies

Enterprises

Most Frequent Users

United States of America

United Kingdom of Great Britain and Northern Ireland

India

Most Frequent Users

Engineering

IT

Product Management

Amazon Aurora Reviews

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Other Software Used

Amazon Aurora Alternatives