logo资料库

Percona XtraBackup 8.0.13 文档.pdf

发布时间：2022-06-24 发布人：admin 分类：说明书 资料大小：0.59M 资料格式：pdf 举报 版权申诉
第1页 / 共127页
第2页 / 共127页
第3页 / 共127页
第4页 / 共127页
第5页 / 共127页
第6页 / 共127页
第7页 / 共127页
第8页 / 共127页
资料共127页，剩余部分请下载后查看
    I Introduction
    II Installation
    III Prerequisites
    IV Backup Scenarios
    V User's Manual
    VI Advanced Features
    VII Tutorials, Recipes, How-tos
    VIII References
    IX Indices and tables
    Percona XtraBackup 8.0 Documentation Release 8.0.13 Percona LLC and/or its affiliates Jun 17, 2020
    I Introduction II Installation III Prerequisites IV Backup Scenarios V User’s Manual VI Advanced Features VII Tutorials, Recipes, How-tos VIII References IX Indices and tables CONTENTS 2 9 16 20 30 73 82 99 119 i
    Percona XtraBackup 8.0 Documentation, Release 8.0.13 Percona XtraBackup is an open-source hot backup utility for MySQL - based servers that doesn’t lock your database during the backup. Whether it is a 24x7 highly loaded server or a low-transaction-volume environment, Percona XtraBackup is designed to make backups a seamless procedure without disrupting the performance of the server in a production environment. Commercial support contracts are available. Percona XtraBackup can back up data from InnoDB, XtraDB, MyISAM, and MyRocks tables on MySQL 8.0 servers as well as Percona Server for MySQL with XtraDB, Percona Server for MySQL 8.0, and Percona XtraDB Cluster 8.0. Important: The support of the MyRocks storage engine was added in version 8.0.6. Percona XtraBackup 8.0 does not support the TokuDB storage engine. See also: Percona TokuBackup https://www.percona.com/doc/percona-server/LATEST/tokudb/toku_backup.html Percona XtraBackup 8.0 does not support making backups of databases created in versions prior to 8.0 of MySQL, Percona Server for MySQL or Percona XtraDB Cluster. As the changes that MySQL 8.0 introduced in data dictionar- ies, redo log and undo log are incompatible with previous versions, it is currently impossible for Percona XtraBackup 8.0 to also support versions prior to 8.0. Due to changes in MySQL 8.0.20 released by Oracle at the end of April 2020, Percona XtraBackup 8.0, up to version 8.0.11, is not compatible with MySQL version 8.0.20 or higher, or Percona products that are based on it: Percona Server for MySQL and Percona XtraDB Cluster. For more information, see Percona XtraBackup 8.x and MySQL 8.0.20 For a high-level overview of many of its advanced features, including a feature comparison, please see About Percona XtraBackup. CONTENTS 1
    Part I Introduction 2
    CHAPTER ONE ABOUT PERCONA XTRABACKUP Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits: • Backups that complete quickly and reliably • Uninterrupted transaction processing during backups • Savings on disk space and network bandwidth • Automatic backup verification • Higher uptime due to faster restore time Percona XtraBackup makes MySQL hot backups for all versions of Percona Server for MySQL, and MySQL. It per- forms streaming, compressed, and incremental MySQL backups. Important: With the introduction of Percona XtraBackup 8.0, Percona XtraBackup 2.4 will continue to support MySQL and Percona Server 5.6 and 5.7 databases. Due to the new MySQL redo log and data dictionary formats the Percona XtraBackup 8.0.x versions will only be compatible with MySQL 8.0.x and the upcoming Percona Server for MySQL 8.0.x Percona’s enterprise-grade commercial MySQL Support contracts include support for Percona XtraBackup. We rec- ommend support for critical production deployments. Supported storage engines Percona XtraBackup works with MySQL and Percona Server for MySQL. It supports completely non-blocking backups of InnoDB, XtraDB, and MyRocks storage engines. In addition, it can back up the following storage engines by briefly pausing writes at the end of the backup: MyISAM, Merge, and Archive, including partitioned tables, triggers, and database options. Important: The support of the MyRocks storage engine was added in version 8.0.6. Percona XtraBackup 8.0 does not support the TokuDB storage engine. See also: Percona TokuBackup https://www.percona.com/doc/percona-server/LATEST/tokudb/toku_backup.html 3
    Percona XtraBackup 8.0 Documentation, Release 8.0.13 MySQL Backup Tool Feature Comparison 1.1. MySQL Backup Tool Feature Comparison 4
    Percona XtraBackup 8.0 Documentation, Release 8.0.13 Features License Price Percona XtraBackup GPL Free Streaming and encryption formats Supported MySQL flavors Supported operating systems Non-blocking InnoDB backups1 Blocking MyISAM backups Incremental backups Full compressed backups Incremental compressed backups Fast incremental backups2 Incremental backups with archived logs feature in Percona Server Incremental backups with REDO log only Backup locks7 Encrypted backups Streaming backups Parallel local backups Parallel compression Parallel encryption Parallel apply-log Parallel copy-back Partial backups Partial backups of individual parti- tions Throttling4 Backup image validation Point-in-time recovery support Safe slave backups Compact backups5 Buffer pool state backups Individual tables export Individual partitions export Restoring tables server Data & index file statistics InnoDB secondary indexes defrag- mentation rsync support to minimize lock time Improved FTWRL handling Backup history table Backup progress table Offline backups Backup to tape media managers to a different Open source MySQL, MySQL, Percona XtraDB Cluster, Linux Percona Server for (LOCK TABLE FOR Yes Yes Yes Yes Yes Yes Yes Yes BACKUP) Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes MySQL Enterprise backup Proprietary Included in subscription at $5000 per Server Proprietary MySQL Linux, Solaris, Windows, OSX, FreeBSD. Yes Yes Yes Yes Yes (LOCK INSTANCE FOR Yes BACKUP) Yes3 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes6 Yes Yes Yes Yes Yes 1.1. MySQL Backup Tool Feature Comparison 5 Continued on next page
    Percona XtraBackup 8.0 Documentation, Release 8.0.13 Table 1.1 – continued from previous page Features Cloud backups support External graphical user interfaces to backup/recovery Percona XtraBackup Zmanda Recovery Manager MySQL for MySQL Enterprise backup Amazon S3 MySQL Workbench, MySQL En- terprise Monitor What are the features of Percona XtraBackup? Here is a short list of Percona XtraBackup features. See the documentation for more. • Create hot InnoDB backups without pausing your database • Make incremental backups of MySQL • Stream compressed MySQL backups to another server • Move tables between MySQL servers on-line • Create new MySQL replication slaves easily • Backup MySQL without adding load to the server 1 InnoDB tables are still locked while copying non-InnoDB data. 2 Fast incremental backups are supported for Percona Server for MySQL with XtraDB changed page tracking enabled. 7 Backup locks is a lightweight alternative to FLUSH TABLES WITH READ LOCK available in Percona Server for MySQL. Percona Xtra- Backup uses them automatically to copy non-InnoDB data to avoid blocking DML queries that modify InnoDB tables. For more information see How Percona XtraBackup Works 3 Percona XtraBackup supports encryption with any kinds of backups. MySQL Enterprise Backup only supports encryption for single-file 6 Percona XtraBackup can export individual tables even from a full backup, regardless of the InnoDB version. MySQL Enterprise Backup uses InnoDB 5.6 transportable tablespaces only when performing a partial backup. 1.2. What are the features of Percona XtraBackup? 6 backups. sleep time between operations. unused pages and reinserts on the prepare stage. 4 Percona XtraBackup performs throttling based on the number of IO operations per second. MySQL Enterprise Backup supports a configurable 5 Percona XtraBackup skips secondary index pages and recreates them when a compact backup is prepared. MySQL Enterprise Backup skips
    分享到：
    赞 收藏

    相关推荐

    资料库

    数据库

    共收录1218份资料，累计14个分类，关注成员有19位，主要包括：NoSQL,MongoDB,Redis,SQLite,Memcached,DB2,Sybase,Informix,PostgreSQL,MySQL,SQLServer,Access,Oracle,其它

    热门标签

    NoSQL MongoDB Redis SQLite Memcached DB2 Sybase Informix PostgreSQL MySQL SQLServer Access Oracle 其它

    最新资料