Concurrency control in Amazon Aurora DSQL
Database Blog
The article discusses concurrency control in Amazon Aurora DSQL, focusing on optimistic concurrency control (OCC) and its benefits in distributed database systems.
- OCC allows transactions to proceed without locking resources, checking for conflicts only at commit time
- Ideal for low-contention environments and distributed systems with scalable key ranges
- Provides better performance and resilience compared to pessimistic concurrency control (PCC)
- Enables multi-Region active-active availability with lower latency
- Supports strong snapshot isolation equivalent to repeatable read isolation
Key recommendations include designing transactions that can be retried, implementing timeout logic, using exponential backoff and jitter, and keeping transaction scopes small to minimize concurrency collisions.
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.