Loading...
Writes: 100M / 86400 = 1.2k writes/sec avg
Reads: 10B / 86400 = 115 reads/sec avg
Storage over 5 years: 100M urls/day x 362 = 36.5B urls/year x 5 x 500 bytes = 91TB of raw data
Reads dominate. We should not have a single database, so we should have multiple read replicas with a load balancer between the cliente and the server
Define the data model. Identify the main entities, their attributes, and relationships. Consider the choice of database type (SQL vs NoSQL) and justify your decision based on access patterns...
Deep dive into 2-3 key components. Explain how they work, how they scale, discuss tradeoffs, capacity, and any relevant algorithms or data structures.