Riskified’s lessons learned migrating to CockroachDB for greater scale | RoachFest 24

Description

Riskified provides an all-in-one fraud prevention and chargeback protection solution for 750+ e-commerce merchants. The company’s core Chargeback Guarantee application was built on PostgreSQL which wasn’t able to keep up with Riskified’s growth requirements and the company is in the process of migrating to CockroachDB. In this session, Data Platform Engineering Team Lead Harel Safra and Senior Data Platform Engineer Yoav Shemesh discuss Riskified’s migration strategy from PostgreSQL to CockroachDB and share lessons learned. Riskified’s lessons learned migrating to CockroachDB for greater scale | RoachFest 24 00:00 Introduction and agenda 00:58 What does Riskified do? 01:36 Behind Riskified's data platform 02:46 The problems with PostgreSQL 05:25 Riskified's test criteria for a database 06:43 YugabyteDB vs CockroachDB 08:16 Implementation details for CockroachDB 09:18 The importance of easy management 10:22 The benefits of automatic deployments 11:24 Managing with Terraform 11:54 Rolling restarts / Monitoring & Backup 12:38 Migrations with AWS DMS and Replicator 14:29 Database migration tips for CockroachDB 17:34 CockroachDB migration tips: Changefeeds 18:41 Clients & SDKs: Ruby 20:33 Node & ORM type 21:07 Closing notes 21:47 Q&A