Riskified’s lessons learned migrating to CockroachDB for greater scale | RoachFest 24
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
