Module 8

Amazon Relational Database Service

Unmanaged	Managed
Scaling, fault tolerance, and availability are managed by you	Scaling, fault tolerance, and availability are typically built into the service
Create, deploy, use	Deploy and start using

Amazon RDS (Managed Service)

STORES DATA IN TABLES

Most of the database will be managed by AWS. We just interact with the application connected

Topology

Topology with HA using 2 AZ

Use Cases

• Web and mobile applications

• Ecommerce applications

• Mobile and online games

Amazon DynamoDB

STORES DATA IN JSON FORMAT

The JSON format comprises of Key:Value pairs. You can have multiple keys using Single and Partition keys

You can retrieve data from a DynamoDB table in two different ways:

• The query operation takes advantage of partitioning to effectively locate items by using the primary key.

• Via a scan, which enables you to locate items in the table by matching conditions on non-key attributes. The second method gives you the flexibility to locate items by other attributes

You can add different Keys/Properties to the "Table" unlike real SQL DB tables which are fixed with the amount of Keys and Properties

Amazon Redshift

Compatibility

Amazon Redshift supports traditional/standard SQL. It also provides high-performance Java Database Connectivity (JDBC) and Open Database Connectivity (ODBC) connectors, which enable you to use the SQL clients and BI tools of your choice

Amazon Aurora

Amazon Aurora is a MySQL-and PostgreSQL-compatible relational database that is built for the cloud.It combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases

• Amazon Aurora is designed to be highly available.

• It stores multiple copies of your data across multiple Availability Zones with continuous backups to Amazon S3.

• Can use up to 15 read replicas can be used to reduce the possibility of losing your data