How Shopmonkey built a geo aware automotive care platform with CockroachDB | RoachFest 2023

Description

When Shopmonkey rebuilt their auto shop management software from the ground up, providing fast and highly available access to their software from thousands of physical shop locations throughout North America was their number one priority. Distributed SQL database CockroachDB’s multi-region capabilities, which provide fast access from geo-distributed locations, was at the foundation of this initiative. Migrating data from MongoDB to CockroachDB cluster was only one part of this journey. They also had to rearchitect our monolithic application to take advantage of these new capabilities. This talk by Shopmonkey's CTO Jeff Haynie discusses the compelling reasons why they moved their core business to CockroachDB and what architectural innovations were implemented to take advantage of CockroachDB’s unique multi-region capabilities. How Shopmonkey built a geo aware automotive care platform with CockroachDB | RoachFest 2023 00:00 Welcome and Introduction 00:26 What is Shopmonkey? 01:38 Shopmonkey's software architecture before CockroachDB 02:58 Why Shopmonkey chose CockroachDB 03:20 Using multi-region managed CockroachDB 03:46 Architecture for a multi-region database 04:55 Using global tables in CockroachDB 05:45 Why adding crdb_region to where clauses can be critical for performance 06:58 Routing data in CockroachDB with geo aware global load balancers and a location aware service mesh 08:26 How Shopmonkey's custom connection pooler handles prepared statement caching, pooling, and intelligent caching 09:46 How Shopmonkey uses changefeeds (CDC) 11:17 Performing real-time, online migrations 13:05 Inside Shopmonkey's dev environments 14:17 Tracing and logging 16:11 Closing notes #distributedsql #cockroachdb