AWS Aurora Flashcards

1
Q

What is Amazon Aurora?

A

MySQL compatible Relational Database engine

5x performance of MySQL
10% cost of commercial database

combines speed, availability of high-end databases with simplicity and value of open source databases

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

Initial size of Aurora DB and increments of size increases

A

10Gb to start

Scales in 10Gb increments

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

Max CPU and RAM compute resources

A

32 vCPUs

244Gb RAM

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

How many redundant copies of data does Aurora store and where?

A

2 copies of data in each AZ
minimum of 3 AZ’s

So 6 copies of your data

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

How many copies of data can Aurora lose without affecting write availability?

A

2

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

How many copies of data can Aurora lose without affecting read availability?

A

3

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

Is Aurora storage self-healing?

A

Yes.

Constantly scans drives for errors and repairs them

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

Aurora replica, first type

A

Called Aurora Replicas

Up to 15 separate copies of data

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

Aurora replica, second type

A

MySQL Read Replica

up to 5

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

Difference between Aurora and MySQL replicas

A

Failover.

With Aurora replica failover happens automatically, not with MySQL read replicas

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