Aurora Flashcards

1
Q

Aurora

A

Proprietary DB technology by AWS

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

compatible with DB drivers (2)

Aurora

A
  • MySQL
  • Postgres

Aurora

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

“cloud optimized”

Aurora

A

performs better than MySQL or Postgress on RDS

Aurora

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

storage scalability

Aurora scalability and reliability

A

automatically scales, up to 128TB

Aurora scalability and reliability

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

read replicas

Aurora scalability and reliability

A

up to 15 in multi-AZ configuration

Aurora scalability and reliability

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

replication feature

Aurora scalability and reliability

A

faster replication than RDS

Aurora scalability and reliability

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

failover feature

Aurora scalability and reliability

A

instatantaneous failover

Aurora scalability and reliability

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

regional feature

Aurora scalability and reliability

A

supports cross region replication

Aurora scalability and reliability

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

storage availability

Aurora scalability and reliability

A

6 copies of data across 3 AZ

Aurora scalability and reliability

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

replication reliability

Aurora scalability and reliability

A

self healing peer-to-peer replication

Aurora scalability and reliability

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

storage performance

Aurora scalability and reliability

A

storage is striped across 100s of volumes

Aurora scalability and reliability

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

cost comparison

Aurora

A

cost more than RDS but performs better

Aurora

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

client connectivity

Aurora connectivity

A

one master writes to storage

Aurora connectivity

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

writer endpoint

Aurora connectivity

A

DNS entry that always points to current master

Aurora connectivity

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

reader endpoint

Aurora connectivity

A

DNS entry that points to load balanced read replicas

Aurora connectivity

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

fully managed features (5/9)

Aurora

A
  • automatic fail-over
  • backup and recovery
  • isolation and security
  • industry compliance
  • auto scaling
  • 0 downtime, managed patching
  • advanced monitoring
  • managed maintenance
  • backtrack

Aurora

17
Q

backtrack

Aurora

A

restore data and any point in time without restoring from backup

Aurora

18
Q

Custom Endpoints

Aurora

A

split traffic to specific subsets of replicas

Aurora

19
Q

use case

Aurora custom endpoints

A

split traffic from expensive, analytic application and general application

Aurora custom endpoints

20
Q

Aurora serverless

Aurora

A

automates DB instantiation and auto-scaling

Aurora

21
Q

benefit

Aurora serverless

A

no capacity planning needed

Aurora serverless

22
Q

use case

Aurora serverless

A

infrequent, intermittent, or unpredictable workloads

Aurora serverless

23
Q

pay method

Aurora serverless

A

pay per second

Aurora serverless

24
Q

global Aurora

Aurora

A

spread replicas across regions

Aurora

25
Q

primary region

global Aurora

A

1 region with R/W access

global Aurora

26
Q

secondary regions

global Aurora

A

up to 5 regions with read replicas

global Aurora

27
Q

number of read replicas per region

global Aurora

A

up to 16 read replicas

global Aurora

28
Q

latency benefit

global Aurora

A

cross-region replicaion is <1s

global Aurora

29
Q

DR

global Aurora

A

promoting a region to primary takes <60s

global Aurora

30
Q

Aurora ML

Aurora

A

ML-based predictions in DB queries

Aurora

31
Q

useable ML services (2)

Aurora ML

A
  • SageMaker
  • Comprehend

Aurora ML

32
Q

use cases (4)

Aurora ML

A
  • fraud detection
  • ads targeting
  • sentiment analysis
  • product recommendations

Aurora ML

33
Q

Aurora BU option

Aurora BU

A

cannot be disabled

Aurora BU

34
Q

retention options

Aurora BU

A

1 to 35 days

Aurora BU

35
Q

manual snapshots

Aurora BU

A

no retention time limit

Aurora BU

36
Q

Aurora DB cloning

Aurora BU

A

craete new DB cluster from exsiting one

Aurora BU

37
Q

use case

Aurora DB cloning

A

clone production cluster to development cluster

Aurora DB cloning

38
Q

benefit vs snapshot to restore (2)

Aurora DB cloning

A
  • faster
  • costs less

Aurora DB cloning

39
Q

copy-on-write protocol

Aurora DB cloning

A
  • Initial “copy” uses same data volume
  • When updates are made, storage is allocated and data is copied and separated

Aurora DB cloning