Percona XtraBackup 安装介绍篇

XtraBackup是Percona公司的开源项目,用以实现类似Innodb官方的热备份工具InnoDB Hot Backup的功能,它支持在线热备份(备份时不影响数据读写)。到目前为止,最新的版本为Percona XtraBackup 2.4.7.

XtraBackup有很多功能和优点:例如支持全备、增量备份、部分备份;支持压缩备份;备份不影响数据读写、事务等,但是也有缺陷不足:例如不支持脱机备份、不支持直接备份到磁带设备、不支持Cloud Back,MyISAM的备份也会阻塞。不过这些小瑕疵不影响XtraBackup成为一款流行的MySQL备份工具。另外,请注意XtraBackup只支持Linux平台,不支持Windows平台。

下面是XtraBackup的官方文档的介绍资料:

Percona XtraBackup is the worlds 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, MySQL, and MariaDB. It performs

streaming, compressed, and incremental MySQL backups.

Percona XtraBackup works with MySQL, MariaDB, and Percona Server. It supports completely non-blocking backups

of InnoDB, XtraDB, and HailDB 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.

Percona  XtraBackup的特征:

 

Features

 

Percona  XtraBackup

 

License

 

GPL

 

Pirce

 

Free

 

Streaming and encryption formats

 

Open source

 

Supported MySQL flavors

 

MySQL, Percona Server, MariaDB, Percona XtraDB Cluster, MariaDB Supported

 

Supported operating systems

 

Linux

 

Non-blocking InnoDB backups

 

Yes

 

Blocking MyISAM backups

 

Yes

 

Incremental backups

 

Yes

 

Full compressed backups

 

Yes

 

Incremental compressed backups

 

Yes

 

Fast incremental backups

 

Yes

 

Incremental backups with archived logs feature in Percona Server

 

Yes

 

Incremental backups with REDO log only

 

 

 

Backup locks

 

Yes

 

Encrypted backups

 

Yes

 

Streaming backups

 

Yes

 

Parallel local backups

 

Yes

 

Parallel compression

 

Yes

 

Parallel encryption

 

Yes

 

Parallel apply-log

 

Yes

 

Parallel copy-back

 

 

 

Partial backups

 

Yes

 

Partial backups of individual partitions

 

Yes

 

Throttling

 

Yes

 

Backup image validation

 

 

 

Point-in-time recovery support

 

Yes

 

Safe slave backups

 

Yes

 

Compact backups

 

Yes

 

Buffer pool state backups

 

Yes

 

Individual tables export

 

Yes

 

Individual partitions export

 

Yes

 

Restoring tables to a different server

 

Yes

 

Data & index file statistics

 

Yes

 

InnoDB secondary indexes defragmentation

 

Yes

 

rsync support to minimize lock time

 

Yes

 

Improved FTWRL handlin

 

Yes

 

Backup history table

 

 

 

Backup progress table

 

 

 

Backup to tape media managers

 

 

 

Cloud backups support

 

 

 

External graphical user interfaces to backup/recovery Zmanda Recovery

 

Zmanda Recovery Manager for MySQL

 

 

XtraBackup下载

 

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/539583ca2c052b81ea5c84e8420015e2.html