Day 22: Amazon RDS πŸŒŠπŸ”

Day 22: Amazon RDS πŸŒŠπŸ”

Introduction πŸ—ΊοΈπŸš’

Dive into the seas of Amazon RDS (Relational Database Service), where managed databases take the helm, steering through the SQL realm. Explore the advantages, scaling capabilities, and disaster recovery features that make RDS a sailor's delight.

Amazon RDS Overview πŸš€πŸ’½

Relational Database Symphony

RDS, or Relational Database Service, orchestrates databases in the cloud with seamless management for SQL-based databases:

  • Postgres

  • MySQL

  • MariaDB

  • Oracle

  • Microsoft SQL Server

  • Aurora (AWS Proprietary database)

Advantage over using RDS versus deploying DB on EC2 πŸ›‘οΈπŸ”§

The Managed Advantage

Choosing RDS over manual deployment on EC2 comes with perks:

  • Automated provisioning and OS patching

  • Continuous backups with point-in-time restore

  • Monitoring dashboards for insight

  • Read replicas for enhanced read performance

  • Multi-AZ setup for Disaster Recovery (DR)

  • Hassle-free scaling (vertical and horizontal)

RDS – Storage Auto Scaling πŸ”„πŸ“ˆ

Dynamic Storage Solutions

RDS Storage Auto Scaling ensures your database storage scales dynamically, preventing manual interventions. By setting maximum storage thresholds, RDS automatically adjusts storage when free storage is low, enhancing adaptability to unpredictable workloads.

RDS Read Replicas for Read Scalability πŸ“šπŸ”„

Replica Symphony

RDS Read Replicas bring harmony to read scalability:

  • Up to 15 Read Replicas within AZ, Cross AZ, or Cross Region

  • ASYNC replication ensures eventual consistency

  • Replicas can be promoted to standalone DBs

  • Ideal for read-heavy workloads, keeping the production DB unaffected

RDS Multi AZ (Disaster Recovery) β˜‚οΈπŸ”„

Disaster-Proofing

RDS Multi AZ ensures disaster recovery with synchronous replication:

  • SYNC replication for automatic failover

  • Enhances availability, guarding against AZ, network, or instance failures

  • Read Replicas can be part of Multi AZ setup for DR

RDS Custom πŸ§°πŸ› οΈ

Tailored Database Experience

For the ultimate customization, RDS Custom offers access to OS and database settings:

  • Managed Oracle and Microsoft SQL Server with customization

  • Full admin access to the underlying OS and database

  • Configure settings, install patches, enable native features

  • Access the underlying EC2 Instance using SSH or SSM Session Manager

Conclusion πŸŒŠβš“

In the vast ocean of AWS, Amazon RDS emerges as a captain, steering your databases with finesse. With advantages, scalability, and disaster recovery features, RDS sets sail to make your database management voyage a breeze. β›΅πŸŒ

Did you find this article valuable?

Support Prasad Suman Mohan by becoming a sponsor. Any amount is appreciated!

Β