Overview
What is Amazon Aurora?
Amazon Aurora is a global-scale relational database service built for the cloud with full MySQL and PostgreSQL compatibility.
Great, intuitive and a must have with larger businesses
AWS Aurora Review
Great resource for product that requires great scalability with high availability
Excellent low maintenance and self administration qualities with Amazon Aurora DB.
Amazon Aurora: Empowering Scalability and Performance for Modern Database Management.
A powerful RDBMS
Amazon Aurora Internals
Aurora Serverless is the perfect database as a service in scalability if you do not want headaches or waste time managing databases.
For its easy scalability, …
Best Serverless computing platform.
Cost effective
- Primarily use it in our core payments platform given that we need strong ACID properties but we’re looking to transition to dynamodb soon …
Amazon Aurora - what an excellent solution for Database problems
Migrating your databases to Amazon Aurora to reduce Storage Costs
Even better than Amazon RDS
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
- Automated backups (25)9.494%
- Database scalability (26)9.494%
- Automatic software patching (26)8.989%
- Monitoring and metrics (25)8.787%
Reviewer Pros & Cons
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
- 8.9Automatic software patching(26) Ratings
Patches applied to database automatically
- 9.4Database scalability(26) Ratings
Ease of scaling compute or memory resources and storage up or down
- 9.4Automated backups(25) Ratings
Automated backup enabling point-in-time data recovery
- 9.2Database security provisions(24) Ratings
Provision for database encryption, network isolation, and identity access management
- 8.7Monitoring and metrics(25) Ratings
Built-in monitoring of multiple operational metrics
- 9.1Automatic host deployment(23) Ratings
Compute instance replacement in the event of hardware failure
Service Offering Details
- About
- Integrations
- Competitors
- Tech Details
- FAQs
What is Amazon Aurora?
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
Amazon Aurora Videos
Amazon Aurora Supported Products
Amazon Aurora Competitors
Amazon Aurora Availability
Geography | NAMER, EMEA, APAC, LATAM |
---|---|
Supported Languages | English, French, Chinese, Korean, Japanese |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(160)Attribute Ratings
Reviews
(1-4 of 4)Aurora Serverless is the perfect database as a service in scalability if you do not want headaches or waste time managing databases.
For its easy scalability, maintenance and high SLA.
- scalability
- maintenance
- SLA
- Price
- Legacy versions
- Compatibility with third party products for replication or backups.
- Automatic software patching
- 90%9.0
- Database scalability
- 90%9.0
- Automated backups
- 100%10.0
- Database security provisions
- 90%9.0
- Monitoring and metrics
- 90%9.0
- Automatic host deployment
- 90%9.0
- Less time wasted by Sysadmin and DBAdmin to manage non-value-added tasks.
- Quicker installation and auto-scaling (in its Aurora Serverless version)
- Ease of backup, snapshot, replication, cloning for migrations
- Amazon Relational Database Service (RDS)
- Website DB
- Datawarehouse
- Internal DB
- Serverless
- Autoscale
- New websites
- New internal product
- Cloud Solutions
- Scalability
- Ease of Use
Amazon Aurora - A Boost on Standard MySQL
- Amazon Aurora has high availability, since the customer started to use it, the database never had to be left out of service.
- Amazon Aurora provides frequent and automated upgrades, which makes our database system always up to date on the latest features and security practices
- Since Amazon Aurora uses MySQL as its core database, it is very easy to find specialized people to work. Amazon’s relational database management system also makes it very easy to expand and create new databases
- The cost of Amazon Aurora when compared to a simple MySQL instance is considerably higher, so we really need to look at and run some performance tests to compare if the performance improvements are worth the extra cost.
- Although backup restores are a rare feature to use, when we need them it is always painful to restore our data. We are always searching for a database service to provide new and innovating features in terms of data recovery. For instance, being able to search on backup information to see if the needed data is there. It is a very common need to compare the hot data with the backup data, for example to fix some database data that a malfunction application wrongly updated.
- Since aurora is an Amazon relational database service there is no way to run a dev database on a local storage for tests and development.
- The customers where we implemented Amazon Aurora database don't need to have an employee specialized in features and security upgrades.
- The database replication and schedule for backup tasks are much easier, so less prone to errors.
- We have never had a database downtime on our applications, which is essential for our customer business.
Unlike proprietary solutions like Microsoft SQL Server, Amazon Aurora does not need proprietary licensing, so we can use this budget to get cloud solutions with high availability and performance, at a similar rate. When compared to MySQL or Postgres SQL, it allows us to have a database system always updated with the most current features and security best practices without having to worry about it. In normal database systems like MySQL to keep the database system up to date we need to have someone always looking for new upgrades.
As it relies on MySQL there is no extra formation for a team that is already used to a MySQL solution.
- Warehouse Management Application - Used to manage warehouse. we manage stocks, inventories, movements, stock allocation and user tasks.
- Integrations Logs repository - We have a very demanding integration system, with millions of logs generated each day. Amazon Aurora is where we store that data.
- IOT data lake - We use Amazon Aurora as our IOT repository. It can handle large volumes of data with real-time processing.
- Predictive maintenance plans - Our IOT environment collects millions of data entries per day, from hundreds of sensors. With that information stored in Amazon Aurora, together with Amazon Greengrass we are able to identify trends on machine malfunctions, and predict at some level, when a machine is going out of the usual behavior trend.
- Sales prediction - we have some ongoing projects that intend to catch sales trends, allowing us to have a better stock management system, better stock reposition and to avoid stock outages. We will rely on Amazon Aurora speed to analyze millions of historic sales.
Aurora is a great managed sql service by AWS
- Automatic scaling of read replicas
- Quick vertical scaling of server size
- Scaling metrics to determine the right time to scale for cost efficiency
- Self updates
- Better explanations of configuration settings
- Easier error logging when failovers are required
- More information on best practices for common scenarios like when database size gets too big or queries slow down
- Auto scaling read replicas
- Multi AZ with little effort required
- Easily upgrade server size within minutes
- Aurora allowed us to produce events that support 5000 users on our website within a matter of minutes.
- Aurora saves us time by auto-scaling daily based on concurrent requests or CPU usage.
- Aurora storage space expands automatically as our database size grows so we don't have to spend time monitoring it.
- Storing data
- Scaling for changes in traffic
- Providing CLI access
- Providing an easy way to upgrade to larger servers
- The simplicity of scaling has made it easy to support gradual growth in traffic with just a few clicks to scale in a new size server and perform a failover swap.
- The blue/green deployment was also very simple for upgrading the MySQL version.
- It's definitely going to be our main SQL database for the future and we have no plans to shift from it.
- I'd like to see cheaper serverless options so that I can prototype new apps without costing a fortune. Right now the serverless is pretty expensive.
- Product Usability
- Implemented in-house
- Choosing initial server size
- Scaling the databases
- Creating the databases
- Upgrading the server size or software version
- Viewing real time queries
- Viewing real time stats because they're delayed by what seems like a minute
- Figuring out why the database crashes if it gets to cpu usage of 99%+
- Auto-expansion of the disks. The administrators don't have to worry about disk sizes anymore.
- Default configuration sets are designed for the majority of the OLTP use-cases. As a developer, I don't have to worry about tuning the MySQL configurations anymore.
- Better Performance than MySQL hosted on EC2 instances. The Aurora architecture allows faster replication as well.
- Access to slow query, and error logs is a little cumbersome. Maybe, stream that to an AWS Elasticsearch, and provide searching out of the box (even if it means additional costs).
- Upgrade to higher versions of MySQL is a problem.
- Failovers to replica, although, they are not needed often, they can be made more seamless.
Less Appropriate: It can be a bit pricey. If you are operating under a budget, this may not be the right tool. RDS is slightly cheaper than Aurora. Configurations and documentation can be confusing at times, but if you have access to the AWS Solution Architects, it gets easier.
- Well-defined Configuration Sets that take care of most workload requirements. No manual configuration is needed.
- Auto expansion of the disks that makes scaling easier.
- Better read/write performance as compared to self-hosted database instances.
- Improved performance leading to better product experience.
- As configurations are templated, fewer human errors, and higher stability.
- Increased costs of the overall infra, but the performance, and stability guarantees are compensating the higher costs.
- Amazon Relational Database Service (RDS) and Percona Server for MySQL
Aurora vs Percona: Aurora comes well integrated with the AWS ecosystem. So, easier to integrate into the overall infrastructure if you are already on AWS.
- Primary datastore for entities requiring relational semantics and ACID properties.
- Automated back-ups, and point in time recovery capabilities.
- Ability to auto-scale the readers (slaves) as the read query load increases.
- We are also evaluating serverless Aurora to handle the bursty traffic.
- Completely automating the provisioning of Aurora behind Terraform. We don't access the AWS console at all.
- Differential back-ups and master-slave redundancies depending on criticality of the service and keeping costs in control.
- Effective utilisation of the Key Management Service for encryption and decryption.
- Use more Aurora instances as a part of our Data Lake strategy, and couple it with S3, and Redshift.
- Evaluate the machine learning use-cases along with AWS Sagemaker and Comprehend as they have native integration with Aurora.
- Aurora has helped us scale our data workloads by 10X in the last 3 years without the need to increase the DBAs.
- It provides reliable performance and uptime guarantees. We have instances varying from 2 cores, 8GB RAM to 32 cores, 256 GB RAM with heavily predicatable workload.
- Manageable costs - the ROI on performance and costs is great!
- Online training