AWS Databases
AWS database services are managed offerings covering relational, key-value, document, graph, time-series, and in-memory workloads. They handle provisioning, patching, backups, and replication so teams can focus on schema design and query patterns rather than infrastructure.
itCloud computing | OpenSkills.info
Course pathWalk it in order
Look it upDip in anytime
Go furtherLeaves this page
Don't Panic
Don't Panic — AWS Databases
AWS Databases is a collection of managed database services, not a very large database wearing several hats. That is good news, because applications do not all ask the same questions. It is also bad news, because the service list is happy to look like a buffet when what you needed was a map.
Start with the workload. A data model is the way records and relationships are represented. Tables and joins point toward relational services such as Amazon RDS or Amazon Aurora. Known lookups by a key point toward Amazon DynamoDB. Relationship traversal points toward Amazon Neptune. Measurements arranged around time point toward Amazon Timestream. The product name comes after that evidence, not before it, which saves an impressive amount of confident wandering.
The surprise is that managed does not mean unattended. AWS takes on infrastructure work, but the application still owns schema choices, queries, identities, network paths, connections, recovery behavior, and the awkward moment when a real client meets a failover. An access pattern, the specific way an application reads or writes data, is therefore more useful than a vague requirement for "scale." It gives the database something concrete to be good at.
Keep three ideas in separate boxes. Availability keeps a service reachable through a defined failure. Scale adds useful capacity. Recovery restores service and data after damage. An RDS Multi-AZ standby supports availability, but it does not serve read traffic. A read replica can add read capacity, but it can lag. Backups support recovery, but only a restore rehearsal tells you whether the application returns in time. These are not interchangeable talismans, however much a diagram may wish otherwise.
More than one database can be the sensible answer. Orders might need relational transactions, while predictable session lookups fit a key-value store and a cache serves hot reusable reads. That arrangement is called polyglot persistence. It also creates another schema, security boundary, monitor, backup path, and failure mode for every new service. The sensible choice is not the most exotic service; it is the one whose model and failure behavior match the evidence.
Read the Intro for the portfolio and the decision questions. Use the Slides when the service relationships need a compact map. Keep the Cheatsheet nearby for the selection matrix, recovery distinctions, and monitoring signals. Then use the Practice Reference and exercise to turn a fictional workload into a decision record before any console clicks acquire the confidence of a plan.
Where this skill leads
Relevant careers
See how this topic contributes to broader role-level skill maps.
Sources
- https://docs.aws.amazon.com/databases-on-aws-how-to-choose/
Supports
- AWS provides relational, key-value, document, in-memory, graph, time-series, wide-column, and vector database options
- Relational services support structured data, joins, and flexible query patterns
- DynamoDB, DocumentDB, Neptune, Timestream, Keyspaces, ElastiCache, and MemoryDB map to distinct workload and data-model needs
- One application can combine best-fit database types
- Amazon Redshift targets analytical data-warehouse workloads rather than the default OLTP path
- Serverless database options scale capacity and use pay-for-use models
- https://aws.amazon.com/products/databases/
Supports
- AWS maintains a portfolio of managed and purpose-built database services
- AWS database services provide service-specific availability, security, scaling, and vector capabilities
- Managed database services reduce common database infrastructure administration
- https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Welcome.html
Supports
- RDS supports Db2, MariaDB, Microsoft SQL Server, MySQL, Oracle Database, and PostgreSQL
- RDS manages common tasks including installation, patching, backups, failure detection, and recovery
- Customers retain responsibility for database design, query tuning, monitoring, identities, and workload-specific behavior
- RDS supports Multi-AZ deployments, read replicas, VPC placement, CloudWatch monitoring, and several storage and billing models
- https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_AuroraOverview.html
Supports
- Aurora is a managed relational database compatible with MySQL and PostgreSQL
- Aurora clusters separate shared storage from database compute
- Aurora provides cluster endpoints for connection roles and service-specific scaling and availability features
- https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Introduction.html
Supports
- DynamoDB is a serverless fully managed NoSQL database
- DynamoDB supports key-value and document data models
- Primary key design controls item identification and data distribution
- DynamoDB provides on-demand and provisioned capacity modes, consistency options, backups, and global tables
- https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.MultiAZSingleStandby.html
Supports
- A single-standby RDS Multi-AZ DB instance deployment uses synchronous replication to another Availability Zone
- RDS can fail over to the standby for high availability
- A single standby does not serve read traffic and is not a read-scaling mechanism
- Synchronous replication can increase write and commit latency
- https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html
Supports
- RDS DB instance read replicas are read-only copies used to reduce read load
- RDS DB instance read replicas receive primary changes asynchronously and can expose stale data
- Read replicas and Multi-AZ standbys have different purposes and replication behavior
- Read replicas can be promoted and can support cross-Region recovery patterns
- https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html
Supports
- RDS creates automated backups during the backup window and retains them for the configured period
- RDS supports point-in-time recovery within the backup retention period
- Manual snapshots have a lifecycle independent from automated backups
- Backup deletion and retention behavior depends on database deletion choices
- https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html
Supports
- RDS encryption at rest covers storage, logs, automated backups, read replicas, and snapshots
- RDS uses AWS KMS keys and supports AWS-managed or customer-managed keys
- Disabling or losing access to a KMS key can make encrypted RDS resources inaccessible
- Key choice and key policy belong in database protection and recovery planning
- https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MonitoringOverview.html
Supports
- RDS integrates with CloudWatch metrics and alarms
- RDS provides Performance Insights and Enhanced Monitoring
- RDS monitoring includes connections, read and write operations, storage, CPU, memory, network traffic, logs, and events
- Monitoring supports reliability, availability, and performance work but requires workload-specific interpretation
- https://docs.aws.amazon.com/whitepapers/latest/aws-risk-and-compliance/shared-responsibility-model.html
Supports
- AWS and customers share security and compliance responsibilities
- AWS operates the infrastructure from the host operating system and virtualization layer through physical facilities
- Customer responsibilities vary with the selected service and include configured controls, applications, data, and compliance requirements
- https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html
Supports
- AWS DMS discovers sources, converts schemas, and migrates relational, warehouse, NoSQL, and other data stores
- DMS supports one-time migration and ongoing replication
- DMS Fleet Advisor builds an inventory for migration planning
- DMS migrations use source and target endpoints and replication tasks
- https://docs.aws.amazon.com/dms/latest/userguide/schema-conversion.html
Supports
- DMS Schema Conversion assesses heterogeneous migration complexity
- DMS Schema Conversion converts schemas and many database code objects to a target-compatible format
- Conversion reports identify objects that require manual action
- Converted code can be reviewed, saved, edited, or applied to the target
- https://aws.amazon.com/about-aws/whats-new/2009/10/27/introducing-amazon-relational-database-service/
Supports
- Amazon RDS was introduced in October 2009 as a managed relational database service
- https://aws.amazon.com/about-aws/whats-new/2012/01/18/aws-announces-dynamodb/
Supports
- Amazon DynamoDB was announced in January 2012
- https://docs.aws.amazon.com/whitepapers/latest/data-warehousing-on-aws/introducing-amazon-redshift.html
Supports
- Amazon Redshift launched in February 2013 as an AWS data warehouse
- https://aws.amazon.com/blogs/aws/highly-scalable-mysql-compat-rds-db-engine/
Supports
- Amazon Aurora was announced in November 2014 as a MySQL-compatible relational service
- https://aws.amazon.com/blogs/aws/aws-database-migration-service/
Supports
- AWS Database Migration Service was introduced in October 2015
- https://aws.amazon.com/blogs/aws/amazon-neptune-fast-reliable-graph-database-built-for-the-cloud/
Supports
- Amazon Neptune became generally available in May 2018
- https://aws.amazon.com/about-aws/whats-new/2019/01/amazon-documentdb-with-mongodb-compatibility-generally-available/
Supports
- Amazon DocumentDB became generally available in January 2019
- https://aws.amazon.com/about-aws/whats-new/2020/09/amazon-timestream-now-generally-available/
Supports
- Amazon Timestream became generally available in September 2020
- https://aws.amazon.com/about-aws/whats-new/2021/08/amazon-memorydb-redis/
Supports
- Amazon MemoryDB was announced in August 2021 as a durable in-memory database service
