Aurora Flashcards

1
Q

What is Amazon Aurora?

A

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.

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

What is the estimated performance speedup of Amazon Aurora when compared to competitors?

A
  • 5x better performance than MySQL
  • 3x better performance than PostgreSQL
  • (and at a much lower price point with similar performance and availability)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How does Amazon Aurora decide how much storage to give you?

A

Storage Autoscaling

  • Start with 10GB
  • scales in 10GB increments to 64TB
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the maximum compute resources that Amazon Aurora can scale to?

A
  • 32 vCPUs
  • 244 GB of memory
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How does Amazon Aurora assure data redundancy?

A

Aurora keeps 6 copies of your data, 2 in each AZ, in a minimum of 3 AZs

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

How many copies of your data can Amazon Aurora transparently handle being lost without affecting write availability?

A

Aurora is designed to transparently handle the loss of up to 2 copies of data without affecting database write availability.

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

How many copies of your data can Amazon Aurora transparently handle losing without affecting read availability?

A

Amazon Aurora is designed to transparenly handle the loss of up to 3 copies of your data without affecting database read availability.

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

What does it mean that Amazon Aurora is self-healing?

A

Data blocks and disks are continuously scanned for errors and repaired automatically.

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

What are the types of Aurora replicas available, and how many of each are currently available per Aurora DB?

A
  • Aurora Replicas (15)
  • MySQL Read Replicas (5)
  • PostgreSQL (1)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Do Aurora Replicas provide automated failover?

A

Yes

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

Do MySQL Replicas provide automated failover?

A

No

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

Are automated backups enabled by default on Amazon Aurora DB Instances?

A

Yes

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

How do you disable automated backups on an Aurora DB instance?

A

You can’t. Automated backups are always enabled on Aurora DB Instances.

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

Can you take snapshots with Aurora?

A

Yes.

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

Do Aurora snapshots impact performance?

A

No

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

Can you share Aurora snapshots with other AWS accounts?

A

Yes

17
Q

What is Amazon Aurora Serverless?

A

Amazon Aurora Serverless is an on-demand autoscaling configuration for the MySQL-compatible and PostgreSQL-compatible editions of Amazon Aurora.

An Aurora Serverless Database cluster automatically starts up, shuts down, and scales capacity up or down based on your application’s needs.

18
Q

What is the use case for Amazon Aurora Serverless?

A

Amazon Aurora Serverless provides a relatively simple and cost-effective option for infrequent, intermittent, or unpredictable workloads