top of page

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

 

182 views0 comments
bottom of page