How Shopify Manages Petabyte Scale MySQL Backup and Restore - Shopify

This post details the migration from Percona Xtrabackup to GCP's Persistent Disk (PD) snapshot feature for MySQL backups. It describes the implementation of a new backup tooling using Kubernetes CronJobs for frequent snapshots (every 15 minutes), a retention policy framework for managing snapshot storage costs, and a verification process to ensure data integrity by restoring and checking daily snapshots. It also outlines the process for offsite backup storage by exporting snapshots and archiving them. The new system reduces RTO to under 30 minutes.