Post

About AWS RDS ?

Posted Updated
By
2 min read

AWS RDS: Managed Database Service

Overview

Amazon Relational Database Service (RDS) is a managed database service that allows you to create and manage databases in the cloud. RDS supports various database engines:

  • PostgreSQL
  • MySQL
  • MariaDB
  • Oracle
  • Microsoft SQL Server
  • IBM DB2
  • Amazon Aurora (AWS proprietary)

Key Features

  • Automated Provisioning and OS Patching: Simplifies database setup and management by handling the provisioning of infrastructure and patching of the operating system.

  • Continuous Backups: Ensures that your data is always backed up, allowing you to restore it to any point in time.

  • Monitoring Dashboard: Provides a comprehensive view of your database’s performance and health.

  • Read Replicas: Improves read performance by allowing you to create up to 15 read replicas. These replicas can be within the same availability zone (AZ), across different AZs, or even across regions. Replication is asynchronous, meaning reads are eventually consistent.

  • Multi-AZ Deployment: Enhances availability and disaster recovery. In a Multi-AZ setup, data is synchronously replicated to a standby instance in a different AZ. Transitioning from a single AZ to a Multi-AZ setup can be done with zero downtime by modifying the database settings.

  • Maintenance Windows: Designated periods during which RDS performs routine maintenance, such as software updates.

  • Scalability: RDS scales automatically, both in terms of compute and storage. You must set an upper limit for storage, but the system handles the scaling seamlessly.

  • Storage: Uses Amazon Elastic Block Store (EBS) for storage. The storage can be either General Purpose (gp2) or Provisioned IOPS (io1). Direct SSH access to the underlying storage is not allowed.

Network Costs

  • Intra-region Data Transfer: There is no cost for data transfer between RDS read replicas within the same region but across different AZs.
  • Inter-region Data Transfer: Data transfer costs apply when replicating data across regions.

Read Replicas

  • Scalability: Allows scaling of read operations by distributing them across multiple replicas.
  • Replication: Asynchronous replication ensures that reads are eventually consistent.
  • Configuration: Read replicas can be configured within the same AZ, across different AZs, or in different regions.

Multi-AZ for Disaster Recovery

  • Setup: Multi-AZ deployments can be easily configured by modifying the database instance.
  • Failover: In the event of an AZ failure, RDS automatically switches to the standby instance with zero downtime.
  • Snapshot and Sync Restore: A snapshot of the primary instance is taken and restored in the standby instance to ensure synchronous replication.

Conclusion

AWS RDS provides a robust and scalable solution for managing relational databases in the cloud. With features like automated provisioning, continuous backups, read replicas, and Multi-AZ deployments, RDS simplifies database management while enhancing performance, scalability, and disaster recovery.

AWS
RDS Database
This post is licensed under CC BY 4.0 by the author.