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.
Will a failover priority of tier 10 beat a failover priority of tier 0?
No. The lower the number, the higher the failover priority.
How is failover priority determined among read replicas?
Tiers. The lower the number, the higher the priority.
What is the maximum priority tier?
0 (remember, the lower the number, the higher the priority).
What is the minimum priority tier?
15
Are cross-region replicas possible?
Yes
True or False: if you set up a cross-region replica, Aurora will create a whole new Aurora cluster?
True.
True or False: For cross-region replication, it is recommended to enable multi-AZ to ensure high availability on the target cluster?
True
