XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。
例如执行增量备份的命令是:
# ./xtrabackup --backup --target-dir=/backup/delta --incremental-basedir=/backup/base
Percona XtraBackup 8.0.7 发布了,Percona XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。 此版本主要更新内容: 可以对包含加密系统表空间的数据库进行备份,现在也支持加密的 MySQL 表空间。 实现了对 lz4 压缩算法的支持,因此除了默认的 quicklz 方法之外,还可以使用 lz4(--compress = lz4) 进行压缩备份。 此外还有一些 bug 修复,详情查看更新说明: https://www.percona.com/blog/2019/08/07/percona-...
Percona XtraBackup 8.0.1 alpha 已发布了,这是第一个测试用的 XtraBackup for MySQL 8.0 版本,可用于 MySQL 8.0 备份。 值得注意的事项: 删除了已弃用的 innobackupex 命令 。 由于 MySQL 8.0 数据目录以及 redo 格式的变化,新的 Xtrabackup for MySQL 8.0 仅兼容 MySQL 8.0 ,以及即将推出的 Percona Server for MySQL 8.0.x 。 对于更早的版本的迁移,需要使用 XtraBackup 2.4 来备份和恢复,然后使用 MySQL 8.0.x 中的 ...
Percona XtraBackup 2.3.7 发布了,XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。主要更新如下: 新特性: Percona XtraBackup 实现了一个新的 --remove-original 选项,一旦那些加密和压缩文件已被解密/解压,可以用于删除它们。 Bugs 修复: XtraBackup was using username set for the server in a configuration file even if a different user was defined in the user’s configuration file. Bug fixed...
Percona XtraBackup 2.4.5 发布了。XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。主要更新如下: 新特性: Percona XtraBackup now supports SHA256 passwords. Using the SHA256 algorithm requires either SSL encrypted connection, or using public key encryption for password exchange which is only available when both client and server are linked with OpenSSL. Percona XtraBackup now supports...
XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。 Percona XtraBackup 2.2.10 发布,此版本现已提供在下载页面和 Percona Software Repositories。 此版本主要是 bug 修复: Decrypting backup with the wrong key would make the backup unusable and unrecoverable. Bug fixed #1413044. XtraDB Changed Page Tracking wasn’t working with innobackupex. Bug fixed #1436793. Fixed Percona XtraBackup asser...
XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。 Percona XtraBackup 2.2.9 发布,此版本现已提供在下载页面和 Percona 软件库。 更新内容: Bugs 修复: Percona XtraBackup was vulnerable to MITM attack which could allow exfiltration of MySQL configuration information via --version-check option. This vulnerability was logged as CVE 2015-1027. Bug fixed #1408375. xtrabackup_galera_info file...
Percona XtraBackup 2.2.8 发布了,XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。该版本基于 MySQL 5.6.22,修复了一些 bug: Bugs Fixed: Incremental backups would fail if the number of undo tablespaces (innodb_undo_tablespaces) was more than 1. This was caused by innobackupex removing the undo tablespaces during the prepare phase. Bug fixed #1363234. Fixed multiple memory leaks detect...
XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。 Percona XtraBackup 2.2.7 发布,此版本现已提供在下载页面或者 Percona 软件库。 Bugs 修复 Non-default value for innodb_log_block_size variable would cause assertion when preparing the backup. Bug fixed #1391216. When Percona XtraBackup would run FLUSH ENGINE LOGS during the backup process on GTID master, command was recorded to the slav...
XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。 Percona XtraBackup 2.2.6 发布,此版本现已提供在下载页面和Percona 软件库。此版本支持 Ubuntu 14.10 和 CentOS7。 更新内容如下: 新特性 Percona XtraBackup now reads server options from SHOW VARIABLES rather than my.cnf configuration file. Percona XtraBackup now has more verbose output during initial table scan (it will now print a diagnos...
MySQL 热备工具 Percona XtraBackup 2.2.5 发布,该版本重新基于 MySQL 5.6.21 进行开发。 修复了如下 Bug: The fix for bug #1079700 introduced a problem for users with huge numbers of InnoDB tablespaces, and the workaround of raising the open files limits didn’t work in all cases due to a limitation in the Linux kernel. A new innobackupex --close-files option has been implemented to close the file...
Percona XtraBackup 2.2.4 发布,此版本现已提供在下载页面和Percona Software Repositories。 新特性: Percona XtraBackup 实现对 Galera GTID auto-recovery 的支持 Bugs 修复: Percona XtraBackup is now built with system zlib library instead of the older bundled one. Bug fixed #1108016. apt-get source was downloading older version of Percona XtraBackup. Bug fixed #1363259. innobackupex would ignore the...
Percona XtraBackup 2.2.3 GA 发布,XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。 改进记录: 新特性: Percona XtraBackup implemented support for Backup Locks. Percona XtraBackup can now store backup history on the server itself in a special table created for that purpose. Percona XtraBackup has been rebased on MySQL 5.6.17. Bugs 修复: Fixed the InnoDB redo log incompatibility with ...
Percona XtraBackup 2.2.1 alpha 发布了,改进记录包括: New Features: Percona XtraBackup has removed the multiple binaries (xtrabackup_56, xtrabackup_55, xtrabackup) and now uses single xtrabackup binary instead for handling backups. Single binary implementation removed the requirement to download server source tarballs and removed different patches which resulted in cleaner code. Percona XtraBa...
Percona XtraBackup 2.1.8 发布,此版本是目前 2.1.x 系列的 GA 版本。现已提供下载,其他下载途径:Percona Software Repositories。 Bugs Fixed Due to incorrect usage of posix_fadvise() hints, Percona XtraBackup discarded read-ahead buffers which resulted in higher I/O rate on the backup stage. Bug fixed #1093385. Spurious trailing data blocks that would normally be ignored by InnoDB could lead to an...
Percona XtraBackup 2.1.7 发布,此版本包括了一些新特性和一些 bug 修复。更新内容如下: 新特性: Percona XtraBackup has now been rebased on MySQL versions 5.1.73, 5.5.35, 5.6.15 and Percona Server versions 5.1.73-rel14.11 and 5.5.35-rel33.0. Bug 修复: After being rebased on MySQL 5.6.11 Percona XtraBackup has been affected by the upstream bug #69780. Fixed by rebasing Percona XtraBackup on MySQL...
Percona XtraBackup 2.1.6 发布了,XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。 改进记录如下: New Features: Percona XtraBackup now supports logs created with the new log block checksums option innodb_log_checksum_algorithm in Percona Server 5.6 New innobackupex --force-non-empty-directories option has been implemented. When specified, it makes innobackupex --copy-back option or i...
Percona XtraBackup 2.0.8 发布了,XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。 该版本主要是 bug 修复: Percona XtraBackup 2.0 will now be offered in Percona Software Repositories. Bug fixed #1190055 Percona XtraBackup would assume the table has been dropped if the tablespace was renamed after it was scanned by Percona XtraBackup on startup and before Percona XtraBackup attempted...
Percona XtraBackup 2.1.4 发布了,XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。 改进内容包括: New Features: Percona XtraBackup has introduced additional options to handle the locking during the FLUSH TABLES WITH READ LOCK. These options can be used to minimize the amount of the time when MySQL operates in the read-only mode. Percona XtraBackup has now been rebased on MySQL versio...
Percona XtraBackup 2.1.2 for MySQL 发布了,XtraBackup 是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。 该版本主要修复了如下 bug: Using Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client introduced a regression which caused innobackupex –galera-info option to fail. Bug fixed #1180672. The format of xtrabackup_galera_info was missing the ‘:’...
Percona XtraBackup 2.1.1 GA 发布,改进记录包括: New Features: Percona XtraBackup 支持 紧缩备份. 可节省不少磁盘空间。包含新的 innobackupex –rebuild-threads 参数可用于指定在重构第二索引 (innobackupex --apply-log --rebuild-indexes) 启动的线程数。这个允许在重建索引时对单个表进行并行处理 Percona XtraBackup 实现了 加密备份. innobackupex 现在使用 Perl’s DBD::MySQL 包跟服务器通讯,替换 MySQL 命令行客...
评论