Cache Coherence and the Dual-Write Problem | Architectural Simplification

Description

In this episode of Architectural Simplification, Cockroach Labs Technical Evangelist Rob Reid takes a look at the dual-write problem through the lens of cache coherence (or cache incoherence). Watch his demo to learn about the limitations of caching including ruined ACID guarantees and to see why distributed SQL database CockroachDB provides advantages including: ✔️ The ability to scale reads & writes ✔️ Removed dual-write problems ✔️ ACID guarantees ✔️ Simpler application architecture Cache Coherence and the Dual-Write Problem | Architectural Simplification 00:00 Introduction / Architectural diagrams 00:33 The Before scenario workflow 00:53 The After scenario workflow 01:02 The compose files and code for our Before / After scenarios 02:49 Running the Before test 03:45 "Writes to either system, the database or the cache will eventually fail" 04:26 Running the After test 05:01 The problems with having a cache in your system 05:12 The benefits of having one source of truth Additional resources ✔️ What is CockroachDB? https://cockroa.ch/42uaZ9G ✔️ CockroachDB architecture overview: https://cockroa.ch/3RzIvrh ✔️ Message queuing and the database: Solving the dual write problem: https://cockroa.ch/43iPQ2J