Aurora Flashcards by Justin Moser

copy-on-write protocol (2)

Aurora DB cloning

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

Aurora DB cloning

How well did you know this?

Not at all

Perfectly

benefit vs snapshot to restore (2)

Aurora DB cloning

faster
costs less

Aurora DB cloning

How well did you know this?

Not at all

Perfectly

use case

Aurora DB cloning

clone production cluster to development cluster

Aurora DB cloning

How well did you know this?

Not at all

Perfectly

Aurora DB cloning

Aurora BU

craete new DB cluster from exsiting one

Aurora BU

How well did you know this?

Not at all

Perfectly

manual snapshots

Aurora BU

no retention time limit

Aurora BU

How well did you know this?

Not at all

Perfectly

retention time in days options

Aurora BU

1 to 35 days

Aurora BU

How well did you know this?

Not at all

Perfectly

Aurora BU option

Aurora BU

cannot be disabled

Aurora BU

How well did you know this?

Not at all

Perfectly

use cases (4)

Aurora ML

fraud detection
ads targeting
sentiment analysis
product recommendations

Aurora ML

How well did you know this?

Not at all

Perfectly

useable ML services (2)

Aurora ML

SageMaker
Comprehend

Aurora ML

How well did you know this?

Not at all

Perfectly

Aurora ML

Aurora

ML-based predictions in DB queries

Aurora

How well did you know this?

Not at all

Perfectly

recovery time after a DR event

global Aurora

promoting a region to primary takes <60s

global Aurora

How well did you know this?

Not at all

Perfectly

latency benefit

global Aurora

cross-region replication is <1s

global Aurora

How well did you know this?

Not at all

Perfectly

number of read replicas per region

global Aurora

up to 16 read replicas

global Aurora

How well did you know this?

Not at all

Perfectly

secondary regions

global Aurora

up to 5 regions with read replicas

global Aurora

How well did you know this?

Not at all

Perfectly

primary region

global Aurora

1 region with R/W access

global Aurora

How well did you know this?

Not at all

Perfectly

global Aurora

Aurora

spread replicas across regions

Aurora

pay method

Aurora serverless

pay per second

Aurora serverless

use case

Aurora serverless

infrequent, intermittent, or unpredictable workloads

Aurora serverless

benefit

Aurora serverless

no capacity planning needed

Aurora serverless

Aurora

automates DB instantiation and auto-scaling

Aurora

use case

Aurora custom endpoints

split traffic from expensive, analytic application and general application

Aurora custom endpoints

Custom Endpoints

Aurora

split traffic to specific subsets of replicas

Aurora

backtrack

Aurora

restore data and any point in time without restoring from backup

Aurora

fully managed features (5/9)

Aurora

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

Aurora

reader endpoint | Aurora connectivity

DNS entry that points to load balanced read replicas | Aurora connectivity

writer endpoint | Aurora connectivity

DNS entry that always points to current master | Aurora connectivity

how writes are handled | Aurora connectivity

one master writes to storage | Aurora connectivity

cost comparison | Aurora

cost more than RDS but performs better | Aurora

how storage performance is achieved | Aurora scalability and reliability

storage is striped across 100s of volumes | Aurora scalability and reliability

replication reliability | Aurora scalability and reliability

self healing peer-to-peer replication | Aurora scalability and reliability

storage availability | Aurora scalability and reliability

6 copies of data across 3 AZ | Aurora scalability and reliability

regional feature | Aurora scalability and reliability

supports cross region replication | Aurora scalability and reliability

failover feature | Aurora scalability and reliability

instatantaneous failover | Aurora scalability and reliability

benefit vs RDS | Aurora scalability and reliability

faster replication than RDS | Aurora scalability and reliability

max number of read replicas | Aurora scalability and reliability

up to 15 in multi-AZ configuration | Aurora scalability and reliability

storage scalability | Aurora scalability and reliability

automatically scales, up to 128TB | Aurora scalability and reliability

"cloud optimized" | Aurora

performs better than MySQL or Postgress on RDS | Aurora

compatible with DB drivers (2) | Aurora

* MySQL * Postgres | Aurora

Aurora

Proprietary DB technology by AWS