Databases Flashcards
Which relational databases are available through AWS? (6)
- SQL Server
- Oracle
- MySQL Server
- PostgreSQL
- Aurora
- MariaDB
What are the two key features of the Relational Database Services? (2)
- Multi-AZ, for disaster recovery
- Read Replicas, for performance
On what does RDS run?
Virtual machines
Whose responsibility is the patching of the RDS operating system and database?
Amazon’s
Is RDS serverless?
No, except for Aurora Serverless
What is DynamoDB?
Amazon’s NoSQL solution
If you have a restored version of a database, does its DNS endpoint stay the same or change?
With any type of backup (automated/snapshot), the restored version of the database will be a new RDS instance with a new DNS endpoint
What level of recovery do automated backups allow you?
Allow you to recover your database to any point in time within a retention period of 1-35 days
How often do automated backups take a full backup? (2)
- A full backup each day
- Also store transaction logs throughout the day
How do automated backups allow point in time recovery down to the second? (2)
- AWS first chooses the most recent daily back up
- Then applies transaction logs relevant to that day
Are automated backups enabled by default?
Yes
Where is the backup data from automated backups stored?
In S3
How much free storage space do you have with automated backups?
Free storage space equal to the size of your database
What occurs during a backup window for automated backups? (2)
- Storage input/output may be suspended
- May experience elevated latency
Are database snapshots conducted manually or automatically?
Database snapshots are done manually
Are database snapshots and automated backups stored after you delete the original RDS instance? (2)
- Database snapshots are stored even after you delete the original RDS instance
- Automated backups are not stored even after you delete the original RDS instance
What does a Multi-AZ backup allow you to have?
A Multi-AZ backup allows you to have an exact copy of your production database in another Availability Zone
What are examples of incidents which trigger the use of Multi-AZ protection? (4)
- Primary database goes down
- Planned database maintenance
- DB instance failure
- Availability Zone failure
Describe the connections of the primary database and secondary database within a Multi-AZ backup setup (2)
- Primary database in an AZ DNS address EC2 instance
- Secondary database in an AZ DNS address EC2 instance
What occurs should the primary database go down, but Multi-AZ backups are enabled? (2)
- The DNS address will update automatically and direct to the secondary database
- Amazon RDS will automatically failover to the standby
