Opens in a new windowOpens an external siteOpens an external site in a new window Shopify’s infrastructure supports millions of merchants during their entrepreneurship journey. A key component of the current infrastructure is the underlying fleet of MySQL database shards that together persist every shop’s critical data. As traffic patterns change and new merchants onboard onto the platform, it’s p
![Shard Balancing: Moving Shops Confidently with Zero-Downtime at Terabyte-scale](https://cdn-ak-scissors.b.st-hatena.com/image/square/769ff3ba70eceea207735e7bf671350589ecda62/height=288;version=1;width=512/https%3A%2F%2Fcdn.shopify.com%2Fs%2Ffiles%2F1%2F0779%2F4361%2Farticles%2FShopifyEng_BlogIllustrations_210913_72ppi_01_ShardBalancingMovingShops.jpg%3Fv%3D1634153777)