Design the backend architecture for a real-time social media application serving 100 million concurrent users. Justify your choice of data partitioning strategy (sharding) and consistency model (strong vs. eventual). Explain how you handle 'thundering herd' problems and database write bottlenecks without relying on external cloud provider magic, focusing on the underlying algorithms and data structures.