AWS announces Aurora DSQL, a new distributed SQL database that promises virtually unlimited scalability
At its re:Invent conference, Amazon’s AWS cloud computing unit today announced Amazon Aurora DSQL, a new serverless, distributed SQL database that promises high availability (99.999% for multi-region availability), strong consistency, PostgreSQL compatibility, and, the company says, “4x faster reads and writes compared to other popular distributed SQL databases.”
Interestingly, AWS stresses that there is no database sharding involved here to scale the service — and that it can scale reads and writes independently. The company also highlights that Aurora DSQL will offer strong consistency, ensuring that if users opt for a multiregion approach, all regions will always show the same data at the same time.
AWS notes that to ensure resiliency, Aurora DSQL uses an active-active architecture, meaning there is always a standby server ready to take over, which guarantees “that a customer’s application is always available by enabling an application to read and write to any Aurora DSQL endpoint.” Since this is a fully managed service, AWS handles all of the security updates and manages the overall infrastructure.
To make all of this happen, the AWS team says it had to “reinvent relational database transaction processing.” Typically, ensuring strong consistency across multiple regions and having those globally distributed servers sync with what AWS describes as “microsecond accuracy” is a rather difficult feat to achieve. AWS says it can do this because it decoupled the transaction processing from the storage. Traditional methods, the company explains, would be bottlenecked by having to pass information back and forth multiple times. Aurora, however, only checks each transaction when it’s time to commit the changes and then, when the commit happens, it parallelizes those writes across regions.
