DEV Community

Cover image for Learning AWS Day by Day — Day 37 — Amazon RDS, RedShift and Aurora — Overview
Saloni Singh
Saloni Singh

Posted on

Learning AWS Day by Day — Day 37 — Amazon RDS, RedShift and Aurora — Overview

Exploring AWS !!

Day 37:

Amazon RDS, RedShift and Aurora — Overview:

Image description

RDS (Relational Database Service):

  • managed database service for databases using SQL as query language.
  • Allows you to create database in cloud that are managed by AWS
  • supports: Postgres, MySQL, MariaDB, Oracle, MS SQL server, Aurora (AWS proprietary database) Advantages over using RDS v/s deploying Database on EC2:
  • RDS is a managed service
  • Automated provisioning, OS patching
  • Continuous backups and restore to specific timestamp (Point-In-Time-Restore)
  • Monitoring dashboards
  • Multi-AZ setup for Disaster recovery
  • Maintenance window for upgrades
  • Scaling capability (vertical and horizontal)
  • Storage backed by EBS
  • Can’t SSH into instance

Amazon RedShift:

  • user columnar data storage
  • unlike SQL, data is not stored in rows but in columns, which is ideal for data warehousing.
  • requires fewer reads
  • best suited for online analytical processing
  • does not require any indexes or materialized views.
  • cluster — combination of set of nodes, leader node and one or more compute node. Leader node received the queries from an application, parses queries and makes an executable plan.
  • 2 types of nodes — Dense Storage (DS) -> Storage optimized, Dense Compute -> Compute Optimized
  • Nodes are scalable
  • Single node has 160 GB storage and in a cluster we can have 128 compute nodes.

Amazon Aurora:

  • proprietary technology from AWS (not open sourced)
  • Postgres and MySQL are both supported as AuroraDB (means your drivers work as if Aurora was a Postgres or MySQL database)
  • Aurora is AWS cloud optimized and claims 5x performance improvement over MySQL and 3x improvement over PostgreSQL on RDS.
  • storage automatically grows increments of 10 GB to 128 TB.
  • It can have 15 replicas while MySQL has 5 & replication is faster.
  • failover in Aurora is instantaneous, its High availability native.
  • Aurora costs more than RDS (20% more) but is more efficient.

Top comments (0)