All Notes
AWS
AWS
  • AIM
  • General Stuff about AWS
  • AWS Global Infrastructure
  • Interacting with AWS
  • AWS Identity and Access Management
    • AWS Organizations
    • Users
    • Policies and Permissions
    • Groups and Roles
    • Federation
    • Access Control (via available tools)
    • AWS Cognito
    • AWS IAM Identity Center
  • Networking and Content Delivery in AWS
    • AWS VPC
    • AWS Route 53
    • Elastic Load Balancing
    • AWS CloudFront
    • Amazon API Gateway
  • AWS Storage Services
    • Amazon EBS
    • Amazon EFS
    • Amazon FSx
    • S3
    • AWS Databases Services
      • Amazon RDS
      • Amazon DymanoDB
      • Amazon Elasticache
      • Amazon RedShift
      • Amazon DocumentDB
  • AWS Compute Services
    • EC2
    • Elastic BeanStalk
    • AWS Lambda
    • Container Services
      • ECR and ECS
      • EKS
      • AppRunner
  • Other AWS Services
    • CloudFormation
    • AWS Key Management Services (KMS)
    • AWS Secrets Manager
    • AWS Certificate Manager (ACM)
    • AWS Messaging Services
      • AWS SNS (Simple Notification Service)
      • AWS Simple Queue Service (SQS)
    • AWS Systems Manager
      • Application Management
      • Node Management
    • Logging and Monitoring
      • AWS CloudTrail
      • AWS CloudWatch
    • AWS Macie
    • AWS Inspector
    • AWS GuardDuty
Powered by GitBook
On this page
  • Features
  • Steps for Implementation
  1. AWS Storage Services
  2. AWS Databases Services

Amazon RDS

PreviousAWS Databases ServicesNextAmazon DymanoDB

Last updated 6 months ago

Features

It is a relational database that supports MySQL, PostgreSQL, MariaDB, Oracle Database, SQL Server as well as Amazon Aurora

Its a fully managed service offering from Amazon that falls under PaaS category, so it handles provisioning, patching, backup and recovery. It provides both general purpose SSD and provisioned IOPS SSD drive. Because it is a PaaS offering, it is basically a DB application/service on an EC2 instance in a particular VPC.

Deployment: The deployment is supported in multiple availability zones. Users can easily launch a relational database instance in RDS. AWS manages the provisioning of hardware, database setup, patching, and backups, reducing administrative overhead.

Amazon's own RDS: Amazon Aurora is a MySQL and PostgreSQL compatible relational database built for the cloud that combines performance of traditional enterprise databases with simplicity and cost-effectiveness of open source databases.

Database Engines: RDS supports multiple database engines, allowing users to choose the one that best suits their application requirements.

Scaling: RDS provides options for vertical and horizontal scaling to accommodate growing workloads. Users can resize instances or create read replicas for improved performance and availability.

Automated Backups: RDS automated database backups, making it simple to recover data in case of failures or user errors. Users can also set up automated snapshots for data retention.

Security: RDS offers robust security features, including network isolation, encryption at rest and in transit, and integration with AWS Identity and Access Management (IAM) for fine-grained access control.

Monitoring and Metrics: AWS CloudWatch integration allows users to monitor database performance and set up alarms for proactive issue resolution.

High Availability: RDS supports Multi-AZ deployments for failover and read replicas for improved availability and fault tolerance.

AWS RDS simplifies database management, ensuring that organisations can focus on their applications while AWS takes care of the database infrastructure, backups, and maintenance. It’s a valuable service for those looking to run relational databases in the cloud with ease and reliability.

Source:

Steps for Implementation

Navigate to AWS RDS

Refer either of the below links for setting up IAM authentication to RDS over SSM: OR

https://www.nisheetsinvhal.com/blog/how-to-connect-to-rds-using-ssm-and-iam
https://dev.to/suzuki0430/how-to-securely-connect-to-a-database-from-a-local-environment-using-aws-session-manager-i07
https://alexanderhose.com/content/images/size/w1000/2023/01/aws-rds-architecture-diagram.png