PostgreSQL player data sharding with zero downtime migration and topology changes

PostgreSQL based solution to player data sharding. Optimized for frequent writes and supporting a modular schema-less data scheme this architectures supported migrations and topology changes with 0 down time.

The details are not public but it used unique hashed keys per bucket with a logical and physical topologically aware modulo system to find the appropriate shard and retrieve data.

The data scheme was robust and used optimistic locking to deal with multiple updates.

Employer: Motiga