Skip to main content

Amazon Aurora vs MySQL

A Versus B

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

Fully managed AWS relational database compatible with MySQL and PostgreSQL.

Teams on AWS that want a managed MySQL- or PostgreSQL-compatible database

Score60%
VS
MySQL

MySQL

Open source relational database developed by Oracle, licensed under the GPL.

Teams that want to run their own database on any infrastructure

Score60%
5 attributes4 differences10 pros/cons
TL;DRVoice-ready

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.

Our Verdict

AI-assisted

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.

A

Choose Amazon Aurora if

Teams on AWS that want a managed MySQL- or PostgreSQL-compatible database

MySQL

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
See all 4 differences

Key Differences

4 attributes compared head-to-head

AA
0Amazon Aurora
Evenly matched4 ties
MySQL
0MySQL
  • 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

AAmazon Aurora
MySQL
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

AA
MySQL
AA

Amazon Aurora

+3-2

Pros

Compatible with MySQL and PostgreSQL code, tools and apps
Storage grows automatically up to 256 TiB per cluster volume
Designed for up to 99.99% single-Region and 99.999% multi-Region availability

Cons

Runs only on AWS
You pay for instances, storage and I/O on AWS
MySQL

MySQL

+3-2

Pros

Free to download and use under the GPL
Runs anywhere: laptop, server or any cloud
Commercial license available from Oracle

Cons

You manage installation, scaling, backups and failover yourself
Embedding in commercial apps may need a commercial license

Frequently Asked Questions

6 questions

  1. No. Aurora is a separate AWS database engine that is compatible with MySQL and PostgreSQL, so MySQL code, tools and apps work with it.

  2. 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.

  3. An Aurora cluster volume grows automatically up to 256 tebibytes (TiB).

  4. Yes. You can migrate MySQL databases to and from Aurora with standard tools, and bring RDS for MySQL data in through snapshots or replication.

  5. No. Aurora is an AWS service. MySQL can run on your own hardware or any cloud.

  1. 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 paragraphs

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.

Drafted with AI from web research. How we research
Community feedback

Was this verdict helpful?

Explore More

Related comparisons and categories

Last updated

Debate this on r/ThisOrThatDebate (run by the AversusB team)