AWS Series — Why is Amazon Aurora so popular?
Amazon Aurora is a MySQL and PostgreSQL compatible relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases.
5X Performance
Amazon Aurora provides up to 5 times better performance than MySQL and 3 times better than PostgreSQL databases at a much lower price point, while delivering similar performance and availability.
Amazon has developed this database proprietary technology but it is completely compatible with MySQL and PostgreSQL.
- It starts with 10 GB. Scales in 10-GB increments to 128 TB ( storage Auto Scaling).
- Compute resources can scale up to 96 vCPUs and 768 GB of memory
- 2 copies of your data are contained in each Availability Zone, with a minimum of 3 Availability Zones. 6 copies of your data.
Scaling Aurora
- Aurora is designed to transparently handle the loss of up to 2 copies of data without affecting database write availability and up to 3 copies without affecting read availability.
- Aurora storage is also self-healing. Data blocks and disks are continuously scanned for errors and repaired automatically.
3 Aurora Replicas Available
- Aurora Replicas — You can currently have 15 read replicas with Aurora.
- MySQL Replicas — You can currently have 5 read replicas with Aurora MySQL.
- PostgreSQL — You can currently have 15 read replicas with Aurora PostgreSQL
Backups with Aurora
- Automated backups are always enabled on Amazon Aurora DB Instances. Backups do not impact database performance.
- You can also take snapshots with Aurora. This also does not impact on performance
- You can share Aurora snapshots with other AWS accounts.
Amazon Aurora Serverless
An on-demand, auto-scaling configuration for the MySQL-compatible and PostgreSQL-compatible editions of Amazon Aurora. An Aurora Serverless DB cluster automatically starts up, shuts down, and scales capacity up or down based on your application’s needs
Use Cases for Aurora Serverless —
Aurora Serverless provides a relatively simple, cost-effective option for infrequent, intermittent or unpredictable workloads.
Points to Remember —
- 2 copies of your data are contained in each Availability Zone, with a minimum of 3 Availability Zones. 6 copies of your data
- You can share Aurora snapshots with other AWS accounts
- 3 types of replicas available: Aurora replicas, MySQL replicas, and PostgreSQL replicas. Automated failover is only available with Aurora replicas
- Aurora has automated backups turned on by default. You can also take snapshots with Aurora. You can share these snapshots with other AWS accounts.
