Aurora Flashcards
What is Amazon Aurora?
Amazon Aurora is a MySQL- and PostgreSQL-Compatible RDB engine that combines the speed and availability of high-end commercial databases with the simplicity of cost-effectiveness of open-source databases.
What is the estimated performance speedup of Amazon Aurora when compared to competitors?
- 5x better performance than MySQL
- 3x better performance than PostgreSQL
- (and at a much lower price point with similar performance and availability)
How does Amazon Aurora decide how much storage to give you?
Storage Autoscaling
- Start with 10GB
- scales in 10GB increments to 64TB
What are the maximum compute resources that Amazon Aurora can scale to?
- 32 vCPUs
- 244 GB of memory
How does Amazon Aurora assure data redundancy?
Aurora keeps 6 copies of your data, 2 in each AZ, in a minimum of 3 AZs
How many copies of your data can Amazon Aurora transparently handle being lost without affecting write availability?
Aurora is designed to transparently handle the loss of up to 2 copies of data without affecting database write availability.
How many copies of your data can Amazon Aurora transparently handle losing without affecting read availability?
Amazon Aurora is designed to transparenly handle the loss of up to 3 copies of your data without affecting database read availability.
What does it mean that Amazon Aurora is self-healing?
Data blocks and disks are continuously scanned for errors and repaired automatically.
What are the types of Aurora replicas available, and how many of each are currently available per Aurora DB?
- Aurora Replicas (15)
- MySQL Read Replicas (5)
- PostgreSQL (1)
Do Aurora Replicas provide automated failover?
Yes
Do MySQL Replicas provide automated failover?
No
Are automated backups enabled by default on Amazon Aurora DB Instances?
Yes
How do you disable automated backups on an Aurora DB instance?
You can’t. Automated backups are always enabled on Aurora DB Instances.
Can you take snapshots with Aurora?
Yes.
Do Aurora snapshots impact performance?
No