How Canva Solves the Dual Write Problem in Centralized Authorization Systems

Описание: Artie Shevchenko, software engineer at Canva does a technical deep dive on solving the complexities of the dual write problem when using SpiceDB in production.

This was originally aired at the AuthZed is Five Event: https://www.youtube.com/live/uz_gxz3w...

00:00 Introduction to the Dual Right Problem
00:22 Challenges in a Centralized Authorization System
01:57 Understanding Replication and Inconsistencies
05:11 Defining the Dual Write Problem
06:46 Exploring Workarounds and Their Limitations
11:53 Approaches to Solving the Dual Right Problem
12:25 Option 1 - Cron Sync Jobs and Their Effectiveness
14:31 Transactional Outbox Pattern
16:03 Option 2 - Micro Syncs: A Targeted Approach
18:23 Conditional Writes and Version Fields
19:32 Option 3 - Transactional Outbox and version precondition
22:25 Summary and Final Thoughts

Check out SpiceDB for your fine-grained authorization needs.
SpiceDB is free and open source: https://github.com/authzed/spicedb