This blog post by Marc Brooker, an AWS engineer, explains the write operations within Aurora DSQL, a scalable SQL database. It details how Aurora DSQL uses optimistic concurrency control (OCC) combined with multiversion concurrency control (MVCC) to achieve strong consistency and snapshot isolation. The system uses an "adjudicator" service to manage write conflicts and a "Journal" for durable, ordered data replication. The author highlights the benefits of this approach for scalability, availability, and performance, emphasising the avoidance of locking. Finally, the post touches upon the system's consistency guarantees and the importance of schema design to minimise write conflicts.

Ver todos los episodios