AWS Aurora for MySQL is a relational database service that is compatible with MySQL and offers higher performance, availability, scalability, and security than standard MySQL.
Features
- It supports up to 5X the throughput of MySQL and 3X the throughput of PostgreSQL on similar hardware, using various software and hardware techniques to optimize the database engine.
- It provides high availability and durability with the Multi-AZ deployment option and Read Replicas for scaling out read-heavy workloads. It also supports cross-region read replicas and global databases for fast local reads and disaster recovery.
- It automatically encrypts data at rest and in transit, and integrates with AWS security services such as IAM, KMS, and CloudTrail. It also supports encryption of data in use with AWS Nitro Enclaves.
- It is fully managed by AWS, which handles routine database tasks such as provisioning, patching, backup, recovery, failure detection, and repair. It also supports serverless configuration, which automatically starts up, shuts down, and scales capacity based on your application's needs.
- It supports migration from MySQL databases using various tools and methods, such as AWS Database Migration Service (AWS DMS), AWS Schema Conversion Tool (AWS SCT), or native MySQL replication.
- It is cost-effective and pay-as-you-go, allowing you to pay only for what you use with no minimum fees. You can also save money by using Reserved Instances or Savings Plans.
- It supports developer productivity with features such as custom database endpoints, parallel query, fast insert, backtracking, clone, performance insights, enhanced monitoring, and Aurora Machine Learning.
Based on the search results, here are some pros and cons of AWS Aurora for MySQL that Reddit users have mentioned:
Pros
- It supports higher throughput, availability, scalability, and security than standard MySQL.
- It is fully managed by AWS, which handles routine database tasks such as provisioning, patching, backup, recovery, failure detection, and repair.
- It supports serverless configuration, which automatically starts up, shuts down, and scales capacity based on your application's needs.
- It supports migration from MySQL databases using various tools and methods, such as AWS Database Migration Service (AWS DMS), AWS Schema Conversion Tool (AWS SCT), or native MySQL replication.
- It supports developer productivity with features such as custom database endpoints, parallel query, fast insert, backtracking, clone, performance insights, enhanced monitoring, and Aurora Machine Learning.
- It supports cross-region read replicas and global databases for fast local reads and disaster recovery.
Cons
- It is more expensive than standard MySQL , especially for storage costs.
- It supports only a subset of the database engines and versions that standard RDS offers. For example, it does not support MySQL 8 features such as atomic DDL migrations, functional indexes, JSON features, window functions, CTE and others.
- It has some limitations compared to standard MySQL, such as less control over the database configuration and maintenance window.
- It may encounter some issues with swap usage or replication lag that require manual failover or troubleshooting.
