Aurora 101 Flashcards
What is Aurora
Amazon’s relational database engine that combines the speed and availability of high-end commercial DBs with the simplicity and cost-effectiveness of open source DBs.
With which DB engines is Aurora compatible?
MySQL/PostgreSQL
How many times faster is Aurora than MySQL?
5x
How many times faster is Aurora than PostgreSQL?
3x
What price ratio is Aurora compared to commercial DBs?
1/10
How does Aurora HA work?
Aurora stores 6 copies of your DB across 3 availability zones. 2 copies per AZ
How does Aurora storage autoscaling work?
Starts with 10GBs, increments by 10GB
What is the maximum storage capacity of Aurora?
64TB
Aurora’s maximum vCPU
64vCPUs
Aurora’s maximum memory
488GiB
How many copies of data can be lost before affecting write availability?
two copies
In Aurora, how many copies of data can be lost before affecting read availability?
three copies
Using AWS Aurora, how do you fix errors?
AWS continuously scans data blocks and disks for errors and automatically repairs when needed.
What is the maximum number of read-replicas you can have with AWS Aurora?
15
In Aurora, when writes are causing high CPU utilization, what is the fix?
Scale up (increase the instance size)
In Aurora, when reads are causing high CPU utilization, what is the fix?
Scale out (Increase the number of replicas)
What is Aurora Serverless?
on-demand, auto-scaling, pay per second Aurora configuration.
What are the two capacity types of Aurora?
Provisioned
Serverless
In Aurora, when you use encyption at rest, are read replicas encrypted by default?
Yes
What is the difference between backtrack and a backup?
Backtrack allows you to roll back your DB to a point in time. Backup is restoring the entire DB to the last snapshot.
What is the maximum time backtrack supports?
72 hours
True or False In backtrack, if you select 72 hours as your backtrack window, your restores will be 72 hours in the past?
False. You can restore up to any point in time up to 72 hours. 1hr, 5hrs, 10hrs, etc; up to 72hrs.
An Aurora DB comes with two end points. A write endpoint, and a read endpoint, true or false?
True.
If your primary DB is encrypted, can a new read replica be unencrypted?
No.