quick-notes-amazon-rds-relational-database-service

Amazon RDS (Relational Database Service) is a managed database service provided by AWS.

  1. Managed Service: AWS RDS is a fully managed relational database service, which means AWS takes care of database administration tasks such as backups, patching, and scaling.
  2. Database Engine Support: It supports various database engines including MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, and Amazon Aurora.
  3. Automated Backups: RDS automatically creates and retains backups of your database, allowing point-in-time recovery.
  4. Multi-AZ Deployments: You can set up Multi-AZ (Availability Zone) deployments for high availability and failover.
  5. Read Replicas: RDS allows you to create read replicas for read-heavy workloads, improving read performance.
  6. Security Groups: You can use security groups to control inbound and outbound traffic to your RDS instances.
  7. Parameter Groups: Customize database parameters to tune performance and behavior.
  8. Encryption at Rest: RDS supports encryption of data at rest using AWS Key Management Service (KMS).
  9. SSL Support: Secure your connections with SSL encryption.
  10. Database Events: Monitor and respond to database events using Amazon CloudWatch.
  11. Scaling: Easily scale your RDS instance vertically (by changing instance types) or horizontally (by adding read replicas).
  12. Maintenance Windows: Configure maintenance windows to schedule updates and patches.
  13. DB Snapshots: Manually create DB snapshots for backup and recovery purposes.
  14. Database Engine Upgrades: RDS allows for database engine version upgrades with minimal downtime.
  15. Parameter Store Integration: Integrate with AWS Systems Manager Parameter Store for storing and managing database credentials securely.
  16. Performance Insights: Gain insights into database performance and troubleshoot issues.
  17. Aurora: Amazon Aurora is a fully managed, highly available database engine that is compatible with MySQL and PostgreSQL.
  18. Global Databases: Aurora Global Databases provide cross-region replication for disaster recovery and read scaling.
  19. Database Authentication: Choose between database credentials, IAM database authentication, and integration with AWS Secrets Manager for authentication.
  20. Database Auditing: RDS supports database auditing using services like AWS CloudTrail and Amazon RDS Enhanced Monitoring.

AWS RDS simplifies database management tasks and is widely used for hosting and managing relational databases in the cloud. It offers scalability, high availability, security, and automation, making it a popular choice for a wide range of applications.

By Abhishek K.

Author is a Architect by profession. This blog is to share his experience and give back to the community what he learned throughout his career.