Databases Flashcards
What are OLTP Workloads
Customer orders, banking, payments, booking systems, RDS is great for these small transactions
What is OLAP and what is best to use
More for querying/reporting instead of transaction processing. Best with something like Redshift
Read Replicas
Primarily used for scaling, not disastedr recovery. Requires automatic backup
Multi-AZ
An exact copy of prod DB in another AZ. Used for disaster recovery.
In the event of a failure, how do you point your system to use another RDS in Multi-AZ?
AWS automatically failovers to standby instance
DynamoDB
Store on SSD.
Can be eventually or strongly consistent reads
Eventually Consistent Reads
Consistency across all copies of data is usually reached within a second
Strongly consistent read
returns a result that reflects all writes
DynamoDb allows the following reads
eventual, strong and transactional
DynamoDB has the following write options
standard and transactional
What are ACID requirements and which technology provides this?
Atomicy, consistency, isolation and durability.
DynamoDB Transactions provides this
DynamoDB Streams
Time-ordered sequence of item-level changes in a table
Global Tables
Globally distributed apps.
good for adding redundancy to DynamoDB
