Cloud Masters Episode #124
Amazon Aurora Distributed SQL (DSQL): How it works and when Aurora DSQL makes sense for your workloads
Learn when Amazon Aurora DSQL is the right choice for your applications, what changes you’ll need to make during migration, and how to handle its unique approach to optimistic locking.
Cloud Masters Episode #124

With DoiT Spot Scaling, automate your AWS Spot Instances to save up to 90% on compute spend without compromising reliability.

Cloud Masters
Cloud Masters
Amazon Aurora Distributed SQL (DSQL): How it works and when Aurora DSQL makes sense for your workloads
Loading
/
Cloud Masters
Cloud Masters
Amazon Aurora Distributed SQL (DSQL): How it works and when Aurora DSQL makes sense for your workloads
Loading
/

Episode notes

Key Moments

00:00: Intro
00:41: Aurora DSQL vs. standard Aurora
01:45: Transaction isolation and microVM architecture
04:43: DSQL vs. Aurora Limitless
05:54: Optimistic locking
07:50: Conflict handling w/optimistic locking
09:02: Transaction retries with Aurora DSQL
11:01: Optimistic locking vs. pessimistic locking
13:10: Re-architecting for Aurora DSQL
15:55: Foreign keys and referential integrity tradeoffs
19:31: Flexibility advantages over DynamoDB
22:36: Database migration considerations
25:01: Aurora dSQL migration steps
28:25: AWS release strategy and future updates

About the guests

Kate Gawron
Kate is a Senior Database Cloud Architect at DoiT International with over 20 years experience working with AWS and Oracle databases. A published author of “AWS Database Specialty Exam Guide” and online “Practical Oracle Database Security” courses, Kate helps companies refactor their databases to work optimally with AWS and Google Cloud.
Kate is a Senior Database Cloud Architect at DoiT International with over 20 years experience working with AWS and Oracle databases. A published author of “AWS Database Specialty Exam Guide” and online “Practical Oracle Database Security” courses, Kate helps companies refactor their databases to work optimally with AWS and Google Cloud.

Related content

Amazon Aurora Deep Dive: Design, migration from RDS, and cost optimization
Covering when to use Aurora vs. RDS, common challenges when optimizing Aurora after migrating from RDS, I/O optimization and when I/O-optimized makes sense, and how to architect your Aurora databases for cost optimization.
Watch now
So, you heard about Aurora DSQL: How does it work, and will it actually work for you?
Discover how Amazon Aurora DSQL works and if it fits your needs. Learn about its distributed architecture, ideal data patterns, and how it revolutionizes traditional database limitations.
Read more
Mastering EOL Migrations: Lessons learned from MySQL 5.7 to 8.0 with RDS managed services
Learn how to properly upgrade your RDS AWS MySQL databases from 5.7 to 8.0, and lessons you can apply to successfully navigate any EOL migration.
Watch now
Let’s do it

From cost optimization to cloud migration, machine learning and CloudOps,
we’re here to make the public cloud easy.

From cost optimization to cloud migration, machine learning and CloudOps, we’re here to make the public cloud easy.

Ready to get started?

Get in touch

Company

Offering

Support

Never miss an update.

Subscribe to updates, news and more.

Schedule a call with our team

You will receive a calendar invite to the email address provided below for a 15-minute call with one of our team members to discuss your needs.

You will be presented with date and time options on the next step