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 detected by AddressSanitizer. Bug fixed #1395143.
innobackupex could fail when preparing backup that was taken from Percona Server 5.5 with log files (innodb_log_file_size) bigger than
4G
. The root cause was that the last checkpoint LSN offset in log group is stored at different offsets inibdata1
for Percona Server 5.5 and MySQL 5.6 when the total size of log files is greater than4G
. Bug fixed #1403237.Percona XtraBackup out-of-source builds failed. Bug fixed #1402450.
http://www.percona.com/doc/percona-server/5.6/installation/apt_repo.html
sudo apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
sudo nano /etc/apt/sources.list 加入:
deb http://repo.percona.com/apt trusty main
deb-src http://repo.percona.com/apt trusty main
其中trusty是Ubuntu 14.04的代号,12.04的代号为precise。
sudo apt-get update 更新源,使sources.list生效。
apt-cache search percona 可以看到percona提供的所有工具,比如:
percona-server-server-5.5
percona-server-server-5.6
percona-xtradb-cluster
percona-toolkit
percona-xtrabackup
percona-zabbix-templates
percona-cacti-templates
percona-nagios-plugins
如果你只想安装5.6版本,只需要执行:
sudo apt-get install percona-server-server-5.6
http://www.percona.com/software
Percona Server with XtraDB : 采用XtraDB引擎的MySQL数据库.
Percona XtraDB : Percona基于InnoDB改进的高性能存储引擎.
Percona XtraDB Cluster : 基于XtraDB引擎的MySQL集群,强化主从复制机制.
Percona XtraBackup : InnoDB和XtraDB热备份工具.
http://www.percona.com/software/percona-xtrabackup
Percona Toolkit : 一系列用于分析管理MySQL的命令行工具.
http://www.percona.com/doc/percona-toolkit/2.2/pt-summary.html
Percona Monitoring Plugins : 能够跟Nagios,Cacti,Zabbix集成的企业级MySQL监控插件.
Percona Data Recovery Tool for InnoDB : 针对InnoDB引擎表的数据恢复工具.
Percona Playback : 一个用来回放MySQL数据库负荷的工具.
Percona tcprstat : TCP响应时间分析工具.