Building at Scale: Aurora DSQL Essentials
Deep dive into Amazon Aurora Distributed SQL (DSQL), where you'll learn how to build a data store that seamlessly scales within a region or across regions. Through hands-on demonstrations, you'll discover how to leverage DSQL's automatic data distribution, manage single/multi-region transactions, and scale to meet your performance requirements.
The 100th episode of Let's Talk About Data Show featured a detailed discussion about Aurora D-SQL, Amazon's distributed SQL database service.
The discussion centered on DSQL's key features, including virtually unlimited scalability, high availability across regions, and serverless operation. The team demonstrated how DSQL maintains traditional relational database properties while distributing processing across multiple availability zones and regions. They showcased practical examples through demos including a multi-region "ping pong" application that illustrated DSQL's consistency guarantees.
The technical deep-dive included explanations of how DSQL handles connections, transaction processing, and storage across distributed systems. The team emphasized DSQL's ability to scale horizontally rather than vertically, its use of Firecracker for isolation, and its simplified management compared to traditional databases. They also discussed practical aspects like connection pooling, upgrade processes, and multi-region deployment.
Key Highlights:
- DSQL offers 4 nines availability in single region, 5 nines in multi-region configurations
- Supports up to 10,000 connections by default (expandable upon request)
- Cluster creation takes approximately 2 minutes
- Uses standard PostgreSQL protocol and drivers
- No need to manage instance sizes or storage - fully serverless
- Built-in IAM authentication
- Automatic scaling without downtime
- Supports multi-region active-active configurations
- Includes generous free tier for testing
- Uses Firecracker technology for security isolation
Try out what we shared in the show by using the free tier
Hosts of the show
Tony Mullen - Senior Database Specialist @AWS
Guests
Shyam Krishnamoorthy - General Manager and Technology Director @AWS
Marc Bowes - Sr. Principal Engineer @AWS
Links from today's episode
- DSQL - https://aws.amazon.com/rds/aurora/dsql/
- Introduction Blog - https://aws.amazon.com/blogs/database/introducing-amazon-aurora-dsql/
- What is DSQL - https://docs.aws.amazon.com/aurora-dsql/latest/userguide/what-is-aurora-dsql.html
- AWS samples - https://github.com/aws-samples/aurora-dsql-samples
- YouTube Getting Started Demo - https://www.youtube.com/watch?v=PH_9gg3EcT4&t=7s
- Lambda and API Gateway Integration - https://www.youtube.com/watch?v=bGKJi2Yj6Jg
- DSQL Pricing - https://aws.amazon.com/rds/aurora/dsql/pricing/
- DSQL free tier - https://aws.amazon.com/rds/aurora/dsql/pricing/?loc=ft#Free_tier
- Technical Deep Dive - https://marc-bowes.com/index.html
- Technical Deep Dive - https://brooker.co.za/blog/2024/12/03/aurora-dsql.html
- Repository - https://github.com/marcbowes/dsql-pingpong-py
- Optimistic Concurrency Control Blog - https://aws.amazon.com/blogs/database/concurrency-control-in-amazon-aurora-dsql/
Enjoyed reading this content? Let the author know!
Your likes, comments, shares, and saves help creators reach more builders.
Loading recommendations
Loading article