Databases - Aurora

Question 1

What is Aurora?

Answer 1

MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases

Question 2

Performance, Price: Aurora vs MySQL

Answer 2

Aurora: 5x better, 1/10 cheaper

Question 3

Aurora scaling

Answer 3

start with 10 GB, scales in 10 GB increments to 64 Tb

Question 4

Compute resources scaling

Answer 4

up to 32 vCPUs and 244 Gb memory

Question 5

How many copies of Aurora data?

Answer 5

2 per AZ, minimum of 3 AZs, so minimum of 6

Question 6

How many copies can be lost w/o affecting availability?

Answer 6

2 - write, 3 - read

Question 7

Aurora is self-healing, what is meant by that?

Answer 7

data blocks and disks are continuously scanned for errors and repaired automatically

Question 8

2 Aurora replicas

Answer 8

Aurora replicas (15), MySQL Read replicas (5)

Question 9

Aurora Replica vs MySQL read replica

Answer 9

Former has failover, latter doesn’t

Question 10

Failover logic

Answer 10

tier 0 is highest