Aws Aurora

What it does

This skill provides guidance and assistance for deploying and managing Amazon Aurora, a MySQL/PostgreSQL-compatible relational database service. It focuses on best practices for serverless architectures, emphasizing connection management strategies using RDS Proxy or Data API to avoid direct connections from Lambda functions. The skill covers different Aurora deployment options like Serverless v2, Provisioned, and Global, along with connection strategies optimized for various workloads.

When to use it

• When deploying an Aurora database for a serverless application (e.g., using AWS Lambda).
• For setting up high availability and disaster recovery solutions utilizing Aurora Global.
• To optimize connection management and concurrency when dealing with variable or predictable workloads.
• When needing simple HTTP access to Aurora Serverless without requiring a VPC, leveraging the Data API.

Key capabilities

• Provides guidance on using RDS Proxy for connection pooling and automatic failover handling.
• Explains how to use the Data API for simplified serverless access to Aurora.
• Covers different Aurora deployment options: Serverless v2, Provisioned, and Global.
• Offers examples of CDK code snippets for setting up an RDS Proxy.
• Details connection strategies optimized for Lambda functions, application servers (ECS/EC2), and serverless environments.

Example prompts

• "How do I connect my AWS Lambda function to Aurora using RDS Proxy?"
• "What are the benefits of using Aurora Data API?"
• "Explain the differences between Aurora Serverless v2 and Aurora Provisioned."
• “Show me an example CDK code for creating an RDS proxy.”

Tips & gotchas

• For Lambda functions, always use RDS Proxy or Data API to manage connections. Avoid direct raw connections.
• Aurora Global is specifically designed for multi-region deployments and disaster recovery scenarios.
• Data API introduces higher latency per query compared to using RDS Proxy.