Databases on AWS Flashcards
What is RDS?
AWS’s relational database service.
What is RDS primarily used for?
OLTP- Online Transaction Processing
What is DynamoDB primarily used for?
OLAP- Online Analytics Processing
What are the 6 engines currently supported on RDS?
1) mySQL
2) Amazon Aurora
3) PostgreSQL
4) MariaDB
5) Oracle
6) SQL server
What is Redshift?
AWS’s data warehousing solution.
What is ElastiCache?
Service used to cache frequently used queries to improve performance of existing databases:
Name 2 ElastiCache engines?
1) Redis- Advanced multi AZ or backups
2) Memcached- Basic caching
What does RDS run on?
VMs
Can you access a RDS?
No, you cannot SSH into a RDS vm
Who is responsible for patching RDS OSs?
AWS is responsible for patching underlying VM of an RDS instance
Is RDS serverless?
No, but Amazon’s Aurora is serverless
Is DynamoDB serverless?
Yes
What are the 2 types of backups available on RDS?
1) Automated backups
2) Database snapshots
What is a read replica and why would you use one?
Read replica is the process of replicated an RDS instance and using one copy for read only and the primary RDS instance as the read/write instance. It is used to improve the performance of a database.
Can read replicas be multi AZ?
Yes
What must be turned on to activate read replicas?
Backups must be turned on to use read replicas
Which 5 database engines can use read replicas?
1) MySQL
2) PostreSQL
3) MariaDB
4) Oracle
5) Aurora
What is RDS multi AZ used for?
Disaster recovery
Can Encryption be used for an RDS?
Yes, this can be done using the AWS key management service
What are the 2 key features of RDS?
1) Stored on SSD storage
2) Spread across 3 geographically distinct data centers
What is the default back up duration for redshift?
1 day, but can be changed to 35 days
By default how many copies does AWS keep of your Redshift data?
3 –> Original, replica on compute node and a back up on S3 (DR)
How many copies of you data does Aurora keep by default?
Aurora automatically maintains 6 copies of your data across 3 Availability Zones and will automatically attempt to recover your database in a healthy AZ with no data loss
Can you share Aurora snapshots with other AWS accounts?
Yes
Does aurora have auto-back up switched on by default?
Yes
How many AZ is data spread over by default with DynamoDB
1
What are the 3 data formats supported by Athena?
1) Apache Paraquet
2) JSON
3) Apache ORC
How would you run a database from an EC2 instance?
Create EC2 instance and use EBS for storage of the database
