Partitions, Keys, and Ordering

Go deep on Partitions, Keys, and Ordering: edge cases, scalability limits, and how you'd evolve the solution over 2 years.

Answers use simple, clear English.