aws-rdslisted

# AWS RDS Deploy and manage Amazon RDS relational databases with production-grade backups, replication, monitoring, and security. ## When to Use This Skill - Provisioning a managed PostgreSQL, MySQL, MariaDB, Oracle, or SQL Server database - Setting up Multi-AZ deployments for high availability - Creating read replicas for horizontal read scaling - Configuring automated backups, snapshots, and point-in-time recovery - Tuning database parameters for performance - Migrating from self-managed databases to RDS - Monitoring database performance and setting up alarms ## Prerequisites - AWS CLI v2 installed and configured - IAM permissions: `rds:*`, `ec2:DescribeSecurityGroups`, `ec2:DescribeSubnets`, `kms:*`, `cloudwatch:*` - A VPC with at least two subnets in different AZs (for subnet group) - Security group allowing database port access from application subnets only ## Create a DB Subnet Group ```bash # Create a subnet group spanning two AZs aws rds create-db-subnet-group \ --db-subnet-group-name production-db-subnets \ --db-subnet-group-description "Production database subnets" \ --subnet-ids subnet-private-a subnet-private-b # List subnet groups aws rds describe-db-subnet-groups \ --query "DBSubnetGroups[].{Name:DBSubnetGroupName,VPC:VpcId,Status:SubnetGroupStatus}" \ --output table ``` ## Create a Production Database ```bash # Create a PostgreSQL 16 Multi-AZ instance aws rds create-db-instance \ --db-instance-identifier production-api-db \ --db-instance