Troubleshooting problems with DSQL auth In this article, we'll look at some of the common ways folks get tripped up configuring their clients and credentials. Before continuing, I recommend reading Aurora DSQL: How authentication and authorization works , which should give you a robust mental model of how things work end to end.
Aurora DSQL: The Adjudicator This article is about an internal component of the Aurora DSQL architecture that we call the Adjudicator. I'd recommend reading at least my article on the Circle of Life or Marc Brooker's blog on Transactions and Durability before continuing with this one. Unlike other distributed databases, DSQL fully decouples reads and writes. In order to commit a transaction, we…
Aurora DSQL: Meet Coupler AKA: CDC streaming in Aurora DSQL. From the Circle of Life :
Aurora DSQL: Pushdown Compute Engine In the DSQL architecture, the PostgreSQL-based query processor (QP) does not run on the same physical machine as the storage engine. Disaggregated storage is not a new concept for relational databases. Aurora PostgreSQL looks like this: #+begin src ditaa :file images/disagg-storage.png :noeval ------------ /--------\ /------+ | {s} |
DSQL sucks at TPC-B Recently Kate Gowron from DoiT published Comparing Aurora DSQL vs. Aurora Serverless v2: A Practical Cost Analysis on Medium. I don't know Kate personally, but I was quite excited when this article came out. When we announced the Preview of Aurora DSQL at re:Invent last year, Kate and team made a fantastic video on the DoiT YouTube channel:
DSQL sucks at TPC-B This page is a redirect to dsql-tpcb.html because I can't spell.
Aurora DSQL scales to zero The Amazon Aurora DSQL landing page leads with: Amazon Aurora DSQL is the fastest serverless distributed SQL database for always available applications. Aurora DSQL offers the fastest multi-Region reads and writes. It makes it effortless for customers to scale to meet any workload demand with zero infrastructure management and zero downtime maintenance.
Aurora DSQL Best Practices: Avoid hot keys In the Circle of Life , I describe the flow of data in Aurora DSQL. Data flows from the Query Processor (QP), through the journal, and into storage. Once in storage, it can be queried by future transactions.
Aurora DSQL: How to spend a dollar From Amazon Aurora DSQL pricing : Aurora DSQL measures all request-based activity, such as query processing, reads, and writes, using a single normalized billing unit called Distributed Processing Unit (DPU). Storage is billed based on the total size of your database, measured in GB-month. Aurora DSQL ensures your data is available and strongly consistent across…
Aurora DSQL and the Circle of Life #+begin src ditaa :file images/circle0.png :noeval ------------ reads | {s} | apply changes ---->| Storage |<---- ------------ /--------\ /------+ |
How direct TLS can speed up your connections A few months ago, one of my Aurora DSQL teammates reported a curious finding. When connecting to their DSQL clusters using the corporate VPN, their connections were fast and snappy - as they should be! But, when connecting without using the VPN , their connections were taking around 3 seconds. Curiously, this was only happening when in the AWS offices.…
Aurora DSQL: How authentication and authorization works In this article, I'm going to explain how connections to Aurora DSQL are authenticated and authorized. This information is meant to be supplemental to what is found in the official Amazon Aurora DSQL documentation. This is a "nuts and bolts" explanation, rather than a "how to" guide. After reading this article you should understand: