Skip to main content
TrustRadius
Amazon Aurora

Amazon Aurora

Overview

What is Amazon Aurora?

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

Read more
Recent Reviews

Amazon RDS Aurora.

9 out of 10
September 25, 2023
Incentivized
Amazon aurora was used for audit purposes. The main purpose was to audit IoT device activities performed by end user. All the information …
Continue reading

AWS Aurora Review

8 out of 10
September 22, 2023
Incentivized
In our organization, we leverage Amazon Aurora as a critical component of our database infrastructure. Aurora is a high-performance, fully …
Continue reading

Cost effective

9 out of 10
September 19, 2023
Incentivized
  • Primarily use it in our core payments platform given that we need strong ACID properties but we’re looking to transition to dynamodb soon …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 6 features
  • Automated backups (25)
    9.4
    94%
  • Database scalability (26)
    9.4
    94%
  • Automatic software patching (26)
    8.9
    89%
  • Monitoring and metrics (25)
    8.7
    87%

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Features

Database-as-a-Service

Database as a Service (DBaaS) software, sometimes referred to as cloud database software, is the delivery of database services ocer the Internet as a service

9.1
Avg 8.7
Return to navigation

Service Offering Details

What is Amazon Aurora?

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, built to combine the performance and availability of enterprise databases with the simplicity and cost-effectiveness of open source databases. The vendor states Amazon Aurora is up to 5X faster than MySQL databases and 3X faster than PostgreSQL databases, and that it provides the security, availability, and reliability of commercial databases at 1/10th the cost.

Amazon Aurora features a distributed, fault-tolerant, self-healing storage system that auto-scales up to 64TB per database instance. It delivers 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).

The vendor invites readers to learn more details on how they designed Amazon Aurora, from AWS CTO, Werner Vogels.

Amazon Aurora Screenshots

Screenshot of A look inside the RDS console.

Amazon Aurora Videos

How to create a first database cluster on Amazon Aurora.
What's new in Amazon Aurora

Amazon Aurora Availability

GeographyNAMER, EMEA, APAC, LATAM
Supported LanguagesEnglish, French, Chinese, Korean, Japanese

Frequently Asked Questions

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

Microsoft SQL Server, Oracle Database, and PostgreSQL are common alternatives for Amazon Aurora.

Reviewers rate Database scalability and Automated backups highest, with a score of 9.4.

The most common users of Amazon Aurora are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives

Compare with

Return to navigation

Reviews and Ratings

(161)

Attribute Ratings

Reviews

(1-25 of 44)
Companies can't remove reviews or game the system. Here's why
September 25, 2023

Amazon RDS Aurora.

Score 9 out of 10
Vetted Review
Verified User
Incentivized
Amazon aurora was used for audit purposes. The main purpose was to audit IoT device activities performed by end user. All the information is fed into Aurora database and later use to analytics purpose what activities are performed by user. Also provide user the history of their activities.
  • Fetch performance is great.
  • Huge cluster size.
  • Easy to setup.
  • Supports InnoDB.
  • Does not support small RDS.
It's suited where you have enterprise applications and integrate open-source databases without requiring a license.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Amazon Aurora comes with an easy to use and intuitive workflow. Our business started using Amazon Aurora to handle vast websites with huge content and file systems. We nearly have 500+ websites and all of them use Amazon Aurora. As far as I know, everything has been seamless until now. Of course there were hiccups in the between with some outages but were handled by Amazon Aurora support very well.
  • Concurrency
  • Excellent transaction time
  • Perfect compatibility with our sites
  • Ease of scaling
  • Little less transparent on insights
  • Non-availability of standalone solutions. I understand amazon aims for cloud based solution. But having a facility with standalone will look great
  • Lastly, of course pricing could be more dynamic so we can only pay for what we opt for
We have around 500+ websites in which we are using Amazon Aurora. Most of them are huge in terms of content and transactions per minute that the databases handle. In my opinion, database encryption is well defined. It automatically upsizes, upscales the clusters that it provides per database.
Once we had an outage for around 30hours. We have one website which sends around 1.5k files at a time monthly to another vendor using the database. We had an outage once and had a backlog of around 12k files not being sent to our other vendor. But, support team was readily available in shifts the whole time, they passed on notes of what and how much work is done to their colleagues and resolved the issue within 30hours (which would have easily taken 4-5 working days to understand) for us.
September 22, 2023

AWS Aurora Review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
In our organization, we leverage Amazon Aurora as a critical component of our database infrastructure. Aurora is a high-performance, fully managed relational database service that provides compatibility with MySQL and PostgreSQL. Our organization uses Amazon Aurora to address several business problems and improve the efficiency and reliability of our applications.
  • High Availability and Fault Tolerance
  • High Performance
  • Backup and Restore feature
  • It has a limited support for non-SQL/PostgreSQL engines
  • More integration with other AWS services
Amazon Aurora is very well suited in situations where the application requires high scalability and has variable and unpredictable workloads. Also, real-time analysis and reporting could be performed easily using Aurora's read replica feature. Aurora might not be a good fit for applications that rely more on other cloud-based services such as Azure since there are some issues with regards to integrations.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
My organization uses Amazon Aurora as a database to store customer request information at scale. We also scan the database at a minimum of every 10 minutes to produce telemetry towards insights on customer usage
  • Scalability
  • Availability
  • Low Latency
  • Reasonable Cost
  • Schema update was challenging, but it is difficult for RDBMS in general
reasonable resource for large scale with more defined schema. Users should avoid if your schema updates often
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use RDS/Amazon Aurora for some of our legacy databases that we need to retain for governmental reporting on a low frequency basis.
  • Scalability
  • Enable and disable database as needed
  • Database administration
  • Training and examples for vairoud use cases
Perfect for using it workloads where you don't need your database running all day long everyday. With Aurora, you can start and stop the database on demand and save costs also.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Amazon Aurora is a relational database service offered by AWS that is designed for high performance, availability, and scalability. It's compatible with MySQL and PostgreSQL. We use both MySQL and PostgreSQL for our client databases. Depending on our needs.
  • High availability.
  • Compatibility.
  • High throughput.
  • Cost
  • Complexity
For running a high-traffic e-commerce solution that needs to handle a massive stream of user data, products and deal with inventory updates. It works really well and you can easily add replicas to deal with i.e. load balancing.
September 20, 2023

A powerful RDBMS

Ayush Dutta | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Powerful data handling
  • Migration facility
  • Cost effective application
  • GUI
  • Interaction
I used many Database management systems , I have even used MySQL, but yeah this is worth of cost and have a good security system, and has a faster deliver speed, which works smoothly and efficiently. Having this I have now stopped looking for other powerful databases, this is a perfect tool for large data handlers.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We are using native Amazon Aurora for several customers in his version of MySQL and postgres.

We use Amazon Aurora for Wordpress insatance in E Commerce portals
  • It's a AWS managed DB well supported
  • Auto upgrades
  • Snapshots
  • Backups
  • It's an standard DB
I really like Amazon Aurora for use as an db for an instance of Wordpress.

I think the performance is really good especially when you use it in a transactional use case.
September 19, 2023

Amazon Aurora Internals

Score 10 out of 10
Vetted Review
Verified User
Incentivized
It is very useful
  • High performance
  • high availability
  • scalability
  • Limited Availability of Compatibility Versions
  • Complexity in Cross-Region Replication
  • Storage Scaling Limitations
High Traffic Web Applications:Aurora is an excellent choice for high-traffic web applications that require fast response times and high availability. Its ability to scale both read and write operations makes it a strong contender.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
I use it as my company's main Mysql & Postgresql databases for development and productive web environments.
For its easy scalability, maintenance and high SLA.

  • scalability
  • maintenance
  • SLA
  • Price
  • Legacy versions
  • Compatibility with third party products for replication or backups.
Very good for auto-scalable web environments with variable loads. Especially in its Aurora Serverless version. It is more expensive than the normal RDS, but it is worth it for the simplicity of scalability.Aurora Serverless v2 fixes many of the limitations of v1.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Amazon Aurora helps me and my organisation to collect and review in the course of analyzing the query performance. It is very persuasive in nature. Even we can write codes using three easy accessible steps and even it stores six backups eventually while writing the codes in their platform. Best thing about this Aurora is if our one of the instance has been failed this will automatically use replicas to repair them and also create new instance automatically. Even their servers are clean and their indexing capabilities are complete.
  • Able to work on very big databases without any interruptions.
  • One of the best things about Aurora is everything is hosted in the cloud with wider capabilities.
  • It is easy to implement, and the interface is easy to access.
  • Very quick instances can be connected without the loss of data.
  • Its interface is quite simple but repetitive in nature.
  • Database authentication problems can be improved.
  • Sometimes logical errors occur which is annoying in nature.
Best thing about Aurora is that it is server less and relational database. I like it personally because of its performance which is quite impressive and its instances provide us a great experience. Also if Aurora have a script embedded in it so that we can our queries easily and there will be no requirement of other services to make the connection of the database.
September 19, 2023

Cost effective

Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Primarily use it in our core payments platform given that we need strong ACID properties but we’re looking to transition to dynamodb soon given that dynamodb also has transaction semantics
  • It is our de facto database for starting any new microservice
  • Cost effective relational database
  • High availability in multiple regions
  • Fully managed
  • I/O costs are incurred
  • Not fully MySQL compatible especially if you’re using something very specific to mysql
  • Might hit the upper limit on max number of connections
  • Great for when you need ACID/strong transaction semantics, dealing with financial data or anything structured
  • As you keep scaling beyond sharding/partitioning particularly for unstructured data it makes sense to start exploring NoSql/DynamoDb for your needs as somethings like scaling are achieved automatically with dynamodb. It’s sort of like have a dial where you can scale up or down based on the needs of your system.
Iván García | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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
  • If using Aurora Serverles v2 one thing missing is the possibility to reduce it to 0 ACU
If you are in need of an MySQL or PostgreSQL database, forget about using those engines on your own, installing and maintaining them in your own servers. Instead use Aurora MySQL or PostgreSQL compatibility on AWS. You will be free from the heavylifting by allowing RDS to take care of updates, patching, backups and maintenance of the database and servers.
You simply will have to connect to the dabase and take care of the data.
Judy L. Berglund | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Efficient monitoring of databases such as SQL, etc.
  • Fully automatic scaling
  • Fully encrypted backups
  • Price
  • Complex configurations
  • Technical Support could be better
I think Amazon Aurora is well suited in the database arena. Amazon Aurora abstracts the connections of the database instances relationships, with a sophisticated link point mechanism, achieving more speed when processing intermediate data, which is extremely positive for large volumes of data that need to be processed quickly. In my experience, Amazon Aurora is a powerful tool when replicating data, since it manages everything in its platform with read-only queries.
September 19, 2023

Even better than Amazon RDS

Score 10 out of 10
Vetted Review
Verified User
Incentivized
We have migrated some of our Amazon RDS workloads to Amazon Aurora with the hope of achieving better performance, scalability, security, and fault tolerance.
  • Concurrency
  • Fault tolerance
  • Latency
  • Cost
I think Amazon Aurora is well suited for migrating on-premise MySQL databases to the cloud, or for migrating existing Amazon RDS instances to a platform that's more suited for concurrency and high throughput applications. In my opinion, it's not (currently) appropriate for any database engines other than MySQL and PostgreSQL.
September 18, 2023

Amazing Amazon Aurora

Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Amazon aurora to manage large quantities of data for our company. We are able to see different challenges and positives that we are having. It is useful to use in our case because we manage a large amount of data. This relational database is user friendly that we can assign our college hires to use
  • Data management
  • Relational data
  • Comparisons
  • Notifications
This software is well suited to use when you need to compare data between sites and quarters. It is very good at these times as it brings the data over clearly between these times. It helps to compare to other National data standards. It is less appropriate to use if you are not comparing the data to another time or other companies data.
September 13, 2023

Awesome auRora

Ron Brown | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We currently use Aurora PostgreSQL to manage our real estate agents information that allow our agent to schedule clients listing appointments. We provide services to MLS across the country we managed this particular MLS application in the cloud which cost benefit for them and easier to manage for them.
  • Simple to setup and configure
  • Add additional replicas if needed
  • Cost effective
  • All good
  • Working for us
We have not had any real downtime even between upgrades and maintenance window time.
August 31, 2023

Amazon Aurora Review

Alok Pabalkar | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Amazon Aurora as our primary database used for hosting our Edtech SaaS Platform GIDE.AI
  • Transactional Queries
  • Storage Scale Up
  • Higher Performance
  • Compatibility with Mysql
  • Super Easy Cluster Mode setup
  • On the fly DB Vertical Scaling could be useful
  • Connection Display & stats can be present to see and improve app design
1. All Transactional Processes
2. Hosting a Web App
3. Storage of Structured Data
Manthan Dhola | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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
  • Improve Response time
  • Add write replica for scaling
  • database caching
  • Online Gaming Platforms
  • High Traffic Websites - Websites and web applications with heavy traffic loads can benefit from Aurora's scalability and read/write performance, ensuring responsive user experiences even during peak traffic times.
  • E-Commerce Platforms
  • Content Management Systems (CMS)
  • Analytical and Reporting Workloads - Organizations performing complex analytical queries and generating reports from large datasets can benefit from Aurora's performance optimizations and compatibility with popular reporting tools.
Lalitha Devi Segu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Easy to deploy
  • Easy to configure
  • easy to monitor
  • very user friendly and awesome tool
Amazon Aurora just works.My experience with Amazon Aurora has been nothing but excellent. The Aurora database platform has been easy to deploy, configure, monitor, and maintain, and its performance capabilities have been able to handle any amount of workload we've thrown at it.
Brooke Steed | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
  • 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.
Overall, our experience as an individual and company has been very positive. Happy to suggest Amazon Aurora to counterparts while trying to build my book of business.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We used Amazon Aurora to see how to increase the efficiency and learn AWS Services. Amazon Aurora Serverless is an on-demand, autoscaling configuration for Amazon Aurora. It automatically starts up, shuts down, and scales capacity up or down based on your application's needs. You can run your database in the cloud without managing any database instances. It is easy to use and super secure. On a data base instance running with aurora encryption, data store automated backup, replicas and snapshots in the same cluster.
  • Integration and Deployment
  • Service and Support
  • Product Capabilities
  • Security
  • Better price
  • Good documentation
  • High availability
As we just used the service to learn its basics, all systems seemed worked perfectly. I must say that overall, I’m very impressed. There are A LOT of limitations with this first release, but I believe that Amazon will do what Amazon does best, and keep iterating until this thing is rock solid.
Ed Mandret | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Amazon does offer two relational database services, namely RDS and Aurora. While both very similar, there are key differences in how they persist data on disk. RDS uses EBS volumes, which are limited up to 16k concurrent IOPS. On the other hand, Aurora uses a virtual storage cluster that supports up to 80k concurrent IOPS. When dealing with large clients whose database usage might exceed the 16 concurrent IOPS threshold, Aurora was the preferred choice to ensure higher availability.
  • High-availability
  • Multi-AZ configuration
  • Serverless support
  • Crash recovery
  • Asynchronous replication lag
  • Opaque pricing
Thanks to a completely different storage orchestration layer, Aurora supports far more concurrent IOPS than its counterpart, Amazon RDS, which uses individual EBS volumes. Thus, Aurora truly shines where high-performance is a major concern.

Also, Aurora supports a serverless DB cluster option, which is able to scale up/down based on application needs to save money. This is particularly suited for intermittent, unpredictable or infrequent workloads, where performance and reliability still matter.
Avantika Sikand | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
I use Aurora to integrate it with the SaaS product which helps in database encryption as data security is an important aspect of the product I work for. Also the automated multi-Region replication, and integrations with other AWS services helps me use Aurora with more ease.
  • Scale Relational database
  • integration with cloudwatch helps with monitoring the database efficiently
  • Autoscaling of Aurora clusters
  • max connections
  • loading data from S3 bucket
  • database cloning
Aurora backs up the cluster volume automatically and retains restore data for the length of the backup retention period this helps in scenarios where application restore is needed. It also offers better disaster recovery so this can be used for supporting disaster recovery plans.While Amazon RDS supports five database engines, Amazon Aurora supports just two. If you use MariaDB, Oracle, or Microsoft SQL Server, you have to fall back to RDS.
Score 6 out of 10
Vetted Review
Verified User
Incentivized
My company works on PostgreSQL-related products. With Aurora being so popular, this is something we support through our managed support services. With self-managed EC2, RDS, and Aurora competing for the same space, Aurora is great for large enterprises and most definitely a no-go for startups unless the use case is very specifically defined.
  • Fully Managed Database - PostgreSQL.
  • Scalability
  • High Availability.
  • Performant
  • Slow in upgrading to minor releases of PostgreSQL.
  • Aurora releases major versions of PostgreSQL with a massive lag.
  • Cost is obviously a concern.
It really depends on the use case. Do they really like Aurora and all the performance that it brings? Can they legally lag behind release versions by months? Since cost is also a major factor, the recommendation would have to be justified. The benefits are great, in most cases, Aurora isn't needed.
Return to navigation