Design a Real-Time Leaderboard - Most Frequently Asked Question in Meta

Chapters 0:00 Introduction 4:30 Requirements 9:01 High Level Design 1 - Ingest & Update Player Scores 13:58 High Level Design 2 - View My Global Rank & K Neighbors 17:39 High Level Design 3 - View K Friends Around Me 21:30 High Level Design 4 - View Top-N Leaderboards (Global/Regional/Time-Windowed) 24:16 Deep Dive 1 - How to Maintain a Global Leaderboard at Billion Updates/Day Without a Hot Shard 36:04 Deep Dive 2 - How to Fetch K-Neighbors Around a User (Global + Friends) Fast 40:32 Deep Dive 3 - How to Handle Hotspots at the Top & Celebrity Users 45:59 Deep Dive 4 - How to Recover from Cache / Ranking Loss 50:02 Recap If you would like to book a 90 mins coach session with me: https://www.showoffer.io/book/author?... Explore more well documented system design questions on our website: https://www.showoffer.io/learn/system... About us: ShowOffer team is formed by group of FANNG+ engineering leaders to help up-level your next interviews. We provide one-on-one coach service as well as mocking sessions. Thank you and good luck to your next interview!