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)

👋 Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay