Scalable Multi-tenant Platforms at Loom and at Times скачать в хорошем качестве

Scalable Multi-tenant Platforms at Loom and at Times

Shayon wrote a great blog post on the guiding principles he and his team at Loom used to guide them as they evolved Loom's data platform through a period of hypergrowth. I invited Shayon to the show to discuss the challenges he encountered and how he solved them - and I learned that he is now at Tines - solving an entirely new set of challenges with a very different set of solutions. We discuss the fundamental principles that help Shayon make critical decisions when building and scaling his platforms. We also discuss what happens when JSON columns become too large, how to prioritize performance improvement projects, what to do when a tenant gets noisy, and how his team performs zero downtime upgrades. Shayon's blog: https://www.loom.com/blog/scale-engin... Shayon's personal site: https://www.shayon.dev/about/ 00:00 Intro 00:45 Loom Data Architecture 05:28 Postgres on K8s? 08:10 First guiding principles 09:24 What happens when a video goes viral? 10:54 Starting to scale 13:10 Optimizing the DB 18:00 How to prioritize DB performance projects? 22:50 Applying lessons from Loom to Tines 26:33 First challenge at Tines - Data isolation between tenants 31:00 Extracting noisy tenants to dedicated stack 34:00 How does Tines move tenants around? 35:30 Architecture that supports multi-tenant and dedicated stack 38:00 Zero downtime upgrades 44:40 Advice for building a new SaaS