This chapter explores the decision-making process behind implementing transactions in a horizontally sharded database system at Figma. It discusses the tactical classification of transactions based on risk levels, the implementation of a shadow setup to simulate sharding, and the complexities of query execution and management of shard keys. The chapter also delves into the impact of database scaling on application developers, including optimizations for query performance and meticulous data migration strategies.
Sammy Steele is a Senior Staff Engineer at Figma, and the tech lead for their databases team. She previously worked at Dropbox, where she built out their petabyte-scale metadata storage and search systems.
Sammy recently published a blog called “How Figma’s databases team lived to tell the scale”. The blog went viral and made it to the top of Hacker News. We invited Sammy on the podcast to learn more, and she is our guest today.
Check out Figma Config at https://config.figma.com/.
Sean’s been an academic, startup founder, and Googler. He has published works covering a wide range of topics from information visualization to quantum computing. Currently, Sean is Head of Marketing and Developer Relations at Skyflow and host of the podcast Partially Redacted, a podcast about privacy and security engineering. You can connect with Sean on Twitter @seanfalconer .
The post Database Scaling at Figma with Sammy Steele appeared first on Software Engineering Daily.