Amazon Aurora DSQL connections: Drivers, strings, and best practices
Database Blog
This article provides a comprehensive guide to connecting applications to Amazon Aurora DSQL, covering connection architecture, authentication, drivers, and best practices.
- Aurora DSQL uses distributed endpoints with format: cluster-id.dsql.region.on.aws on port 5432
- IAM-based authentication with short-lived tokens (15 minutes default, max 1 week)
- Tokens expire after 15 minutes but connections remain valid up to 60-minute hard limit
- AWS provides connectors for Java, Python, Node.js, Go, Ruby, .NET, and Rust
- Client-side connection pooling required; avoid server-side poolers like PgBouncer
- Connection rate limits: 100 connections/second steady state, 1,000 burst capacity
- Maximum transaction duration is 5 minutes; connections close after 60 minutes
- SSL/TLS encryption mandatory; use sslmode=verify-full for production
- Multi-Region clusters support active-active architecture with regional endpoints
- Troubleshooting covers authentication failures, network issues, and connection pool health
The guide emphasizes using Aurora DSQL connectors for automatic token management, implementing proper connection pooling, and following security best practices for credential management and network access control.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.