Amazon Database Solutions
Updated: Jun 16, 2020
Amazon provides a wide range of database services. The support level includes customer hosted database services and AWS managed database services.

The diagram shows different flavours of AWS provided database services.

Amazon RDS
Amazon RDS is a relational SQL database engine. It is a cost-efficient db service, easy to launch and comes in various flavours like MySQL, MariaDB, Postgre SQL, Oracle and MSSQL. Some of the key features about RDS have been mentioned in the picture.

Amazon Dynamo DB
Simple and quick to set up and scale
Most suitable for fast, predictable performance and low latency
Automatic replication of data in multiple AZs
Highly available and durable
Pay as you use
Fully managed NoSQL database
Automatically manages backups, patching, failure detection and recovery
On-demand backup facility
No limit on amount of data retrieval and traffic
Scalability with no downtime
Access through IAM management
Interaction with DB through AWS Management Console and CLI or Dynamo DB API

Amazon ElastiCache
Distributed In-memory data store or cache environment in the cloud
Easy to set up, manage and scale
High performance and cost-effective caching solution
Works with Memcached and Redis engines
Can automatically detect and recover failure nodes
Can Integrate with other Amazon EC2, Amazon CloudWatch, AWS CloudTrail and Amazon SNS.
Supports multi-AZ, though optional.

Amazon Redshift
Most suitable for Online Analytical Processing (OLAP)
Suitable for SQL type of database requirements
Automatically manages backups, patching, failure detection and recovery
Provides flavours like MySQL, MariaDB, PostgreSQL, Oracle and MSSQL
Access through IAM management
Option provided for Multi-AZ deployment
Interaction with DB through AWS Management Console and CLI
Two types of DB instances based on charges
On-demand and
Reserved DB instances
