Identify the challenges of maintaining ID sequences across shards
When sharding tables horizontally, we need a way to maintain uniqueness of certain IDs (e.g primary keys). Doing so an prove challenging, especially in a setup where shards can be added at any point in time.
We need to look into the challenges and options for maintaining IDs across shards, and if we perhaps need an entirely different approach (e.g. UUIDs).
Conclusion: it should be possible to implement a distributed ID sequence: #329300 (comment 562872192)
Edited by Yorick Peterse