Aurora Flashcards
copy-on-write protocol
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
benefit vs snapshot to restore (2)
Aurora DB cloning
- faster
- costs less
Aurora DB cloning
use case
Aurora DB cloning
clone production cluster to development cluster
Aurora DB cloning
Aurora DB cloning
Aurora BU
craete new DB cluster from exsiting one
Aurora BU
manual snapshots
Aurora BU
no retention time limit
Aurora BU
retention options
Aurora BU
1 to 35 days
Aurora BU
Aurora BU option
Aurora BU
cannot be disabled
Aurora BU
use cases (4)
Aurora ML
- fraud detection
- ads targeting
- sentiment analysis
- product recommendations
Aurora ML
useable ML services (2)
Aurora ML
- SageMaker
- Comprehend
Aurora ML
Aurora ML
Aurora
ML-based predictions in DB queries
Aurora
DR
global Aurora
promoting a region to primary takes <60s
global Aurora
latency benefit
global Aurora
cross-region replicaion is <1s
global Aurora
number of read replicas per region
global Aurora
up to 16 read replicas
global Aurora
secondary regions
global Aurora
up to 5 regions with read replicas
global Aurora
primary region
global Aurora
1 region with R/W access
global Aurora
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 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
client connectivity
Aurora connectivity
one master writes to storage
Aurora connectivity
cost comparison
Aurora
cost more than RDS but performs better
Aurora
storage performance
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
replication feature
Aurora scalability and reliability
faster replication than RDS
Aurora scalability and reliability
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