Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Arch > Aurora > Flashcards

Aurora Flashcards

1
Q

Aurora is

A

a proprietary technology from AWS, not open sourced

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

Support for other DBs

A

PostGres and MySQL

your drivers will work as if Aurora was a PostGres or MySQL database

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

Performance

A

AWS cloud optimized

5x improvement over MySQL in RDS

3x improvement over PostGres in RDS

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

Storaged

A

grows automatically in increments of 10 GB

up to 64 TB

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

Replicas

A

can have up to 15 replicas (only 5 for MySQL)

replication process is faster

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

Failover

A

is instantaneous, it’s High Availability native

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

costs

A

20% more than RDS but more efficient

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

High Availability storage

A

stores 6 copies of your data across 3 AZ automatically

Storage is striped across 100s of volumes

self healing with peer-to-peer replication if data gets corrupted

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

High Availability reads and writes

A

one Aurora instance takes writes - the master, others are replicas. Failover in less than 30 sec on average

cross region replication

Master + 1-15 Aurora Read Replicas serve reads. Autoscaling is supported

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

Aurora DB cluster writing

A

master is the only who will write into storage

Since master can failover and change, Aurora provides you with Writer (Cluster) Endpoint - DNS name always pointing to the master (primary instance). Client always talks to the Writer Endpoint and is automatically redirected to the right instance

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

Aurora DB cluster reading

A

Reader Endpoint helps with connection load balancing and connects automatically to all the Read Replicas

Any time client connects to RE, it gets connected to one of the Read Replicas = Load Balancing

Load Balancing happens at the connection level, not the statement level

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

Aurora cool features

A
  1. automatic fail-over
  2. backup and recovery
  3. isolation and security
  4. industry compliance
  5. push-button scaling
  6. automated patching with zero downtime
  7. advanced monitoring
  8. routine maintenance
  9. Backtrack: restore data at any point of time without using backups
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Aurora Security

A

very similar to RDS

  1. ecryption at rest using KMS
  2. automated backups, snapshots and replicas are encrypted
  3. encryption in-flight using SSL
  4. possibility to authenticate using IAM token
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Aurora Security your responsibility

A

protect the instance with security groups

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

Aurora Security

A

you can’t SSH

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

Aurora Serverless use case

A

your database usage might be heavy for a short period of time, followed by long periods of light activity or no activity at all.

Some examples are retail websites with intermittent sales events, databases that produce reports when needed, development and testing environments, and new applications with uncertain requirements.

17
Q

Aurora Serverless why

A

configuring capacity correctly in advance isn’t always possible with the provisioned model. It can also result in higher costs if you overprovision and have capacity that you don’t use.

18
Q

Aurora Serverless how

A

you can create a database endpoint without specifying the DB instance class size.

You specify only the minimum and maximum range for the Aurora Serverless v1 DB cluster’s capacity. The Aurora Serverless v1 database endpoint makes up a router fleet that supports continuous connections and distributes the workload among resources.

Autoscaling based on actual usage

19
Q

Aurora Serverless what kind of workloads

A

infrequent, intermittent, unpredictable

no capacity planning needed

20
Q

Aurora Serverless costs

A

pay per second, can be more cost-effective

21
Q

Global Aurora

A

Two ways

  1. Aurora Cross Region Read Replicas
  2. Aurora Global Database (recommended)
22
Q

Aurora Cross Region Read Replicas

A

useful for disaster recovery, simple to put in place - you just create a Read replica in another region

23
Q

Aurora Global Database

A

you have one primary region where reads and writes occur

and up to 5 secondary read-only regions with replication lag less than a second

and up to 16 Read Replicas per secondary region

helps decreasing latency

24
Q

Aurora Global Database - if you want to promote another region for disaster recovery

A

you have Recovery Time Objective of less than a minute

so in less than a minute your secondary region becomes primary and is prepared to take on writes

Arch (29 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions