Select Page

RDS and DynamoDB Essentials

by | AWS

Amazon offers services for two main categories types of databases

  1. RDS for Relational Database known as “SQL
  2. DynamoDB for Non-Relational Databases known as “NoSQL

RDS Definition


“Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, resizable capacity for an industry relational database and manages common database administration tasks.”

Simplified: RDS is a SQL database service that provides a wide range of SQL database to select from.

SQL Options Include:

  1. Amazon Aurora
  2. MySQL
  3. MariaDB
  4. PostgreSQL
  5. Oracle (server Oracle options are available)
  6. Microsoft SQL Server (several Microsoft options are available)

DynamoDB Definition


“Amazon DynamoDB is a fast and flexible NoSQL database Service for all applications that need consistent, single-digit millisecond latency at any scale. Its flexible data model and reliable performance make it a great fit for mobile, web, gaming, ad-tech IoT, and many other applications.”

Simplified: DynamoDB is NoSQL database service. Unlike RDS, DynamoDB does NOT provide other NoSQL software options.

DynamoDB can replace (or is very similar to):

  1. MongoDB
  2. CassandraDB
  3. Oracle NoSQL

SQL vs. NoSQL


RDS (SQL)DynamoDB (NoSQL)
Stores related data in tables (using columns and rows).Stores related data in JSON-like, name-value documents.
Typically used for very structured data, such as contact list.Typically used for non-structured data such as cataloging documents.

Pricing


RDS Pricing

Free Tier use is available for all RDS options EXCEPT Aurora

  1. The RDS “engine” you choose
    • Amazon Aurora
    • MySQL
    • MariaDB
    • PostgreSQL
    • Oracle (server options are available)
    • Microsoft SQL Server (server Microsoft options are available)
  2. RDS Instance Classes
    • This is very similar to EC2 Instance types
  3. Purchasing Terms
    • On-Demand
    • Reserved
  4. Database Storage
  5. Data Transfer In/Out of RDS

DynamoDB Pricing

Free Tier use is availaable for DynamoDB

  1. Provisioned Throughput Capacity
  2. Indexed Data Storage
  3. DynamoDB Streams
  4. Reserved Capacity
  5. Data Transfer In/Out of DynamoDB

Provisioning RDS


Private Subnets and SSH Tunneling

How to Lunch an RDS MySQL Database

How to Connect to an RDS MySQL Database

Sources