Which relational databases does RDS support?
- MySQL
- PostgreSQL
- Oracle
- Aurora
- SQL Server
- MariaDB
OLTP vs OLAP?
- OLTP
- Online Transaction Processing
- Simple queries like insert, get
- This is basically what RDS is
- OLAP
- Online Analytics Processing
- Used for business intelligence and big data
- More complex queries
- Redshift
Which are the two types of backup for RDS?
- Automated
- Retention period is 1 to 35 days
- Takes a full daily snapshot, and also stores transaction logs throughout the day
- Recovery: AWS chooses the most recent daily backup, then apply transaction logs relevant to that day
- You can recover to any point in time down to a second (within the retention period)
- Enabled by default
- Stored in S3, free storage equal to the size of your database
- Backups are taken within a defined window, during which you may experience elevated latency
- Is deleted when your database is deleted
- Snapshot
- Taken manually/ user initiated
- Stored even after your database has been deleted
When you restore either an Automatic Backup or manual Snapshot, will the restored version of the database have a new DNS endpoint?
Yes. It will be a new RDS instance with a new DNS endpoint.
Which database types supports encryption at rest?
- All of them
* (MariaDB, Oracle, PostgreSQL, SQL Server, Aurora, MySQL)
How does an encrypted RDS instance effect backups, snapshots and Read Replicas?
Once your RDS instance is encrypted, the data stored at rest in the underlying storage is encrypted, as are its automated backups, snapshots, and read replicas.
How do you encrypt an existing RDS instance?
- Create a snapshot of the instance
- Make a copy of the snapshot, and encrypt the copy
- Deploy a new RDS instance from the encrypted copy
What AWS service is used for encryption at rest of RDS instances?
KMS (Key Management Service)
Which of the RDS types has support for Multi-AZ?
- All of them
- Aurora is per default spread across multiple Availability Zones
- For the others you have to turn it on
How many Read replicas can you, per default, have per RDS instance?
5
You can have a Read Replica that have Multi-AZ.
True
For which of the RDS types is Read Replicas supported?
All of them.
Name one requirement for having Read Replicas.
- You must have automatic backups turned on
Can you create Read Replicas of Multi-AZ source databases?
Yes.
You can promote a Read Replica to its own database.
True, but it will break the replication.
It is possible to have a Read replica in another Region.
True.
A Read Replica can have encryption at rest even if the primary database doesn’t have it.
True.
