aws-aurora

# AWS Aurora Skill Amazon Aurora is a MySQL/PostgreSQL-compatible relational database with serverless scaling, high availability, and enterprise features. **Sources:** [Aurora Docs](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/) | [Serverless v2](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless-v2.html) | [RDS Proxy](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html) --- ## Core Principle **Use RDS Proxy for serverless, Data API for simplicity, connection pooling always.** Aurora excels at ACID-compliant workloads. For serverless architectures (Lambda), always use RDS Proxy or Data API to handle connection management. Never open raw connections from Lambda functions. --- ## Aurora Options | Option | Best For | |--------|----------| | **Aurora Serverless v2** | Variable workloads, auto-scaling (0.5-128 ACUs) | | **Aurora Provisioned** | Predictable workloads, maximum performance | | **Aurora Global** | Multi-region, disaster recovery | | **Data API** | Serverless without VPC, simple HTTP access | | **RDS Proxy** | Connection pooling for Lambda, high concurrency | --- ## Connection Strategies ### Strategy 1: RDS Proxy (Recommended for Lambda) ``` Lambda → RDS Proxy → Aurora (pool) ``` - Connection pooling and reuse - Automatic failover handling - IAM authentication support - Works with existing SQL clients ### Strategy 2: Data API (Simplest for Serverless) ``` Lambda → Data API (HTTP)...