AWS DB Flashcards
How many relational databases?
6
List all the relational DBs?
- SQL Server
- Oracle
- MySQL Server
- postgresSQL
- Aurora
- MariaDB
What is NoSQL DB?
DynamoDB
What is best for OLAR?
Redshift
None Relational DB Are:
Collection = table
Document = Row
Key Value Pairs = Fields
OLTP (online Transaction Processing) VS OLAP (online Analytics Processing)
- OLAP require Data Warehousing both from database and infrastructure later
- Redshift is Amazon’s Data Warehousing
What is ElasticCache?
Web service that makes it easy to deploy, operate, and scale an in-memory cache in the cloud. improves the performance of your web applications by allowing you to retrieve information
from fast manage in memory caches instead of relying entirely on slower dis based databases.
2 open-source in-memory caching engines: Memcached and Redis
what are the 2 open-souerce in-memory caching engines
Memcached
Redis
RDS- Back Ups
What are the two different RDS Backups?
- automated backups
- database Snapshots
Automated back ups
- Any point in time in retention period (1 to 35 days)
- full day snapshots and transaction logs throughout the day.
- When you do recovery , AWS takes the latest backup and apply the transition logs relevant to that day.
- Point in time recovery down to the second within the retention period
- Automated Backups are enabled by default
- data is stored in S3 and free storage equal to the size of your database
- during backup window (that is defined) storage I/O may be suspended while your data is being backed up and you may experience elevated latency
Database Snapshots
- manual (user initiated)
- they are stored even after the original RDA instance (unlike automated backups)
Restoring backups
Restored version of the database will be new RDS instance with a new DNS endpoint
