Database Backups, Multi-AZ Flashcards

1
Q

What are the two types of database backups?

A

Automated

Database

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

Automated Backup Overview

A

let you recover your database to any point in time within a retention period of 1-35 days.

Take a full daily snapshot and stores transaction logs through the day.

Recovery will choose the most recent daily backup, then apply transaction logs to the point in time you want to recover to

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

Are automated backups enabled by default?

How much storage do you get for free?

A

Yes
you get free space equal to the size of your database

Backups deleted when RDS instance deleted

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

What happens to storage I/O during your backup window (for automated backups)

A

storage i/o may be suspended while data is backed up, causing latency

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

Snapshot backup overview

A

Database snapshots are performed manually

they’re stored even after original RDS instance is deleted (unlike automated backups)

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

When you restore an automatic or manual backup, is the restored version of the database a new RDS instanc with a new endpoint?

A

Yes

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

What databases support encryption at rest?

A
MySQL
SQL Server
Oracle
PostgreSQL
MariaDB
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Are backups, snapshots and read replicas encrypted, once the database is encrypted?

A

yes

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

Can you encrypt an existing DB instance?

A

No

You would have to create a new DB instance with encryption enabled and migrate your data to it

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

What is the purpose of multi-AZ in Amazon RDS?

A

It’s for disaster recovery only

Not for performance

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

What databases does multi-AZ support?

A

SQL, MySQL, Oracle, PostgreSQL, MariaDB

Aurora has its own multi-AZ functionality

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

What’s the purpose of read replicas?

A

Scaling

Performance improvements for read-heavy workloads

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

Can you have read replicas, of read replicas?

A

Yes

But latency increases

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

How many read replica copies of your main database can you have?

A

5

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

What databases support read-replicas?

A

My SQL, PostgreSQL, MariaDB

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

Do you need automatic backups enabled to deploy a read replica?

A

Yes

17
Q

Does each read replica get its own DNS endpoint?

A

Yes

18
Q

Can you have read replicas that are multi-AZ?

A

No

19
Q

Can you have read replicas of a multi-AZ source database?

A

Yes

20
Q

What databases support a read replica in a second region?

A

Only MySQL, MariaDB

21
Q

DynamoDB vs RDS

A

DynamoDB has push-button scaling, you can scale on the fly with no downtime

RDS requires a bigger instance size or adding a read replica