PerconaXtraBackup 8.0：无锁数据库热备份解决方案

需积分: 10 174 浏览量更新于2024-07-09 收藏 846KB PDF 举报

"Percona XtraBackup 8.0 文档" Percona XtraBackup 是一个开源的热备份工具，专为基于 MySQL 的服务器设计，在备份过程中不会锁定数据库，确保即使在高负载或低事务量环境下，也能进行无缝的备份操作，而不会影响生产环境中的服务器性能。它提供了商业支持合同，以满足不同用户的需求。该文档覆盖了 Percona XtraBackup 8.0.25-17.0 版本，包含了多个章节，详细介绍了该工具的各个方面： I. 引言：这部分可能包含了关于 Percona XtraBackup 的概述，它的目标、功能以及为什么选择这个工具进行数据库备份。 II. 安装：此部分详细指导如何在不同的操作系统上安装和配置 Percona XtraBackup，包括系统需求和依赖项。 III. 先决条件：列出了在开始使用 Percona XtraBackup 前需要满足的硬件和软件条件，可能包括特定版本的 MySQL 或其变体，以及其他必要的库和组件。 IV. 备份场景：这部分提供了多种备份策略和场景，如全量备份、增量备份和差异备份，以及如何根据不同的业务需求选择合适的备份方案。 V. 用户手册：详尽的用户指南，涵盖了如何使用 Percona XtraBackup 进行数据库备份、恢复、验证备份完整性等操作步骤。 VI. 高级特性：这部分深入讨论了一些高级功能，可能包括压缩备份、并行备份、加密备份等，帮助用户优化备份性能和安全性。 VII. 安全性：介绍如何确保备份过程的安全，包括认证、授权和数据加密等方面，以防止未经授权的访问和数据泄露。 VIII. 教程、食谱、操作指南：提供一系列实例教程和最佳实践，帮助用户更好地理解和应用 Percona XtraBackup。 IX. 参考资料：包含了技术细节、命令行选项、API 参考等，供开发者和高级用户查阅。 X. 指南和索引：提供了文档的完整索引，方便快速查找特定信息。特别需要注意的是，Percona XtraBackup 8.0 支持 InnoDB、XtraDB、MyISAM 和 MyRocks 存储引擎的备份，自版本 8.0.6 开始添加了对 MyRocks 存储引擎的支持。但文档中提到，Percona XtraBackup 8.0 不支持所有特性，用户应根据实际需求评估其兼容性和适用性。这份文档是使用 Percona XtraBackup 进行 MySQL 数据库备份的重要参考资料，无论你是初学者还是经验丰富的管理员，都能从中找到所需的信息。

Percona XtraBackup 8.0 Documentation, Release 8.0.25-17.0

-DWITH_MAN_PAGES To build Percona XtraBackup man pages, use ON or remove this parameter

from the command line (it is ON by default).

To be able to install the man pages, install the python3-sphinx package.

See also:

Step 1: Installing prerequisites

Step 2: Compiling the source code

To compile the source code in your build directory, use the make command.

Important: The computer where you intend to compile Percona XtraBackup 8.0 must have at least 2G of RAM

available.

1. Change to the build directory (created at Step 2: Generating the build pipeline).

2. Run the make command. This command may take a long time to complete.

$ make

Step 3: Installing on the target system

The following command installs all Percona XtraBackup binaries xtrabackup and tests to default location on the

target system: /usr/local/xtrabackup.

Run make install to install Percona XtraBackup to the default location.

$ sudo make install

Installing to a non-default location

You may use the DESTDIR parameter with make install to install Percona XtraBackup to another location. Make

sure that the effective user is able to write to the destination you choose.

$ sudo make DESTDIR=<DIR_NAME> install

In fact, the destination directory is determined by the installation layout (-DINSTALL_LAYOUT) that cmake applies

(see Step 2: Generating the build pipeline). In addition to the installation directory, this parameter controls a number

of other destinations that you can adjust for your system.

By default, this parameter is set to STANDALONE, which implies the installation directory to be /usr/local/

xtrabackup.

See also:

MySQL Documentation: -DINSTALL_LAYOUT

3.3. Compiling and Installing from Source Code 14

Percona XtraBackup 8.0 Documentation, Release 8.0.25-17.0

Step 4: Running

After Percona XtraBackup is installed on your system, you may run it by using the full path to the xtrabackup

command:

$ /usr/local/xtrabackup/bin/xtrabackup

Update your PATH environment variable if you would like to use the command on the command line directly.

$# Setting $PATH on the command line

