07 - Aurora Provisioned

Question 1

Aurora Provisioned is very different from RDS

Answer 1

• Aurora is based on cluster architecture

Question 2

Single primary instance + 0 or more replicas

Answer 2

• All replica can be used for read ops
• Replica can be used as failover options

Question 3

Storage

Answer 3

• Aurora uses a shared cluster volume
• 65TB maximum sizes.
• Cluster disk is based on SSD only, high IOPS, low latency
• Storage is based on what you consume

Question 4

Costs

Answer 4

• Aurora there is NO free tier.
• Beyond a micro-size instance Aurora is cheaper
• Billed on storage consumption.
  
  • Storage GB-Month consumed.
  • Billed on the high water mark
• Billed on Compute hourly
  
  • charge per sec 10 min
• Billed on IO cost
  
  • per request
• 100% DB size in backups included

Question 5

Replication

Answer 5

• 6 replicas synchronously replicated
• Replication happens at storage layer
• Aurora repairs any failures of disk
• No need to do point in time or snapshots to recover from disk failure
• Up to 15 replicas

Question 6

DNS

Answer 6

• DNS addresses used cluster endpoint and the reader endpoint
• Reader endpoint will load balance across the replicas
• Can create customer endpoints for specific DB

Question 7

Backups

Answer 7

• Backups work the same way as RDS
• Restores create a brand new cluster

Question 8

Recovery

Answer 8

• Backtrace can be enable to roll back DB to a previous point in time in place
• Fast clone allow you to create a brand new DB faster than copying all the data. COPY ON WRITE