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