Design a distributed URL shortening service similar to TinyURL or Bitly. The system must handle 100 million write requests per second with low latency. Detail your choice of database (SQL vs. NoSQL), sharding strategy, caching layer (e.g., Redis configuration), and load balancing approach. Specifically address how you will handle hash collisions, guarantee uniqueness, and manage read/write consistency across distributed nodes.