Databases in AWS Flashcards
What is Amazon RDS?
A managed relational database service that is compatible with many of the most used database engines, such as MySQL, PostgreSQL, Oracle etc.
How do manual and automatic backups work with RDS?
Automated backups enable point-in-time-restore capability, but expire after 35 days.
Manual backups are kept for longer than this and thus can be used for longer term recovery.
What two engines is Aurora compatible with?
PostgreSQL and MySQL
When is the serverless version of Aurora appropriate?
For intermittent or unpredictable workloads
What is the strength of Aurora’s storage set up?
Data is stored in 6 replicas across 3 AZs, making it highly available and self-healing
What is the fastest way to make a new Aurora cluster from an existing one?
Cloning - faster than restoring a snapshot
What is ElastiCache?
A managed Redis/Memcached database service that utilises an in-memory store to deliver queries with sub-ms latency
What is one downside/serious consideration associated with using ElastiCache?
It will probably require modifications to your application’s code
What is an example of a use case for ElastiCache?
Key/value store, frequent reads (but not often written), cache results for DB queries, store session data for websites
What high availability feature does DynamoDB have as default?
Multi-AZ deployment
What is DynamoDB?
Proprietary AWS noSQL database that is useful for databases where you need a flexible or evolving schema
What are the two DynamoDB backup options?
Automated or manual.
Automated
How is security, authorisation and authentication handled for DynamoDB?
Through IAM
What is DocumentDB specialised for? Does it use SQL?
JSON data
No, DocumentDB is a NoSQL database service
What is Neptune?
A fully managed, highly available graph database.