skills.rest
Percona-Lab
Percona-LabOFFICIAL
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/Percona-Lab/skills --skill xtrabackup-recipes
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
BermudaLocalsBermudaLocals
1

minecraft-modpack-server

Automate modded Minecraft server setup from CurseForge/Modrinth packs.

Community
Advanced
celticht32celticht32
4

couchbase-xdcr

Designs and operates Couchbase XDCR replication between clusters for multi-region synchronization and disaster recovery.

Community
Advanced
apecloudapecloud
3

kubeblocks-engine-postgresql

Provision PostgreSQL clusters on KubeBlocks with topology, version, storage, and sizing.

Official
Advanced
rnavarychrnavarych
14

role-database:backup-recovery

Plan database backup and disaster recovery across PostgreSQL, MySQL, MongoDB, and Redis.

Community
Advanced