What is Amazon Aurora DSQL?
Amazon Aurora DSQL is a fully serverless, distributed relational database introduced by AWS at re:Invent 2024. DSQL stands for Distributed SQL and addresses a fundamental limitation of classical relational databases: the challenge of executing consistent, scalable transactions across multiple geographic regions. Aurora DSQL enables active-active operation in multiple AWS regions simultaneously, where all regions can execute both read and write operations with full ACID consistency.
The technical approach differs fundamentally from classical relational databases: Aurora DSQL uses optimistic concurrency control (OCC) instead of conventional pessimistic locking. Transactions run without row locks; at commit time, the system automatically checks for conflicts. When a write conflict occurs between concurrent transactions in different regions, one transaction is aborted and must be retried by the client. This approach enables very high throughput at low latencies, but requires conflict-tolerant application logic. Aurora DSQL is fully PostgreSQL compatible and requires no manual sharding or replication configuration.
Aurora DSQL’s serverless model means no cluster management, no capacity planning, and no maintenance windows. The database scales automatically based on workload and is billed based on actual usage (Aurora Capacity Units + I/O operations). In single-region mode, Aurora DSQL already achieves a very high availability SLA; in multi-region active-active mode, architectures with 99.999% availability are possible. The service is particularly suited for globally distributed applications, financial platforms, and e-commerce systems that require low latency across multiple regions.
innFactory supports you in evaluating Aurora DSQL for your use case, adapting your application architecture to optimistic concurrency control, and planning a multi-region strategy on AWS.
Typical Use Cases
Frequently Asked Questions
What is Amazon Aurora DSQL?
Aurora DSQL is a new serverless, distributed SQL database from AWS, introduced at AWS re:Invent 2024. It provides active-active operation across multiple AWS regions simultaneously, PostgreSQL compatibility, and fully serverless scaling without manual sharding or replication configuration.
What distinguishes Aurora DSQL from Aurora Serverless v2?
Aurora Serverless v2 is a single-region service with a primary write node. Aurora DSQL is designed from the ground up for multi-region active-active operation: all regions can execute write operations simultaneously. Aurora DSQL uses optimistic concurrency control instead of classical locking and is specifically built for highly distributed, latency-optimized workloads.
What is Optimistic Concurrency Control (OCC)?
With OCC, database rows are not locked for the duration of a transaction. Instead, the system checks for conflicts at commit time. On conflict, the transaction is aborted and must be retried. This enables very high throughput without deadlocks, but requires conflict-tolerant application logic.
Is Aurora DSQL PostgreSQL compatible?
Yes, Aurora DSQL is PostgreSQL compatible. Existing PostgreSQL drivers, ORMs, and tools work in principle. However, there are limitations: not all PostgreSQL extensions are supported, and the use of SELECT FOR UPDATE or other lock-based patterns must be reviewed in the application architecture.
When should I choose Aurora DSQL over Aurora Global Database?
Aurora Global Database provides multi-region read access with a primary write region, suited for read-intensive workloads. Aurora DSQL enables true active-active writes in multiple regions simultaneously without Global Database routing overhead. For new applications with global distributed write requirements, Aurora DSQL is the more modern choice.