Aurora 101 Flashcards

1
Q

What is Aurora

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

With which DB engines is Aurora compatible?

A

MySQL/PostgreSQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How many times faster is Aurora than MySQL?

A

5x

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How many times faster is Aurora than PostgreSQL?

A

3x

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What price ratio is Aurora compared to commercial DBs?

A

1/10

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How does Aurora HA work?

A

Aurora stores 6 copies of your DB across 3 availability zones. 2 copies per AZ

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How does Aurora storage autoscaling work?

A

Starts with 10GBs, increments by 10GB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the maximum storage capacity of Aurora?

A

64TB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Aurora’s maximum vCPU

A

64vCPUs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Aurora’s maximum memory

A

488GiB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

How many copies of data can be lost before affecting write availability?

A

two copies

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

In Aurora, how many copies of data can be lost before affecting read availability?

A

three copies

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Using AWS Aurora, how do you fix errors?

A

AWS continuously scans data blocks and disks for errors and automatically repairs when needed.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is the maximum number of read-replicas you can have with AWS Aurora?

A

15

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

In Aurora, when writes are causing high CPU utilization, what is the fix?

A

Scale up (increase the instance size)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

In Aurora, when reads are causing high CPU utilization, what is the fix?

A

Scale out (Increase the number of replicas)

17
Q

What is Aurora Serverless?

A

on-demand, auto-scaling, pay per second Aurora configuration.

18
Q

What are the two capacity types of Aurora?

A

Provisioned

Serverless

19
Q

In Aurora, when you use encyption at rest, are read replicas encrypted by default?

A

Yes

20
Q

What is the difference between backtrack and a backup?

A

Backtrack allows you to roll back your DB to a point in time. Backup is restoring the entire DB to the last snapshot.

21
Q

What is the maximum time backtrack supports?

A

72 hours

22
Q

True or False In backtrack, if you select 72 hours as your backtrack window, your restores will be 72 hours in the past?

A

False. You can restore up to any point in time up to 72 hours. 1hr, 5hrs, 10hrs, etc; up to 72hrs.

23
Q

An Aurora DB comes with two end points. A write endpoint, and a read endpoint, true or false?

A

True.

24
Q

If your primary DB is encrypted, can a new read replica be unencrypted?

A

No.

25
Q

Will a failover priority of tier 10 beat a failover priority of tier 0?

A

No. The lower the number, the higher the failover priority.

26
Q

How is failover priority determined among read replicas?

A

Tiers. The lower the number, the higher the priority.

27
Q

What is the maximum priority tier?

A

0 (remember, the lower the number, the higher the priority).

28
Q

What is the minimum priority tier?

A

15

29
Q

Are cross-region replicas possible?

A

Yes

30
Q

True or False: if you set up a cross-region replica, Aurora will create a whole new Aurora cluster?

A

True.

31
Q

True or False: For cross-region replication, it is recommended to enable multi-AZ to ensure high availability on the target cluster?

A

True