Amazon Aurora vs MySQL
Amazon Aurora is a fully managed AWS database engine compatible with MySQL and PostgreSQL: AWS handles provisioning, patching, backup and failure detection, storage grows automatically to 256 TiB per cluster volume, and it is designed for up to 99.99% single-Region availability. MySQL is the open source database developed by Oracle under the GPL, free to download and run on any machine or cloud, with a commercial license available. Choose Aurora for a managed database on AWS; choose MySQL to run it yourself anywhere.
Amazon Aurora is a fully managed AWS database engine compatible with MySQL and PostgreSQL: AWS handles provisioning, patching, backup and failure detection, storage grows automatically to 256 TiB per cluster volume, and it is designed for up to 99.99% single-Region availability. MySQL is the open source database developed by Oracle under the GPL, free to download and run on any machine or cloud, with a commercial license available. Choose Aurora for a managed database on AWS; choose MySQL to run it yourself anywhere.
Deciding factor: Aurora for a managed MySQL-compatible database on AWS; MySQL to self-host anywhere under the GPL.
Key fact: Aurora storage grows to 256 TiB per cluster volume; MySQL is open source under the GPL.
Amazon Aurora: managed on AWS, MySQL- and PostgreSQL-compatible, storage to 256 TiB. MySQL: open source under the GPL, runs anywhere, you manage it. Compare AWS costs with self-hosting for your workload.
Choose Amazon Aurora if
Teams on AWS that want a managed MySQL- or PostgreSQL-compatible database
Choose MySQL if
Teams that want to run their own database on any infrastructure
Share this verdict
Get notified when Amazon Aurora vs MySQL changes
One email when prices, specs or our verdict on Amazon Aurora vs MySQL change. No spam, unsubscribe anytime.
Key Differences at a Glance
- Type:Managed AWS service vs Open source software
- Compatibility:MySQL and PostgreSQL vs MySQL
- License:AWS service terms vs GPL, or commercial license
Compare next
MySQL vs PostgreSQL
Key Differences
4 attributes compared head-to-head
- Managed AWS serviceTypeOpen source software
- MySQL and PostgreSQLCompatibilityMySQL
- AWS service termsLicenseGPL, or commercial license
- AWS onlyWhere it runsAnywhere
- Type
Amazon Aurora
Managed AWS service
MySQL
Open source software
- Compatibility
Amazon Aurora
MySQL and PostgreSQL
MySQL
MySQL
- License
Amazon Aurora
AWS service terms
MySQL
GPL, or commercial license
- Where it runs
Amazon Aurora
AWS only
MySQL
Anywhere
Full Comparison
| Attribute | Amazon Aurora | |
|---|---|---|
| Developer | Amazon Web Services | Oracle Corporation |
| Storage | Auto-grows to 256 TiB per cluster volume | Depends on your hardware |
| Availability design | Up to 99.99% single-Region, 99.999% multi-Region | Depends on your setup |
| Operations | AWS handles patching, backup, failure detection | You or your host handle them |
| Cost model | Pay for AWS usage | Free under GPL; commercial license optional |
Pros & Cons
6 pros·4 cons across both
Amazon Aurora
Pros
Cons
MySQL
Pros
Cons
Frequently Asked Questions
6 questions
No. Aurora is a separate AWS database engine that is compatible with MySQL and PostgreSQL, so MySQL code, tools and apps work with it.
Yes. MySQL is open source under the GPL and can be downloaded and used without paying. Oracle sells a commercial license for cases such as embedding MySQL in commercial applications.
An Aurora cluster volume grows automatically up to 256 tebibytes (TiB).
Yes. You can migrate MySQL databases to and from Aurora with standard tools, and bring RDS for MySQL data in through snapshots or replication.
No. Aurora is an AWS service. MySQL can run on your own hardware or any cloud.
For Aurora, AWS handles provisioning, patching, backup, recovery and failure detection; you handle query tuning. For self-run MySQL, you manage them.
Analysis: Amazon Aurora vs MySQL
Amazon Aurora is a fully managed AWS database engine compatible with MySQL and PostgreSQL: AWS handles provisioning, patching, backup and failure detection, storage grows automatically to 256 TiB per cluster volume, and it is designed for up to 99.99% single-Region availability. MySQL is the open source database developed by Oracle under the GPL, free to download and run on any machine or cloud, with a commercial license available. Choose Aurora for a managed database on AWS; choose MySQL to run it yourself anywhere.
Key takeaways
- Aurora is a managed AWS service; MySQL is software you install and run. - Aurora is compatible with MySQL and PostgreSQL; existing code, tools and apps work with it. - Aurora storage grows automatically, up to 256 TiB per cluster volume. - Aurora is designed for up to 99.99% single-Region and 99.999% multi-Region availability. - MySQL is open source under the GPL, with a commercial license from Oracle.
Read 8 more paragraphsShow less
Management
Aurora is part of Amazon RDS. AWS handles provisioning, patching, backup, recovery, failure detection and repair, and automates clustering and replication. You remain responsible for query tuning. With MySQL you install the server and manage scaling, backups and replication yourself, or use a managed service.
Compatibility and migration
You choose Aurora MySQL or Aurora PostgreSQL when you create a cluster. Data from RDS for MySQL can move into Aurora through snapshots or replication, and standard tools migrate MySQL databases to and from Aurora.
Licensing and where it runs
1. MySQL can be downloaded and used without paying, under the GPL; a commercial license is available for embedding in commercial apps. 2. Aurora runs only on AWS and is billed per instance and storage. 3. MySQL runs on a desktop, a server, a cluster or any cloud.
Who should pick which
Pick Aurora if you are on AWS and want a managed, highly available MySQL-compatible database. Pick MySQL if you want to run the database yourself, on any infrastructure, at no license cost. MySQL vs PostgreSQL covers the engine choice.
Resources & Learn More
Curated sources to dive deeper
Wikipedia
External Resources
AWS: Amazon Aurora (opens in new tab)
Compatible with PostgreSQL and MySQL; designed for 99.99% single-Region and 99.999% multi-Region availability.
AWS: What is Amazon Aurora? (opens in new tab)
Managed engine; storage to 256 TiB; part of Amazon RDS; shared responsibility model.
MySQL 8.4 Reference Manual: What is MySQL? (opens in new tab)
Open source under the GPL; developed by Oracle; commercial license available.
Was this verdict helpful?
Explore More
Related comparisons and categories
Explore Entities
More Software
People Also Compare
Debate this on r/ThisOrThatDebate (run by the AversusB team)