RDS Flashcards
RDS
Relational Database Service
Fully managed database service
Activities handled by AWS (4/5)
RDS
- Provisioning
- patching
- backup
- scalability
- recovery
RDS
Availability
RDS
Supports multiple AZs
RDS
Network access
RDS
Launches into a VPC
RDS
horizontal scalability
RDS
Read replicas, where supported by platform
RDS
Available Platforms (4/7)
RDS
MySQL
PostgreSQL
MariaDB
Oracle DB
SQL Server
IBM DB2
Aurora
RDS
Aurora
RDS
Cloud DB built by AWS
RDS
Compatibility
RDS Aurora
MySQL
PostgreSQL
RDS Aurora
DMS
RDS
DB Migration Service
Migrate from onprem DB to AWS
RDS
Migration options (2)
RDS DMS
Onetime
Continual
RDS DMS
Cost basis
RDS DMS
Pay per compute
RDS DMS
vertical scaling
RDS Scalability
add resources
RDS Scalability
storage autoscaling
RDS Scalability
RDS detects if storage is low automatically expands it
RDS Scalability
maximum storage threshold
RDS storage autoscaling
customizable limit for DB storage
RDS storage autoscaling
conditions that prompt automatic scaling (3)
RDS storage autoscaling
- free storage <10%
- low storage for 5 minutes
- 6 hours since last change
RDS storage autoscaling
which DB engines support
RDS storage autoscaling
all of them
RDS storage autoscaling
read replica
RDS
DB copy that services read requests
RDS
replica limit
RDS read replica
15
RDS read replica
replica placement options (3)
RDS read replica
- in AZ
- cross AZ
- cross region
RDS read replica
syncronization type (2)
RDS read replica
- asynchronous
- reads are eventually consistent
RDS read replica
how to set application to use replicas
RDS read replica
write connection string to include replicas
RDS read replica
use case
RDS read replica
reporting application uses replica instead of taxing main DB
RDS read replica
AZ cost benefit
RDS read replica
cross AZ traffic does not incur fees
RDS read replica
multi AZ option
RDS read replica
may set up replicas as multi AZ for DR
RDS read replica