AWS Database Flashcards
How many Database Types there is in AWS ?
4, RDS (OLTP), DynamoDB no SQL, RedShift OLAP, Elasticache
What RDS mean ?
Relational Database Service
What OLTP mean ?
Online Transaction Processing
What OLAP mean ?
Online Analytics processing
How many Databases services there is with RDS ?
6, SQL, MYSQL, PostrgreSQL, Aurora,MariaDB
How many Elasticache service there is ? what are they ?
2 Memcached, Redis
What is Multi AZ with RDS ?
Copy of RDS instance into different Zone, that would be failed over in case of outage.
What is Read Replica ?
Read copy only of the RDS instance, can be up to 5 replica.
Can we do Read Replica of Read Replica ?
Yes, but latency will get higher and higher
What is Aurora ?
Amazon Aurora is a relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It delivers up to five times the throughput of standard MySQL and up to three times the throughput of standard PostgreSQL.
How many copies of Aurora there is ?
2 Copies in each AZ and minimum of 3 AZ so total 6 copies
How many copies of data need to be lost to impact Write and Read of Aurora Instance ?
2 for write, 3 for read.
How many types of Auraora replicas there is ?
2
What’s the dfifference between Auraora replicas and MySQL Read Replicas
MySQL read replicas are the same as the RDS one, Aurora one is up to 15 and read and write
What the difference between DynamoDB and RDS database on scaling point of view ?
DynamoDB is scaling up with push button, can be scaled on the fly while RDS need to be stop, copy and snapshot.
