Amazon Aurora

Score8.2 out of 10

162 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
Database scalability
Ease of scaling compute or memory resources and storage up or down
Category average: 9.2
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: 6.8
Automatic software patching
Patches applied to database automatically
Category average: 8.3
Monitoring and metrics
Built-in monitoring of multiple operational metrics
Category average: 6.8

Verified User

Employee in Information Technology (51-200 employees employees)

Use Cases and Deployment Scope

We currently use Amazon Aurora across all of our clients and have recently migrated over to the V2 type. This is a great product offered by AWS as it solves a lot of the maintenance problems we would otherwise have to address, and it offers high performance and easy to configure and change parameters.

Pros

Easy to maintain
Easy to configure
Can change instance types quickly
Offers great DR options

Cons

Sometimes too many options of instance types, versions, engines, etc. so can get confusing

Return on Investment

Setup costs low
Maintenance costs low
Easy to setup DR
Easy to adjust instance type based on usage
Ability to add reserved instance to keep costs down

Usability

Alternatives Considered

Azure Database

Other Software Used

Amazon Relational Database Service (RDS), Amazon ElastiCache, Azure Database, AWS Database Migration Service

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.

Microsoft SQL Server

PostgreSQL

Oracle Database

Amazon Aurora

What is Amazon Aurora?

Categories & Use Cases

Media

Key Features

Top Performing Features

Automated backups

Database scalability

Database security provisions

Areas for Improvement

Automatic host deployment

Automatic software patching

Monitoring and metrics

Reviews

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Usability

Alternatives Considered

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

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

Related Products