System Design Drill Day 14: URL Shortener and Unique ID Generation
How to design a URL shortener: base62 codes, ID generation strategies, 301 vs 302 redirects, Redis caching and async click analytics.
#mysql
Posts tagged #mysql
System Design Drill Day 11: The Transactional Outbox Pattern
Why writing to the database and pushing to a queue can't be atomic, and how a transactional outbox fixes lost and phantom events.
System Design Drill Day 6: Sharding and Partitioning a MySQL Orders Table
How to split a MySQL orders table across shards: choosing a shard key, routing with logical shards, keeping reports off the shards and resharding.
System Design Drill Day 4: Read Replicas and Replication Lag
How MySQL read replicas scale reads, why replication lag breaks read-your-writes, and how to handle it in Laravel.
