[On-site] Implement a URL shortening service similar to tiny URL. Provide DB schema, software architecture. How would you optimize the system? What are some points of failures? How would you scale? [leads to having multiple hosts] How would keep all of the hosts in sync?