How-tos and Recipes

Recipes for innobackupex

• Make a Local Full Backup (Create, Prepare and Restore)

• Make a Streaming Backup

• Making an Incremental Backup

• Making a Compressed Backup

• Backing Up and Restoring Individual Partitions

Recipes for xtrabackup

• Making a Full Backup

• Making an Incremental Backup

• Restoring the Backup

How-Tos

• How to setup a replica for replication in 6 simple steps with Percona XtraBackup

• Verifying Backups with replication and pt-checksum

• How to create a new (or repair a broken) GTID based slave

Auxiliary Guides

• Enabling the server to communicate via TCP/IP

• Privileges and Permissions for Users

• Installing and configuring a SSH server

Assumptions in this section

The context should make the recipe or tutorial understandable. To assure that this is true, a list of the assumptions, names and other objects that appears in this section. This items are specified at the beginning of each recipe or tutorial.

HOST

A system with a MySQL-based server installed, configured and running. We assume the following about this system:

• The MySQL server is able to communicate with others by the standard TCP/IP port;

• An SSH server is installed and configured - see here if it is not;

• You have an user account in the system with the appropriate permissions

• You have a MySQL’s user account with appropriate Connection and Privileges Needed.

USER

This is a user account with shell access and the appropriate permissions for the task. A guide for checking them is here.

DB-USER

This is a user account in the database server with the appropriate privileges for the task. A guide for checking them is here.

Contact us

For free technical help, visit the Percona Community Forum.

To report bugs or submit feature requests, open a JIRA ticket.

For paid support and managed or consulting services , contact Percona Sales.

---

Last update: 2022-07-19