$ PATH=$PATH:/usr/local/xtrabackup/bin/xtrabackup

$# Run xtrabackup directly

$ xtrabackup

Alternatively, you may consider placing a soft link (using ln -s) to one of the locations listed in your PATH envi-

ronment variable.

See also:

man ln

To view the documentation with man, update the MANPATH variable.

3.4 Running Percona XtraBackup in a Docker container

Docker images of Percona XtraBackup 8.0 are hosted publicly on Docker Hub at https://hub.docker.com/r/percona/

percona-xtradb-cluster/.

For more information about how to use Docker, see the Docker Docs.

Note: Make sure that you are using the latest version of Docker. The ones provided by the operating system package

manager may be outdated and may cause errors.

3.4.1 Running Percona XtraBackup in a Docker container

You may run Percona XtraBackup in a Docker container without having to install it. All required libraries come

already installed in the container.

Being a lightweight execution environment, Docker containers enable creating conﬁgurations where each program

runs in a separate container. You may run Percona Server for MySQL in one container and Percona XtraBackup in

another.

You create a new Docker container based on a Docker image, which works as a template for newly created containers.

Docker images are hosted publicly on Docker Hub at percona/percona-xtrabackup.

$ sudo docker create ... percona/percona-xtrabackup --name xtrabackup ...

Scope of this section

Docker containers offer a range of different options effectively allowing to create quite complex setup. This section

demonstrates how to backup data on a Percona Server for MySQL running in another Docker container.

3.4. Running Percona XtraBackup in a Docker container 15

Percona XtraBackup 8.0 Documentation, Release 8.0.25-17.0

Installing Docker

Your operating system may already provide a package for docker. However, the versions of Docker provided by

your operating system are likely to be outdated.

Use the installation instructions for your operating system available from the Docker site to set up the latest version of

docker.

See also:

Docker Documentation:

• How to use Docker

• Installing

• Getting started

Connecting to a Percona Server for MySQL container

Percona XtraBackup works in combination with a database server. When running a Docker container for Percona

XtraBackup, you can make backups for a database server either installed on the host machine or running in a separate

Docker container.

To set up a database server on a host machine or in Docker container, follow the documentation of the supported

product that you intend to use with Percona XtraBackup.

See also:

Percona Server for MySQL Documentation:

• Installing on a host machine

• Running in a Docker container

$ sudo docker run -d --name percona-server-mysql \

-e MYSQL_ROOT_PASSWORD=root percona/percona-server:8.0

As soon as Percona Server for MySQL runs, add some data to it. Now, you are ready to make backups with Percona

XtraBackup.

Creating a Docker container from Percona XtraBackup image

You can create a Docker container based on Percona XtraBackup image with either docker create or docker

run command. docker create creates a Docker container and makes it available for starting later.

Docker downloads the Percona XtraBackup image from the Docker Hub. If it is not the ﬁrst time you use the selected

image, Docker uses the image available locally.

$ sudo docker create --name percona-xtrabackup --volumes-from percona-server-mysql \

percona/percona-xtrabackup \

xtrabackup --backup --datadir=/var/lib/mysql/ --target-dir=/backup \

--user=root --password=mysql

With --name you give a meaningful name to your new Docker container so that you could easily locate it among

your other containers.

The --volumes-from referring to percona-server-mysql indicates that you indend to use the same data as the

percona-server-mysql container.

3.4. Running Percona XtraBackup in a Docker container 16

剩余145页未读，继续阅读

yutons

粉丝: 0
资源: 10

PerconaXtraBackup 8.0：无锁数据库热备份解决方案

Percona XtraBackup 8.0 Documentation

MySQL8.0备份工具xtrabackup，支持8.0.20版本

percona-xtrabackup-8.0.7 mysql备份工具

percona-xtrabackup-2.4.28 源码安装到centos6.7，请给出详细步骤。注意：该机器已经安装了xtrabackup8.0版本，希望能够版本共存。

centos7安装xtrabackup8.0

percona-xtrabackup-80 is already the newest version (8.0.33-27-1.focal). 0 upgraded, 0 newly installed, 0 to remove and 100 not upgraded.

xtrabackup mysql8.0备份

使用xtrabackup --copy-back --target-dir=/bk/ 命令时出现错误[ERROR] [MY-011825] [Xtrabackup] datadir must be specified

使用 yum remove xtrabackup 卸载xtrabackup-2.4时候，出现Loaded plugins: fastestmirror No Match for argument: xtrabackup No Packages marked for removal

percona-xtrabackup-80-8.0.27-19.1.el7.x86_64.rpm

最新资源