AWS RDS 数据库部署与管理指南 - 快速上手PostgreSQL/MySQL最佳实践

aws-rds-database by aj-geddes/useful-ai-prompts

155 周安装量

162 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill aws-rds-database

云服务数据库开发运维

🇨🇳中文介绍

AWS RDS 数据库

概述

Amazon RDS 简化了关系型数据库的部署和运维。它支持多种数据库引擎，并通过多可用区部署提供自动备份、复制、加密和高可用性。

适用场景

PostgreSQL 和 MySQL 应用程序
事务型数据库和 OLTP
Oracle 和 Microsoft SQL Server 工作负载
使用副本的读密集型应用程序
开发和暂存环境
需要符合 ACID 特性的数据
需要自动备份的应用程序
灾难恢复场景

快速开始

最小工作示例：

# 创建数据库子网组
aws rds create-db-subnet-group \
  --db-subnet-group-name app-db-subnet \
  --db-subnet-group-description "App database subnet" \
  --subnet-ids subnet-12345 subnet-67890

# 为 RDS 创建安全组
aws ec2 create-security-group \
  --group-name rds-sg \
  --description "RDS security group" \
  --vpc-id vpc-12345

# 允许 PostgreSQL 入站连接
aws ec2 authorize-security-group-ingress \
  --group-id sg-rds123 \
  --protocol tcp \
  --port 5432 \
  --source-security-group-id sg-app123

# 创建 RDS 实例
aws rds create-db-instance \
  --db-instance-identifier myapp-db \
  --db-instance-class db.t3.micro \
  --engine postgres \
  --engine-version 15.2 \
// ... (完整实现请参阅参考指南)

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

指南	内容
使用 AWS CLI 创建 RDS 实例	使用 AWS CLI 创建 RDS 实例
Terraform RDS 配置	Terraform RDS 配置
数据库连接与配置	数据库连接与配置

🇺🇸English

AWS RDS Database

Overview
When to Use
Quick Start
Reference Guides
Best Practices

Overview

Amazon RDS simplifies relational database deployment and operations. Support multiple database engines with automated backups, replication, encryption, and high availability through Multi-AZ deployments.

When to Use

PostgreSQL and MySQL applications
Transactional databases and OLTP
Oracle and Microsoft SQL Server workloads
Read-heavy applications with replicas
Development and staging environments
Data requiring ACID compliance
Applications needing automatic backups
Disaster recovery scenarios

Quick Start

Minimal working example:

# Create DB subnet group
aws rds create-db-subnet-group \
  --db-subnet-group-name app-db-subnet \
  --db-subnet-group-description "App database subnet" \
  --subnet-ids subnet-12345 subnet-67890

# Create security group for RDS
aws ec2 create-security-group \
  --group-name rds-sg \
  --description "RDS security group" \
  --vpc-id vpc-12345

# Allow inbound PostgreSQL
aws ec2 authorize-security-group-ingress \
  --group-id sg-rds123 \
  --protocol tcp \
  --port 5432 \
  --source-security-group-id sg-app123

# Create RDS instance
aws rds create-db-instance \
  --db-instance-identifier myapp-db \
  --db-instance-class db.t3.micro \
  --engine postgres \
  --engine-version 15.2 \
// ... (see reference guides for full implementation)

Reference Guides

Detailed implementations in the references/ directory:

Guide	Contents
RDS Instance Creation with AWS CLI	RDS Instance Creation with AWS CLI
Terraform RDS Configuration	Terraform RDS Configuration
Database Connection and Configuration	Database Connection and Configuration

Best Practices

✅ DO

Use Multi-AZ for production
Enable automated backups
Use encryption at rest and in transit
Implement IAM database authentication
Create read replicas for scaling
Monitor performance metrics
Set up CloudWatch alarms
Store credentials in Secrets Manager
Use parameter groups for configuration

❌ DON'T

Store passwords in code
Disable encryption
Use public accessibility in production
Ignore backup retention
Skip automated backups
Create databases without Multi-AZ

Weekly Installs

110

Repository

aj-geddes/usefu…-prompts

GitHub Stars

116

First Seen

Jan 21, 2026

Security Audits

Gen Agent Trust HubPass SocketWarn SnykFail

Installed on

gemini-cli93

opencode93

claude-code91

codex88

cursor84

github-copilot77

AWS RDS 数据库部署与管理指南 - 快速上手PostgreSQL/MySQL最佳实践

🇨🇳中文介绍

AWS RDS 数据库

目录

概述

适用场景

快速开始

相关 Skills

参考指南

最佳实践

✅ 建议

❌ 不建议