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.

Heroku

This site is built on Heroku

Join the ranks of developers at Salesforce, Airbase, DEV, and more who deploy their mission critical applications on Heroku. Sign up today and launch your first app!

Get Started

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more