# How Shopify Manages Petabyte Scale MySQL Backup and Restore

DevFeed: [How Shopify Manages Petabyte Scale MySQL Backup and Restore](<https://devfeed.tech/articles/how-shopify-manages-petabyte-scale-mysql-backup-and-restore-1601.md>)

Original publisher: [Read original article](<https://shopify.engineering/shopify-manages-petabyte-scale-mysql-backup-restore>)

Author: Akshay Suryawanshi

Published: 2019-10-01T14:30:00Z

Content type: article

Language: en

Sources: [Shopify Engineering](<https://devfeed.tech/sources/shopify-engineering.md>), [Shopify Engineering - Shopify Engineering](<https://devfeed.tech/sources/shopify-engineering-shopify-engineering.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [Shopify](<https://devfeed.tech/topics/shopify.md>), [Google Cloud Platform (GCP)](<https://devfeed.tech/topics/google-cloud.md>), [cloud-infrastructure](<https://devfeed.tech/topics/cloud-infrastructure.md>), [API](<https://devfeed.tech/topics/api.md>), [Tooling](<https://devfeed.tech/topics/tooling.md>), [Availability](<https://devfeed.tech/topics/availability.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [availability](<https://devfeed.tech/tags/availability.md>), [backup](<https://devfeed.tech/tags/backup.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [cloud-platform](<https://devfeed.tech/tags/cloud-platform.md>), [cloud-storage](<https://devfeed.tech/tags/cloud-storage.md>), [compute](<https://devfeed.tech/tags/compute.md>), [data](<https://devfeed.tech/tags/data.md>), [disaster-recovery](<https://devfeed.tech/tags/disaster-recovery.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [scale](<https://devfeed.tech/tags/scale.md>), [shopify](<https://devfeed.tech/tags/shopify.md>), [tooling](<https://devfeed.tech/tags/tooling.md>)

## AI overview

Shopify redesigned its petabyte-scale MySQL backup and restore system on Google Cloud Platform by replacing file-based backups with Persistent Disk snapshots. The new tooling reduced recovery time from more than six hours per shard to under 30 minutes, while supporting frequent incremental snapshots across regions and Kubernetes-based operations.

## Source excerpt

At Shopify, we need a robust backup and restore solution for our MySQL servers. We used disk-based snapshots to reduced our RTO to under 30 minutes.