RDS, Aurora & ElastiCache Flashcards
managed DB service for DB using SQL as a query language. Allows you to create databases in the cloud that are managed by AWS
Relational Database Service (RDS)
Using continuous backups to restore DB to a specific timestamp
Point in Time Restore
Used by RDS for improved read performance. Up to 15 Within AZ, Cross AZ or Cross Region
Read Replicas
Increase storage on your RDS DB instance dynamically, useful for applications with unpredictable workloads
RDS Storage Auto Scaling
Type of replication done on read replicas
Asynchronous
Only SQL statements allowed on read replicas
SELECT (read)
Type of replication done in RDS Multi AZ
Synchronous
Used for failover in case of loss of AZ, loss of
network, instance or storage failure
RDS Multi AZ
Can you access the underlying DB within RDS?
No
Does the RDS DB need to be stopped in order to migrate from a single AZ to Multi-AZ?
No
Managed Oracle and Microsoft SQL Server Database with OS and
database customization
RDS Custom
With RDS Custom can you access the underlying EC2 Instance?
Yes, using SSH or Session Manager
Highly Available “AWS cloud optimized” DB and claims 5x performance improvement over MySQL on RDS, over 3x the performance of Postgres on RDS
Aurora
Are Postgres and MySQL both supported as Aurora DB?
Yes
Amount of replicas Aurora can have
15
Does Aurora support Cross Region Replication?
Yes
mechanism to abstract connections within Aurora for load-balancing and rerouting connections when some DB instances aren’t available
Endpoints
provides load-balancing support for read-only connections to the DB cluster
Reader endpoint
Feature of Aurora where every node has read/write capabilities
Aurora Multi-Master
Automated database instantiation and auto-scaling based on actual usage
Aurora Serverless
add ML-based predictions to your applications via SQL for fraud detection, ads targeting, sentiment analysis, product recommendations
Aurora Machine Learning
Aurora Machine Learning supported services
Sagemaker and Comprehend
Useful to create a “staging” database from a “production” database without impacting the production database.
Aurora Database Cloning
Aurora and REDS use this for at-rest encryption
KMS
Control Network access to your RDS / Aurora DB
Security Groups
In-flight encryption of RDS & Aurora
TLS
Allows apps to pool and share DB connections established with the database reducing the stress on database resources
Amazon RDS Proxy
Used for managed Redis or Memcached
ElastiCache
In-memory databases with really high performance, low latency
Cache
Helps makes in-memory DB stateless and reduce load off of databases for read-intensive workloads
ElastiCache
Multi-node for partitioning of data (sharding) in in-memory DB
Elasticache for Memcached
Multi AZ with Auto-Failover along with Read Replicas to scale reads and
have high availability
Elasticache for Redis
