xtrabackup-recipes

Automate XtraBackup backup and restore workflows for Percona Server/MySQL clusters.

1|1|Updated May 29, 2026

Search Tags:#restore #backup #replication #mysql #pitr #xtrabackup #pxb

Ready to run

npx skills add https://github.com/Percona-Lab/skills --skill xtrabackup-recipes

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xtrabackup-recipes
Source: https://github.com/Percona-Lab/skills/tree/main/xtrabackup-recipes
Command: npx skills add https://github.com/Percona-Lab/skills --skill xtrabackup-recipes

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides practical, recipe-driven guidance for performing reliable Percona XtraBackup backups and restores, reducing risk and manual errors.

Core Features & Use Cases

Full backups with proper grants and preparation steps to ensure restorable datacenters.
Incremental chains with prepare --apply-log-only for efficient backup maintenance.
PITR, streaming, and replica rebuild workflows to recover data quickly and bootstrap new nodes.

Quick Start

Follow the full backup/prepare/restore recipes to perform a complete backup cycle.

Frequently Asked Questions about xtrabackup-recipes

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I perform a full MySQL backup and restore using XtraBackup?▼

A full MySQL backup and restore using XtraBackup follows a three-step process: --backup to capture the data, --prepare to apply logs, and --copy-back to restore it. This Skill enforces proper backup privileges and verifies server-version pairing to ensure restorable data.

What is the best way to manage incremental backups for Percona Server?▼

The best way to manage incremental backups for Percona Server is by creating incremental chains and applying the --prepare --apply-log-only step. This approach efficiently maintains backup data and reduces manual errors during recovery workflows.

Can I use XtraBackup for point-in-time recovery (PITR) across MySQL clusters?▼

Yes, you can use XtraBackup for point-in-time recovery (PITR) across Percona Server and MySQL clusters. This Skill provides recipe-driven guidance for PITR, streaming, and replica rebuild workflows to recover data quickly and bootstrap new nodes.

Why does my XtraBackup restore fail due to privileges or server version?▼

An XtraBackup restore often fails due to mismatched server versions or insufficient backup privileges. This Skill verifies server-version pairing and enforces proper backup grants before executing backup and restore workflows to prevent these errors.

Do I need specific grants to run XtraBackup backup and restore workflows?▼

Yes, you need specific backup privileges to run XtraBackup workflows reliably. This Skill enforces proper backup grants and guides you through the backup, prepare, and copy-back steps with safeguards to reduce manual errors.

How do I bootstrap a new MySQL replica node from an existing XtraBackup?▼

To bootstrap a new MySQL replica node, use the XtraBackup streaming and replica rebuild workflows provided by this Skill. These recipes guide you through preparing the backup and copying it to bootstrap new nodes in Percona Server or MySQL clusters efficiently.