AWS has unveiled its Amazon Aurora DSQL distributed SQL database service, emphasizing high reliability and multi-region distribution to significantly reduce the risk of system failure. Despite its ability to distribute across regions, it maintains features akin to traditional databases, particularly consistency, ensuring data integrity with complete ACID compliance.
DSQL separates query processing from transaction logging, focusing clearly on the sequence of each transaction’s time rather than verifying if a transaction has been logged. This approach allows for concurrent transaction processing across all machines without the need for constant syncing, provided that the time on all servers align precisely. AWS utilizes the Amazon Time Sync Service to synchronize time values from satellites with server clocks globally, minimizing discrepancies to the microsecond level.
While DSQL excels in cross-regional distribution, it also supports single-region deployment for added reliability, enabling full utilization of active-active cluster configurations. Unlike the previous Amazon Aurora Global Database setup where system failures required promoting standby servers to primary roles, the new DSQL service ensures seamless operation in any scenario.
Source: Business Wire, AWS Blog
TLDR: AWS introduces Amazon Aurora DSQL, a distributed SQL database service with high reliability and multi-region distribution capabilities, ensuring data consistency and ACID compliance. DSQL separates query processing from transaction logging, facilitating concurrent transaction processing across machines. The service supports both cross-regional and single-region deployments, enhancing system reliability and enabling active-active cluster configurations without server promotion in case of failures.
Leave a Comment