Decision#d1
Catalogue / shopify-2021-mysql-shard-balancing
Shopify rebalances podded MySQL shards online by moving individual shops with Ghostferry and Redis MRSW locks
Shopify, 2021. Podded MySQL database shard balancing.
Records
Decision#d2
Plan shard rebalancing from historical utilization cohorts and pre-move simulations rather than shop counts
Decision#d3
Guard online shop migration with SELECT FOR UPDATE batch locking, Redis MRSW cutover locks, verifiers and TLA+
Sign in to read what was chosen, what was rejected and what it cost, each with its place in the source. An account is free.