AWS Fundamentals: RDS + Aurora + Elasticache Flashcards
What does RDS stand for?
Relational Database Service
A managed DB service for DB use SQL as a query language
What is RDS
RDS is mainly used for what?
Disaster Recovery
Any computer programming language that requests and retrieves data from a database management system (DBMS)
Query Language
Using RDS, can you SSH into your instances?
No
When RDS detects you are running out of free database storage, it scales automatically. What is this feature called?
RDS - Storage Auto Scaling
What is RDS - Storage Auto Scaling good for?
Applications with unpredictable workloads
Read replicas are only for (blank) statements
SELECT (means read)
Up to how many read replicas can you have?
5
What are the 3 different options for read replicas to scale?
Within AZ
Cross AZ
Cross Region
If the replication is ASYNC, what does that mean?
Reads are eventually consistent
In AWS for read replicas there’s a network cost when data does what?
Goes from one AZ to another
For RDS Read Replicas within the same region, do you have a fee?
No
Can Read Replicas be setup as Multi AZ for Disaster Recovery?
Yes
How do you make a RDS DB go from single AZ to multi AZ?
Click on “modify” for the database
If the master is not encrypted, can the read replicas be encrypted?
No
What does it mean to encrypt?
Encoding of information.
Used in a variety of online services to keep your data private & safe: from text messages and emails to banking details, cloud files and more
Encryption
How would you encrypt the master & read replicas?
AWS KMS - AES-256 encryption
What does TDE stand for?
Transparent Data Encryption
IAM database authentication only works with what? (2)
MySQL & PostgreSQL
Auth token has a lifetime of what?
15 minutes
If your RDS DB is unencrypted, how would you encrypt it?
Snapshot
Copy snapshot as encrypted
Create DB from snapshot
A fully managed relational database engine that’s compatible with MySQL & PostgreSQL
Aurora
Writer Endpoint
Pointing to the master
Reader Endpoint
Connection Load Balancing
Aurora can deliver up to (blank) times the throughput of (blank) and up to (blank) times the throughput of (blank) w/o requiring changes to most of your existing applications
5/MySQL
3/PostgresSQL
Aurora security is the exact same as (blank) security
RDS
You return the state of an Aurora cluster to a specific point in time.
What feature in Aurora is this called
Backtracking
A single database that spans multiple AWS Regions, enabling low latency (blank) reads and disaster recovery from any Region-wide outage
What Aurora feature is this?
Global database
Provides simple, optimized, and secure integration between Aurora and AWS (blank) services without having to build custom integrations or move data around.
What Aurora feature is this?
Machine Learning
An on-demand, auto-scaling feature designed to be a cost-effective approach to running intermittent or unpredictable workloads
What Aurora feature is this?
Serverless
Represents a set of DB instances that you choose. When you connect to the (blank), Aurora performs load balancing and chooses one of the instances in the group to handle the connection.
What Aurora feature is this?
Custom endpoint
In case you want immediate failover for write node (you want HA for the writer node)
Multi-Master
Using Elasticache involves heavy application (blank)
Code changes
What is the point of Elasticache?
To get managed Redis or Memcached
- Multi AZ with Auto-Failover
- Read Replicas to scale reads and have high availability
- Data durability using AOF persistence
- Backup and restore features
(High Availability, Backup, Read Replica)
Redis
- Multi-node for partitioning of data (sharding)
- No high availability (replication)
- Non persistent
- No backup and restore
- Multi-threaded architecture
(Can’t afford to lose data)
Memcached
High performance, distributed memory object caching system, intended for use in speeding up dynamic web application
Memcached
In-memory data structure store used as database, cache and message broker. Offers Multi-AZ with Auto-Failover and enhanced robustness
Redis
All caches in Elasticache does NOT support what?
IAM Authentication
What is the main use case for Redis?
Gaming Leaderboards
A way to shorten the length of the critical rendering path, which translates into reduced page load times
Lazy loading
FTP SSH SFTP HTTP HTTPS
important port
PostgreSQL MySQL Oracle RDS MSSQL Server MariaDB Aurora
RDS Databases ports
(Blank) helps when you plan a disaster recovery for an entire AZ going down.
Multi AZ
What two features help scaling reads?
Elasticache & RDS Read Replicas
(Blank) keeps the same connection string regardless of which database is up
Multi AZ
A common pattern to ensuring different EC2 instances can retrieve your users state if needed
Storing session data in Elasticache
(Blank) allows you to have an Aurora Replica in another AWS Region, with up to 5 secondary regions
Aurora Global Database
How can you enhance the security of your Elasticache Redis Cluster by forcing users to enter a password when they connect?
Redis Auth
The process or act of confirming that a user who is attempting to log in to a database is authorized to do so, and is only accorded the rights to perform activities that he or she has been authorized to do.
Database Authentication
Read Replicas uses (blank) replication
Asynchronous
Multi AZ uses (blank) Replication
Synchronous
How many Aurora Read Replicas can you have in a single Aurora DB Cluster?
15
